Re: Issue with LOAD command

[aschmidt]

Try it this way -

LOAD tableview FROM filespec
NOCHECK
NONUM


It seems that when the LOAD command is run from a command file, it chokes
on ";" and requires that you use line feeds instead. At least that's the
way it works when loading a data-block.

Good luck!

Tony

Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY  11706

Voice 631-665-8100
Fax 631-969-5988



                                                                                       
                                    
                    Tom Grimshaw                                                       
                                    
                    <tomgrim@just4usoftwa        To:     [EMAIL PROTECTED]         
                                    
                    re.com.au>                   cc:                                   
                                    
                    Sent by:                     Subject:     Re: Issue with LOAD 
command                                  
                    owner-rbase-l@sonetma                                              
                                    
                    il.com                                                             
                                    
                                                                                       
                                    
                                                                                       
                                    
                    04/19/2001 06:44 AM                                                
                                    
                    Please respond to                                                  
                                    
                    rbase-l                                                            
                                    
                                                                                       
                                    
                                                                                       
                                    




Dear JM,

I think when Bill typed DELIM he meant SEMI.

If your SEMI is not set to ; try changing it to ; just prior to the command
then reverting it afterwards.

At 02:47 19/04/01 -0400, you wrote:
> >>
>What is your DELIM character?  If it is not ";" that could be your
>problem.
><<
>No, it is not.
>DELIMIT is set to ',' (comma), as usual in standard setting.
>But :
>LOAD TableName FROM FileName , NOCHECK, NONUM
>return error 2045 (Syntax is incorrect).
>It seems that the rigth syntax is
>LOAD TableName FROM FileName ; NOCHECK ; NONUM
>whatever is the DELIMIT setting ...

Warmest regards,


Tom Grimshaw
coy:    Just For You Software
tel:    61 (0)2 9552 3311
fax:    61 (0)2 9566 2164
email:  [EMAIL PROTECTED]
mobile: 0414 675 903
street: 3/66 Wentworth Park Rd  Glebe  NSW  2037
post:   PO Box 470  Glebe  NSW  2037  Australia

     _/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/       _/    _/_/_/_/_/
           _/         _/            _/     _/   _/
          _/         _/              _/ _/     _/
         _/         _/_/_/_/         _/        _/_/_/_/_/
        _/         _/               _/                 _/
_/   _/          _/               _/                 _/
   _/            _/               _/       _/_/_/_/_/