Base 7.0.4.2 (x64) Firebird DB Windows 10
I have a View ‘V_ClientSelect’ which includes a column ‘Client_ID’. A simple query SELECT * FROM "V_ClientSelect"
works. When I add a parameter to specify a value for ‘Client_ID’, I get an SQL Error which says the parameter placeholder is an unknown column. See images attached. Driving me nuts.
Run in direct SQL mode, the error says:
*SQLDA error
*Data type unknown
*at SQLVAR index 0