Aleksey,
CursorFill(.t.) raises the problem, in fact. CursorFill() downloads the records, but the column is Integer. However, if the backend is MSSql Server, both CursorFill and CursorFill(.t.) make the column Logical.
I would like a way to make it stop that ;) If I change the CursorSchema for that column, no matter if it's L or I, in one of the cases CursorFill(.T.) fails. If the cursorschema is I and the backend is MSSQL Server, fails. If the cursorschema is L and the backend is MySQL, fails again.
So I have the way to change the backend on the fly, but the cursor is not the same - and my app fails. Any thoughts? Is there a way to force the cursoradapter to download MSSQL Server's bit datatype as Integer?
I can't post a repro code, because I did all those things in Command window.
Thank you.
>
>Hi Grigore,
>
>First, try to call CursorFill(.T.) instead of CursorFill(). If it doesn't solve the problem, post a repro code.
>
>Thanks,
>Aleksey.
Grigore Dolghin
Class Software.