SQLBase ODBC and .NET Insert statement problem.

[dranath]

Hi All,

I get the following error:

ERROR [HY000] [Gupta][ODBC Driver][SQLBase]00915 PRS IVC Invalid constant

Has anyone any idea of how to get round the problem?
The insert command is only 2 fields!!
InsertCommand="INSERT INTO T_WEB(SURNAME,FORENAME) VALUES (@SURNAME,@FORENAME)"
<InsertParameters>
<asp:FormParameter Name="SURNAME" Type="String" FormField="surnameTextBox.Text" DefaultValue="name" />
<asp:FormParameter Name="FORENAME" Type="String" FormField="firstNameTextBox.Text" DefaultValue="name" />
</InsertParameters>

Thanks! Dran

 

[sjmulholland]

A potential problem with the sql is you are renerating

insert into a(b,c) values (henry,john)
where as you want the statment to read
insert into a(a,b) values('henry',john')

so may be your statement would be

cmd= "insert into a (a,b) values ('x1','x2')".replace("x1",surname).replace("x2",forename)

you could use your current format but you will have to handle the single qoutes yourself.