Is DatabaseQuery result always on the 1st row?

[swhite]

After you have executed a DatabaseQuery() is the position in the result set always on the first row or is it necessary to always use
NextDatabaseRow(). For example if I know the result set only has one row can I immediately use functions like GetDatabaseString() etc without using NextDatabaseRow()?

I know I can test this but what I am looking for is understanding of exactly what Purebasic does so I can always count on the behavior as opposed to having stumbled on an undocumented feature that could change in future versions.

Thanks
Simon

[infratec]

You need

Code: Select all

If NextDatabaseRow()

Bernd

[Bisonte]

You need

Code: Select all

If NextDatabaseRow()

Bernd

Yes. After a DataBaseQuery() the pointer of the result row is not defined. so the NextDatabaseRow() command is needed to put it on the "next" element (or to the first row).

Its nearly the same behaviour like lists in PB.

[citystate]

if you only have a single row in a query, there's also

Code: Select all

FirstDatabaseRow(#Database)

as an option

[mk-soft]

if you only have a single row in a query, there's also

Code: Select all

FirstDatabaseRow(#Database)

as an option

Not all database drivers support them. '#PB_Database_DynamicCursor'