Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One thread, 2 questions, on Firebird use & ODBC VFP supp
Message
From
26/05/2004 08:11:54
 
 
To
26/05/2004 05:50:59
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00907196
Message ID:
00907277
Views:
13
>SQLEXEC(nConnHnd , [UPDATE {table} set {BLOB_COLUMN} = ?m.ImageContent WHERE ...])
>works, but , when retrieved back in a remote view, is corrupted.
That exactly what i found, Dorin!

>(I don't know how to determine VFP not to use General field in SPT for >this)

In order to make sure that VFP use a MEMO NOCPTRANS instead of the GENERAL format, I tried the update thru a CursorAdapter-based cursor as well. With a properly mapped field (MEMO NOCPTRANS ). Same Bug on upload.

Curiously enough, i was more successful when running thru a DBC-based remote view. But this application is fully dynamic. Data access is generated on-the-fly from a meta-model and there's no room for dbc in this app(:

>Somewhere between VFP -> ODBC or ODBC -> server >something take place, I >don't know what. But the guy who answer usually on the newsgroup must >know. That's why I told you to send a message there.

>If you provide him an ODBC trace log, he can fix rapidly, if is ODBC driver fault, and release >another usable build.

I'll try. Thank you for your support.

François
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform