Thanks,
When I Sattach to the ODBC table, it reads the column as currency (which
is 4 decimal in the foreign database) This is automatic and I do not
know how to change it. When Rbase picks up the currency datatype of the
ODBC column, it coverts it to a 2 digit and rounds it off. It is not
the Rbase column that is the issue, it is the currency setting.
If I attempt map a double column to the currency column in the ODBC
table it will fail and not connect. This is the issue.
I need to get the 4 decimal currency value from the ODBC table, but I
cannot change the currency decimal setting in my database, as it would
cause major, major issues many columns and tables and the associated
reports, forms and code.
I need to be able to Sattach the ODBC table and define column
"UnitPrice" as a double so it will return the 4 decimal, but I do not
see how to do that, or if it can be done.
This is causing a major issue tonight! 🙁
-Bob
On 3/2/2022 4:01 PM, Bruce Chitiea wrote:
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
<https://groups.google.com/d/msgid/rbase-l/em752b9aa3-2522-4724-8dcf-516c2051a574%40pathfinder?utm_medium=email&utm_source=footer>.
--
Robert Thompson
TTC. Inc.
219-363-7441
--
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/eb79f056-13a0-b77b-1cf1-f486caf1c945%40comcast.net.
