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?
Thank you,
-Bob
> I am trying to connect to an ODBC data source (Pervasive database) and
> get an error that the data type is not supported on several fields.
>
> Looking at the native database, it states that these fields are a type listed
> as "Decimal". (None of the listed fields have the same nomemclature that
> Rbase uses. I.E. smallint, decimal, char) However I am able to connect to the
> other columns except the type listed as Decimal. This column looks to simply be
> a real data type, however SATTACH is not connecting to it.
>
> Any ideas on how to gain access to columns as such? Any assistance will be
> greatly appreciated as a fairly urgent issue has arose.
>
> Thank you.
> -Bob
>
>
>
>
--- Begin Message ---
--- Begin Message ---
Hey Larry
You can udpate with a SRPL.. I wondered about this, but hadn't tried it
yet.
What is the Syntax for this.
Jim
Lawrence Lustig wrote:
I'm afraid I have to get this to work with 6.5++ DOS
RBase, so I'll just
write a
VB6 or VB.NET exe to do this.. Thanks
If it's a pure text file, and you know the largest
line length you will encounter, you can easily LOAD
the file into a single column table (where the column
is defined as TEXT with the length taken from the
largest line length, or NOTE) and then UPDATE with
SRPL. Not difficult at all.
--
Larry
|
--- End Message ---
--- End Message ---
