Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating an Image data type in SQL Server from Foxpro
Message
From
21/05/2003 12:21:27
Sergey Berezniker
New York, United States
 
 
To
21/05/2003 12:04:47
Christopher Thornburg
Total Resolutions
Tulsa, Oklahoma, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Updating an Image data type in SQL Server from Foxpro
Miscellaneous
Thread ID:
00790588
Message ID:
00791134
Views:
27
You cannot include huge string into sql command because of the VFP command size limitation (8k). You can use SQLEXEC parameters.
SQLEXEC(lnConn, "update cjtpdf set pdfimage = ?cBinaryData  where idnumber = '00001'")
>Here is my code:
>
<snip>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform