General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I think the answer is yes.
Fox has a NUMERIC datatype. But NUMERIC is not a true datatype in most SQL databases (including Oracle and SQL Server). But I'm almost sure it is a legal alias in most databases commonly available.
So Numeric(18,6) should be an allowable column; and your remote view shouldn't know the difference.
Guy
>Hi all,
>Am using remote views to connect via ODBC to Oracle and Sql servers. For numeric data types in VFP, say 18 digits with 6 decimal points, what is the equivalent field types in Oracle and Sql servers?
>
>I'm trying to standardize to use only 1 type of remote view instead of 1 for Oracle and 1 for SQL server. Oracle offers the number data type while SQL server has money, numeric, float, decimal. If I want to have the equivalent of 18 digits and 6 decimal points in remote view, what data type is best for Sql server? If numeric is chosen, would the same remote view be able to access the number data type in Oracle?
>
>Thanks in advance
>Yau
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only