I used EOF and it works great!
On the other hand I observed BOF to always return false.
I expected BOF to be true after the query initially ran, and then go false after moving off first record.
I don't use BOF in practice so it's possible I'm missing something.
BD_ColumnCount%() works primo.
I'm off to test BD_ColumnName$(ord%)
8)
On the other hand I observed BOF to always return false.
I expected BOF to be true after the query initially ran, and then go false after moving off first record.
I don't use BOF in practice so it's possible I'm missing something.
BD_ColumnCount%() works primo.
I'm off to test BD_ColumnName$(ord%)
8)
While Not BD_RecordSetEOF%() j=j+1 Text 20, 130 + (j * 10), BD_GetColumn("O6ORD#")+", " + BD_GetColumn("ODPN") + ", "+ BD_GetColumn("H") + ", " + BD_GetColumn("W")+", " + BD_GetColumn("D")+", " + BD_GetColumn("SCOUNT") If j=40 Then j=0 BD_NextRecord() Flip Wend