Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with SQL UPDATE via SQLEXEC
Message
De
13/04/1998 09:17:18
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00091200
Message ID:
00091489
Vues:
26
>> 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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform