Script Error

[#1]

Hi,

Im having a problem, I load a data and it says that the field is not found, but in the DB the field is there,

These are the field I load in DB:

BldgAssmt:

LOAD "area",

    BINum,

    depreciation,

    MDINum,

    Parcel,

    PCINum,

    pin,

    SINum,

    "unit-val",

    yr;

SQL SELECT "area",

    BINum,

    depreciation,

    MDINum,

    Parcel,

    PCINum,

    pin,

    SINum,

    "unit-val",

    yr

FROM PUB."Bldg-ASSMT";

But when it comes to QVD, the the first field has a script error:

Field not found - <area>

BldgAssmt:

LOAD "area",

    BINum,

    depreciation,

    MDINum,

    Parcel,

    PCINum,

    pin,

    SINum,

    "unit-val",

    yr

  FROM

(qvd)

Please Help me on this

[Ralf-Narfeldt]

If you do

LOAD *

  FROM

(qvd);

Do you get the area field loaded?

[sunny_talwar]

May be try area without the double quotes around it

[#4 · Accepted solution]

i figure it out guys, I stored it in the wrong table. LOL
I check it and the problmes is this:

Store Owner into C:\Users\SAMSUNG\Desktop\Lester RPTAS\RPTAS NEW\BldgAssmt.qvd;

It should be this:

Store BldgAssmt into C:\Users\SAMSUNG\Desktop\Lester RPTAS\RPTAS NEW\BldgAssmt.qvd;