>>>>>The file is read with the sqlexec and then made updateable view.
>>>>
>>>>You can do the same with a cursoradapter plus you can specify a schema. Can't give you an example, because the class I use already has the code for the fields I leave at default mapping, so I don't have to write any of it, just specify the fields where I want a non-default mapping. The code in the class is proprietary, sorry.
>>>
>>>We're not using CursorAdapter in that application.
>>
>>
>>CURSORSETPROP("MapBinary",0)
>>
>>?
>
>I've checked the code of this form.
>
>First it does LoadDataEnv (custom method to open all tables from SQL Server) and then
>
>dodefault()
>
>which has
>
>do set_setup
>cursorsetprop("MapBinary", .t., 0) && Maps image/varbinary(max) fields to blob in VFP
>
>So, is this line set too late (after everything was opened already) or it's fine?
Executing cursorsetprop("MapBinary", .t., 0) after SQLEXEC() is too late :-)
You should have it executed before any SQLEXEC().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.