Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with SQL UPDATE via SQLEXEC
Message
From
13/04/1998 09:17:18
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00091200
Message ID:
00091489
Views:
21
>> I created a line of text similar to what was giving me problems including carriage return/line feed characters (this was before I asked for help here) and the parser accepted it with no problem.
>
>So you tried something like:>cCmd= "update clmlog set descrip='Test " + chr(13) + ;
> "Description' where recno()=13"
>SQLExec(Hndl,cCmd)
>...and that worked ok?
>
>By the way, could the problem have been related to the length of the data in the editbox?

Yup, I tried something exactly like that only a little longer with more CR's. It worked fine. The length was about 30 total characters so I didn't see it as an issue. The sql engine would have reported a different error. I hope to hear from Microsoft today and if/when I do I'll post what they say to this thread.
Previous
Reply
Map
View

Click here to load this message in the networking platform