[GENERAL] Prepare / Execute Method Error

I'm having problems passing in variables into my execute statement. Any ideas? * * ** *Table:* CREATE TABLE cat.case ( vari character varying(50),--Contains Value ‘BDD1’ htnumeric(4,1) --Contains Value 30.0 ) *Statem

[GENERAL] Select Cast Error

I have a field that is varchar(15) type and an example of data I'm working with is (PROJ-0001-06)   I can make these two select statements work but not together. select cast((max(substring(test.test from 6 for 4))) AS INTEGER) + 1  FROM test;select max(substring(test.test from 11 for 2)) FROM tes