Hi all, in table “software”
|ID|App|Note|
|-|-|-|
|0|Writer|text editor|
|1|Calc|spreadsheet|
|2|Draw|drawing|
|3|Impress|presentation|
when exec SELECT * FROM software, I get all records from table.
But when exec SELECT * FROM software WHERE Note SIMILAR TO ‘r$’, I get error
1: firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -204
*Table unknown
*SOFTWARE
*At line 1, column 22
caused by
‘isc_dsql_prepare’
Where is issue?