When I try to search in this form using custom code and the correct SQL then get an error that it can't find the table.
- Code: Select all
Error loading primary key data, org.apache.commons.dbcp.DbcpException: java.sql.SQLException:
Table not found in statement [select "_sv_rowid" from "TEMP_7_ad574a26-df61-44c7-ac0b-cc644492516b" where "_sv_rowid" in (SELECT pk_id,unique_name FROM individuals WHERE upper(unique_name) LIKE upper(%?%)) order by "_sv_rowid" asc]
java.sql.SQLException:
Table not found in statement [select "_sv_rowid" from "TEMP_7_ad574a26-df61-44c7-ac0b-cc644492516b" where "_sv_rowid" in (SELECT pk_id,unique_name FROM individuals WHERE upper(unique_name) LIKE upper(%?%)) order by "_sv_rowid" asc]
Is this a limitation of working with custom datasources ?
Servoy 4.1.2 and 4.1.3
SQL Server 2005 (jtds)