4gl version : 7.32.uc2
ids version: 11.5.uc7
redhat : as5

$ cat test.4gl
database test
main
LOAD FROM '/tmp/temp.dat' DELIMITER "|" insert into tt
display "status=",status
end main
$ fglpc test
$ fglgo test
SQL error number -846.
Number of values in load file is not equal to number of columns

But it run in
ids version :ids9.40.uc5
4gl : 7.32.uc2
aix : 5
is OK !
Someone help me Please !

Consider s terminsting "|" in your load file.

j.


Sep 29, 2010 03:05:17 AM, joeclhua (AT) gmail (DOT) com wrote:

===========================================

4gl version : 7.32.uc2

Possibly an End-of-line problem (LF vis a vis CR/LF) ???

On Tue, Sep 28, 2010 at 11:08 PM, <jack.parker4 (AT) verizon (DOT) net> wrote:



--
John Fahey
President
Mitchell & McCormick, Inc.
2165 West Park Ct Suite G
Stone Mountain, GA 30087
(770) 465-1511

I doubt that it owing to ids vs 4gl version not matches.

That program had running for years on ids 9.4 & 4gl 7.32.uc2 aix box.

Recently migrate to linux,
ids 11.5 ( newest version) & 4gl 7.32.uc2 ( old version )

Seems that It not allow UNLOAD statemnt in 4GL program .

But is it possible that something about the O.S. change made it such that
the way the data (unload) file
was transferred to the server might have screwed up the E.O.L. in the file ?

On Wed, Sep 29, 2010 at 12:05 AM, joe <joeclhua (AT) gmail (DOT) com> wrote:



--
John Fahey
President
Mitchell & McCormick, Inc.
2165 West Park Ct Suite G
Stone Mountain, GA 30087
(770) 465-1511

On 9月29日, 下午12時55分, John Fahey <jjfa... (AT) gmail (DOT) com> wrote:
John,
Thanks! I got it.
the unload data file, has a carriage return inside .