A developer is attempting to reload a QVW when the script error displays:
Syntax error, missing/misplaced FROM: LOAD InvoiceNo,
DateInvoiced,
Today() - DateInvoiced AS InvoiceAgeInDays,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount,
InvoiceAmount - PaidAmount AS InvoiceBalance
SQL SELECT InvoiceNo,
DateInvoiced,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount
FROM dbo.Invoice;
LOAD InvoiceNo,
DateInvoiced,
Today() - DateInvoiced AS InvoiceAgeInDays,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount,
InvoiceAmount - PaidAmount AS InvoiceBalance
SQL SELECT InvoiceNo,
DateInvoiced,
DateDue,
LastPaymentDate,
InvoiceAmount,
PaidAmount
FROM dbo.Invoice;
How should the developer resolve the error?
> terminate the LOAD statement with a semi-colon (;) at the end of the field list
> add FROM dbo.Invoice to the end of the LOAD prior to the SQL statement
> add Resident Invoice to the end of the LOAD prior to the SQL statement
> move the misplaced FROM line above the LOAD line
