pcsoft.us.windevCopyright 2026, PC SOFT20 Jul 2017 00:53:00 Z19 Jul 2017 08:40:00 ZHi Folks In the HFSQL CC query window I have pasted my query from my development query to test. It has a parameter e.g.:{pInvoiceNumber}. How do I pass the parameter or do I have to always overtype with a value to test Would expect something like.... pID is int = 10 ; Select * from Invoices where invId = {pID} this gives error - unexpected word : int Any ideas appreciated30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter-61839/read.awp20 Jul 2017 00:53:00 ZThanks Fabrice I was hopeful. :(https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter-61839/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter-61839/read.awpHFSQL CC - Pass parameterguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter-61832/read.awp19 Jul 2017 13:46:00 ZHi Mark the query pane of the CC is pure sql, no wlanguage, so the whole parameter thing is out the window, and you will have…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter-61832/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/61828-hfsql-pass-parameter-61832/read.awpHFSQL CC - Pass parameter