Field not Found on Resident Load

[#1]

I am trying to get a resident load to work and I have now simplified the script as much as I can, still I get "Field Not Found" in the Resident Load when running it. Please help me understand what is wrong:

TestTable:

Load

          1+recno() as MyNumber

autogenerate 100;

TEST:

LOAD

          MyNumber as MyNewNumber

Resident TestTable;

[CELAMBARASAN]

There is no error on this script.

Please check the attached file for the scripts of yours itself.

[#3]

Hi.

Its working..There is no error while Resident TestTable

Regards-Bika

[Anonymous]

Hi,

Please insert the new column ie ' ' as Flag, in the resident table

TestTable:

Load

          1+recno() as MyNumber

autogenerate 100;

TEST:

LOAD

          MyNumber as MyNewNumber,

         ' ' as Flag

Resident TestTable;

Regards

Arun M

[#5]

You are all quite right in that there is nothing wrong in the script. Your answers made me realize that the problem must sit somewhere else, and that somewhere else was a QUALIFY clause in a preceding load. I didn't realize that once QUALIFY is declared it applies to everything afterwards. An "UNQUALIFY *" fixed the problem. But I wouldn't have figured that out this fast without the help from all of you. Thanks!