Quote: "for multiplayer, the multisync plugin is free and comes with excellent examples, it isnt difficult to get a lan connection going with thei nfo provided. "
Where do i download plugin ?
Quote: "for the database, there are a few plugins floating around for this, mostly sqlite3 i think. its a good place to start."
Where would i find the plugin for such?
DBErr$ as string
DBStr$ as string
Inst as integer
DBR as integer
ID as integer
Name$ as string
Age as integer
Active as boolean
Pie as float
Height as dword
` Set the instance you want to use
Inst = 0
` Connect to the database
DBR = DBConnect("Driver={Microsoft Access Driver (*.mdb)};Dbq=DBConn.mdb;Uid=Admin;Pwd=;")
` if connection succeeded
if DBR = 1
print "Connected to Database."
print "Press any key to continue."
print " "
sync
wait key
endif
` if there was an error
if DBR < 1
DBErr$ = DBError()
while len(DBErr$) > 60
print left$(DBErr$, 60)
print " "
DBErr$ = right$(DBErr$, len(DBErr$)-60)
endwhile
print DBErr$
print " "
print "Conn Error "
print "Press any key to exit."
sync
wait key
end
endif
` Run our test SQL Statement
DBR = DBRunSQL("SELECT * FROM Table1")
` If no rows are returned
if DBR = 0
print "No rows matched your query."
sync
endif
` How many rows were retrieved
if DBR > 0
print str$(DBR)+" rows returned."
print " "
sync
endif
` if there was an error
if DBR = -1
DBErr$ = DBError()
while len(DBErr$) > 70
print left$(DBErr$, 70)
DBErr$ = right$(DBErr$, len(DBErr$)-70)
endwhile
print DBErr$
print " "
print "Press any key to exit."
sync
wait key
end
endif
` Retrieve the data from the dataset
if DBR > 0
print "ID Name Age"
print "---------------"
for x = 0 to DBR-1
ID = val(DBGetDataByColNum(x, 0))
Name$ = DBGetDataByColNum(x, 1)
Age = val(DBGetDataByColNum(x, 2))
print str$(ID)+" "+Name$+" "+str$(Age)
next x
endif
print " "
print " "
` Run our test SQL Statement
DBR = DBRunSQL("SELECT * FROM Table1 ORDER BY ID DESC")
` If no rows are returned
if DBR = 0
print "No rows matched your query."
sync
endif
` How many rows were retrieved
if DBR > 0
print str$(DBR)+" rows returned."
print " "
sync
endif
` if there was an error
if DBR = -1
DBErr$ = DBError()
while len(DBErr$) > 70
print left$(DBErr$, 70)
DBErr$ = right$(DBErr$, len(DBErr$)-70)
endwhile
print DBErr$
print " "
print "Press any key to exit."
sync
wait key
end
endif
ID as integer
` Retrieve the data from the dataset
if DBR > 0
print "ID Name Age Active Pi Height"
print "-------------------------------------------------"
for x = 0 to DBR-1
ID = DBGetInt32(x, 0)
Name$ = DBGetString(x, 1)
Age = DBGetInt32(x, 2)
Active = DBGetBool(x, 3)
Pie = DBGetFloat(x, 4)
Height = DBGetDword(x, 5)
print str$(ID)+" "+Name$+" "+str$(Age)+" "+str$(Active)+" "+str$(Pie)+" "+str$(Height)
next x
endif
print " "
print "Press any key to exit."
sync
wait key
This is project demo od DBPro 7.7 but am having problems understanding it . It is not like Borland Turbo C++......I seem not to able to point it to my Db of MySQL off my server to play with it, but it seems to be locked on a internal setting some where.
Quote: "smaller components, pick one component"
Quote: "DBR = DBConnect("Driver={Microsoft Access Driver (*.mdb)};Dbq=DBConn.mdb;Uid=Admin;Pwd=;")
` if connection succeeded"
when i change this line c/command statement i have very little sucess of connecting to a non-local server... So I hope pick this smaller portion is better to ask about
Some times logic is a conclusion of the illogical ITems