Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What should we use?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01355472
Message ID:
01355487
Views:
22
>>Right, but I want to have something which I can use without changes in both SQL and VFP. Also I just found I can not use INLIST, I have more than 24 codes.
>
>I don't think you'll be able to write something that will work on both databases. At least not something reasonably simple and maintainable.

I can with the UNION, but I decided to go against this idea. I can use placeholder and do update on my cursor afterwords, or update the rest of the code to use the check directly against this string.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform