Brent,
Few suggestions:
01. To be consistent with your ASCII file format, you could
DROP Sys_Rowver Column and make sure that Oterro.CFG and
RBASE.CFG files includes AUTOROWVER OFF.
02. Using the Direct DBMS action in R:Tango 2000, you could
also use:
LOAD TableName FROM FileName.ASC USING Col1, . Col6 AS ASCII
Note: I'm using Oterro 2000 (ver 2.5) beta, Non-R:Tango 2000
version.
I believe that Oterro 2000 (ver 2.0) for R:Tango 2000 does
not support USING col1 ... col6 options in LOAD command.
Very Best Regards,
Razzak.
At 10:43 PM 6/22/2001 -0700, Brent Skean wrote:
>I've come across the following that I will report through RDCC:
>
>In RBase 6.1a (not tested in 6.5...), if I have a table that has been
>altered and AUTOROWVER is ON, then a sys_rowver column is added. If there
>were 6 columns, there are now 7.
>
>If I have an ascii file that I wish to load into this table and the ascii
>file has 6 fields of data, the ascii file will be properly loaded into the
>table.
>
>In Oterro 2.0, using Tango 2K as the front end with a DBMS of
>
>load tablename from filename as ascii
>
>The 6 field ascii file will NOT load into a 6 field table that has a
>sys_rowver added onto the end (making it 7 fields). Error message of
>incorrect number of values.
>
>Removing the sys_rowver from the table allows the load to proceed from the
>DBMS.
===================================-============================
R:BASE Developers's Conference: http://www.rbase.com/conference
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
