This might be a feature request but also that I'm not using the database functionallity good enough.......
Why do the NextDatabaseRow (and simular) functions use the database handle and not a handle returned from e.g. the DatabaseQuery ? Would be far easier to do queries without having to create a new connection to the database that already are connected and keep the resultset in memory (or am I missing some functionallity doing it this way ?).
Something like (realy simple sample where join could be used but this is just for showing the idea ):
Code: Select all
statement1 = DatabaseQuery(#Database, "SELECT * FROM employee")
While NextDatabaseRow(statement1)
var = GetDatabaseString(statement1, 0)
statement2 = DatabaseQuery(#Database, "SELECT * FROM WhatEver where something = " + var)
varExtra = GetDatabaseString(statement2, 0)
FinishDatabaseQuery(statment2)
Wend
FinishDatabaseQuery(statment1)
EndIf
Eirik