Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP vs SQL (compatibility)
Message
 
 
To
23/10/2001 02:36:26
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00571982
Message ID:
00571993
Views:
26
This message has been marked as the solution to the initial question of the thread.
>Hi Guys!
>
>I'm developing an application software using Visual Foxpro 7 and planning to migrate to SQL. Will the SQL recognize the functions of VFP& used in my current application?
>
>Thanks in advance...

If you're using Remote Views then SQL Server don't mind about what functions you used in manipulating the data. It's the responsibility of the Remote Views on what to do with your back-end data provided you set it up properly. If you're using SQL Pass Through, your statements should be ANSI SQL to be 100% compatible with SQL Server.

SQL Server functions are best executed in the DB Stored Procedures to make it server side, and let limit VFP functions into Client side.
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Reply
Map
View

Click here to load this message in the networking platform