[Firebird-test] beginner

[Alessandro G. <gr...@gr...>]

Hi to all ...

I'm new to Firebird and I'm tring to write some simple testing programs.
I have problems with quoting (I suppose).
The problem is : the execution of a statment with
isc_dsql_execute_immediate fail, the same statment in isql work perfectly.

I suppose is quoting cause the statment is 
INSERT INTO "parametro" ("tipo") VALUES ('v');

without quoting (") nothing work ... 
into the C program i use 
strcpy(sqlbuff,"INSERT INTO \"parametro\" (\"tipo\") VALUES ('v');");

the error i obtain is :
---begin---
SQLCODE: -104
SQL ERROR:
Invalid token
 
ISC STATUS:
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 13
-"parametro"
---end---

if i change and delte quoing in C ... 
strcpy(sqlbuff,"INSERT INTO parametro (tipo) VALUES ('v');");
the error become 
---begin---
SQLCODE: -204
SQL ERROR:
Undefined name
 
ISC STATUS:
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-PARAMETRO
-At line 1, column 13.
---end---

obviously the table exist :) 
in fact via isql all work. 

Both my program and isql run on the same computer, on the same server. 
Both client and server run on Linux. 
Firebird 1.0 (FirebirdSS-1.0.3.972-0.i386.rpm)

please help 

thanks in advance