Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement causes foxpro error
Message
From
22/04/2002 14:17:23
Plamen Ivanov
J.E.I.
Varna, Bulgaria
 
 
To
22/04/2002 13:52:47
Chris Falk
IRM Systems
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: SQL Statement causes foxpro error
Miscellaneous
Thread ID:
00647711
Message ID:
00647741
Views:
9
If the problem really is in enter, try to use strtran() function:
lcDescrip = StrTran(lcDescrip, chr(13) + chr(10), '')
and then use lcDescrip in SQL Select statement.

Plamen Ivanov
MCSD .NET Early Achiever and MCAD .NET Charter Member (VB .NET/SQL Server 2000)
MCSD (VB 6.0/SQL Server 2000)
VB (.NET) - what other language do you need in the whole Universe?...

Previous
Reply
Map
View

Click here to load this message in the networking platform