Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server, MySQL, PostgreSQL common data types
Message
From
20/07/2012 06:53:52
 
 
To
19/07/2012 15:55:36
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01548865
Message ID:
01548888
Views:
50
>If I want to develop for all these database engines: SQLServer, MySQL, PostgreSQL which are the common data types that I should select in order to have single VFP codebase?
>
>For logical values, for money, for text?

Sorry for tackling your thought process from sideways, but if you want to have a vfp codebase,
I'd code in the best way vfp offers with all those data types available in vfp
and worry about the backends exactly when each backend is asked for.

Delegate such questions to your data access layer:
Map the best type of each backend into the vfp column via a special cursoradapter classes.
It is very doubtful that besides logical values sometimes done via 1/0 numerical or bit types
the backend will have less options than the dated vfp - if so, create a special char field
and corresponding transformation methods.

multi-backend SP dev is not possible with this, but IMHO also not really an option:
you use SP to get the benefit of backend specialities (beisides other benefits).

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform