Weird rowstoload count with sql..

[belotrei]

Refer to dzt's project (at dict.zip). He has mentioned this at code's comment. But i just want to make this sure.

code:
.....
cmd.CommandText = "select * from yyyy"
cmd.ExecuteTable("table1", RowsToLoad)
.....

The row which is showed always rowstoload-1. So if I set rowstoload = 2, just 1 row will be showed up (plus header). Set 1 and none of row is displayed (just the header).

So, the header is counted as row too or is it b4ppc's bug? (or maybe sql's bug?) Or that's a normal behaviour? Because that's make a little bit confusing...

Thanks Erel, again...

[Erel]

It's a bug in the SQL library.
It will be fix in the next update.

[belotrei]

That explained the problem.

Thanks Erel.

PS: B4ppc is a good software with AWESOME customer support that I've ever met. Already purchased many software but nothing compared to Erel. Incredibly fast reply and straight to the point answer. Often ask to myself, have you ever log out from b4ppc's forum and take a sleep, Erel?

[Erel]

Thanks belotrei
And don't worry, my wife says that I sleep enough