script issue
Hello,
I met an interesting issue today. I had a script in one of my apps which has worked fine so far...nothing has changed as far as I know....
Here is the script:
input.Purchase_status = "sztornózva";
storno = insert into Purchase_form
[
Added_User=zoho.loginuser
Supplier_name=input.Supplier_name
Invoice_number=input.Invoice_number
Date_of_purchase=input.Date_of_purchase
Net_total=input.Net_total * -1
VAT_total=input.VAT_total * -1
Gross_total=input.Gross_total * -1
];
for each rec in input.Purchase_details
{
insert into Main_form_of_purchase
[
Added_User=zoho.loginuser
Product1=rec.Product1
Item_no=rec.Item_no
Unit_qty=rec.Unit_qty
Purchase_price=rec.Purchase_price
Qty_of_purchase1=rec.Qty_of_purchase1 * -1
Row_total=rec.Row_total * -1
Net_value=rec.Net_value * -1
VAT_value=rec.VAT_value * -1
Purchase_subform_lookup=storno
]
thisapp.Centralinventory.Aggrpurch(rec.Product1);
}
And it is not working now...??? Hmmmm
I'm getting this message
Error details:
log messages Due to invalid expressions insert statement is terminated Line:(2)
log messages Due to invalid expressions insert statement is terminated Line:(2) Any idea please?
George