Might you copy your fixed-decimal RBASE table to a temp table, redefine
the currency column as DOUBLE, then SATTACH to the temp table?
Best, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
rby...@safesectors.com | +011 (909) 238-9012 c | +011 (909) 912-8678 f
------ Original Message ------
From: "Robert Thompson" <ttc....@comcast.net>
To: rbase-l@googlegroups.com
Sent: 3/2/2022 1:30:53 PM
Subject: [RBASE-L] - Foreign Table Currency Column
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/b6566623-2fc1-bf7f-0360-e6d936de7509%40comcast.net.
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em752b9aa3-2522-4724-8dcf-516c2051a574%40pathfinder.
