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 ---
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.. ThanksIf 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 ---
