Database queries to work on handles
Posted: Wed Jan 16, 2013 9:10 am
The more I'm working with databases in PB, the more I wish the queries would work off handles of the query, not the database.
If we could
We could then use nested Queries w/o opening additional file handles; and if a threaded app, wouldn't have to have performance hit due to waiting for mutexes...
If we could
Code: Select all
hQueryHandle=databasequery(hDatabaseHandle,"Select * from Employees;")
if h
while NextDatabaseRow(hQueryHandle)
cLastname = GetDatabaseString(hQueryHandle,0)
wend
FinishDatabaseQuery(hQueryHandle)