Database queries to work on handles

jassing · Post by **jassing** » 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

Code: Select all

hQueryHandle=databasequery(hDatabaseHandle,"Select * from Employees;")
if h 
while NextDatabaseRow(hQueryHandle)
  cLastname = GetDatabaseString(hQueryHandle,0)
wend
FinishDatabaseQuery(hQueryHandle)

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...