Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need advice with long vfp commands over 254 characters
Message
From
18/02/2005 20:14:21
Chuong Vu
Bentek
San Jose, California, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Need advice with long vfp commands over 254 characters
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP3
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
00981108
Message ID:
00988539
Views:
26
You can break it up
Example Like this below

Var1="Select Field1, Field2,Field3,Field4.............etc.... "
Var2="Field100, Field101, Field102 From Item Where .........etc"

Var=Var1+Var2
=sqlexec(SQlConnect,Var)

It should work. Good Luck
Previous
Reply
Map
View

Click here to load this message in the networking platform