[PB 5.22 x86] FirstDatabaseRow VFP Driver

[Flype]

Hi PB Team,

I think there's a bug with the FirstDatabaseRow() function - at least with UseODBCDatabase() and the Microsoft Visual FoxPro Driver.

FirstDatabaseRow() returns 0 while NextDatabaseRow() returns <> 0

If you need more / sample code, i could do.

By the way, this bug isn't new with 5.22 (i think it could be very old) - and this might not be a 'real' PB bug but more a 'not supported function' in some ODBC drivers (?)

[DK5UR]

Hi Flype,
Did you check the "new" flags for OpenDatabase()?

[Flype]

Ah yes, you're right. I didn't see those new flags.

You mean, #PB_Database_DynamicCursor & #PB_Database_StaticCursor to be used in DatabaseQuery().

Ok, i will have to try this at work next week.

So, maybe no bug. Sorry for the inconveniance.

[DK5UR]

Ah, yes DatabaseQuery()...
I'm not at a computer, just have that problem with the flags in mind

[Flype]

It was enough, thanks

[Flype]

Checked and ok !

You were right, it's ok with to use FirstDatabaseRow() with DatabaseQuery(myDb, myQuery, #PB_Database_DynamicCursor)

So, no bug, sorry.