Thanks Razzak,
>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.
Nice feature.... I liked Albert Berry's suggestion and here it is... RBASE
et al evolves at an astonishing rate!!
Brent
-----Original Message-----
From: A. Razzak Memon <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, June 28, 2001 8:10 AM
Subject: Re: Oterro 2.0 load command - Razzak's Reply
>
>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.
>==================================-=============================
>
