|
| HFSQL CC - Pass parameter |
| Iniciado por guest, 19,jul. 2017 08:40 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 19,julio 2017 - 08:40 |
Hi 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 appreciated |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,julio 2017 - 13:46 |
Hi 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 to overwrite with the value
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 00:53 |
Thanks Fabrice
I was hopeful.  |
| |
| |
| | | |
|
| | | | |
| | |
|