I have a database that has currency settings to the standard 2 digit
decimal.
I have a foreign ODBC table (non-Rbase) that I need to connect to and
obtain data and this database has a 4 digit decimal currency.
When I SAttach to the ODBC table, all goes OK except the currency column
gets connected with the Rbase Database setting of 2 decimals and it
rounds the foreign data off which is causing me issues. I.E. if the
data in the ODBC table is 2.5551 it returns in RBase as 2.56
I cannot change the Rbase database currency setting for significant
reasons.
Can one attach an ODBC table and change/specify the data type? I.E. Can
I attach the ODBC table and force the data type to be DOUBLE for the
foreign currency column?
If so how?
Thanks,
Bob Thompson
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/b6566623-2fc1-bf7f-0360-e6d936de7509%40comcast.net.
