Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Image control doesn't show selected image
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01642403
Message ID:
01642509
Views:
61
This message has been marked as a message which has helped to the initial question of the thread.
>>>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform