At 01:07 PM 6/24/2004 +0000, Bob Thompson wrote:
I have some more info on the "unsupported data type" mentioned on the
below attached thread.
I was mistaken when I stated I could not attach to the "Decimal" data type
fields. Looking more closely, I can attached to some, but not others. The
difference between the decimal type fields that I can link to and the
decimal type fields I cannot link to, is the precision listed in the
Pervasive database.
These fields are linking to Rbase as NUMERIC type fields, which default with
a (9 precision,0 scale) The Pervasive data base fields that are not linking
show values of 19 for precision and 0 for scale. The HELP context states
that Rbase defaults to 9 , but supports 1-15. Since 19 is not in the range
supported, it is erroring out.
Is there anyway to attach to these columns as I need to update data in an
urgent situation?
Bob,
Here is one way:
01. Start R:BASE 6.5++ (Build: 1.866xRT03 or higher) for Windows
02. CONNECT dbname
03. SDETACH ALL NOCHECK -- to detach any sattached table(s)
04. Create a dummy table in R:BASE with exactly the same column name(s)
(as in Pervasive database) but having the data type as DOUBLE in
R:BASE table.
05. Now SATTACH those tables from SCONNected data source and see what
happens.
The same technique applies when using R:BASE 7.x for Windows!
Hope that helps!
Very Best R:egards,
Razzak.
