pcsoft.us.windevCopyright 2026, PC SOFT12 Jun 2017 23:58:00 Z12 Jun 2017 22:41:00 ZI am using HFSQL C/S files. I have a Payment file and a Receipt file. Payment is linked to Receipt by ReceiptID. How can I write a valid query that matches Payments with Receipts and sets Payment.Amount to the matching Receipt.Total? UPDATE Payment SET Payment.Amount = (SELECT Receipt.Total FROM Receipt WHERE Payment.ReceiptID = Receipt.ReceiptID) //ERROR : No analysis opened: Receipt file not described. UPDATE Payment SET Payment.Amount= Receipt.Total FROM Payment INNER JOIN Receipt ON Payment.ReceiptID = Receipt.ReceiptID //ERROR : Unexpected word: FROM. UPDATE Payment INNER JOIN Receipt ON Payment.ReceiptID = Receipt.ReceiptID SET Payment.Amount= Receipt.Total //ERROR: Unable to cast data to type of JOIN.AppliedAmount item. UPDATE Payment SET Payment.Amount = (SELECT Receipt.Total FROM Receipt WHERE Receipt.ReceiptID = Payment.ReceiptID) WHERE EXISTS (SELECT * FROM Receipt WHERE Receipt.ReceiptID = Payment.ReceiptID) //ERROR : No analysis opened: Receipt file not described. UPDATE Payment,Receipt SET Payment.Amount = Receipt.Total WHERE Payment.ReceiptID = Receipt.ReceiptID //ERROR: Unable to cast data to type of JOIN.AppliedAmount item.30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update-61285/read.awp12 Jun 2017 23:58:00 ZOops. Payment.Amount was set to text instead of currency. Now it works. Thanks kingdr.https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update-61285/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update-61285/read.awp[WD20] HFSQL Updateguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update-61284/read.awp12 Jun 2017 23:15:00 ZYou should do this as below: UPDATE Payment JOIN Receipt ON Payment.ReceiptID = Receipt.ReceiptID SET Payment.Amount= Receipt…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update-61284/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61281-wd20-hfsql-update-61284/read.awp[WD20] HFSQL Update