Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cross-Platform Syntax?
Message
 
 
To
05/10/2001 23:58:30
Kenneth Downs
Secure Data Software, Inc.
New York, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00565093
Message ID:
00565315
Views:
18
Take a look at Thread #532360 for VFP to SQl Server comparison and at http://www.microsoft.com/SQL/techinfo/deployment/70/oraclemigrate.asp for SQL Server To Oracle.

>Folks,
>
>I noticed an earlier thread in which Miles asked about using a well-known VFP function in SQL.
>
>I have a similar question. I would like to be coding SQL expressions that are certain to run on any platform (well, you know, as much as one can be certain of such things).
>
>Is there an online resource, perhaps similar to the W3C, that publishes a standard for extended syntax elements such as string concatenation, type conversions, and other things? Does such a standard even exist?
>
>For instance, in VFP I might do something like
>
>
>SELECT TTOC(MyDateTime) as "CharDateTime", Column1 + Column2 as "TwoStringsTogether"....
>
>
>But I have been mixing VFP syntax into my SQL for so long that I do not know what I will be facing if I try to purify my code to be back-end independent. Can I still accomplish these things, or do I have to code up different versions because every back-end has a different command for ISNULL()?
>
>Any pointers much appreciated...
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform