Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using VFP to generate VB SQL selection Strings
Message
From
13/10/2003 10:11:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Title:
Using VFP to generate VB SQL selection Strings
Miscellaneous
Thread ID:
00838085
Message ID:
00838085
Views:
59
I am am writing an app using .net

Writing the SQL selection strings in .Net is the same PIA it always was in VFP until I started to use textmerge to create the SQL strings.

Since I normally use VFP as my main tool for managing data in SQL server it would be very handy if there was a VFP tool that could convert a VFP selection string into one correctly formatted for VB.

VB wants the following style
Dim QRY As String
QRY = "SELECT *" _
& " FROM Titles" _
& " WHERE [Year Published] > 1988"
Has anyone found any utilities for creating selection strings that may be of use to me
Next
Reply
Map
View

Click here to load this message in the networking platform