>> Hello:
>>
>>
>>> FbCommand cmd = new FbCommand("SYSTEMSETTINGS_IOU1", new
>>> FbConnection(c.ConnectionString));
>>> cmd.CommandType = CommandType.StoredProcedure;
>>> cmd.Parameters.Add("@IDSYSTEMSETTINGS", "NULL");
>>> cmd.Parameters.Add("@SETTINGNAME", "anotherparamvalue");
>>> cmd.Parameters.Add("@SETTINGVALUE", "anotherparamvalue");
>>> cmd.Parameters.Add("@SETTINGSGROUP", "anotherparamvalue");
>>>
>>>
>> What are the type of the parameters ???
>>
>>
>>
>>
>>
> The Parameters are:
> IDSYSTEMSETTINGS1 INTEGER, --> Primary Key
> SETTINGNAME1 VARCHAR(50) CHARACTER SET UNICODE_FSS,
> SETTINGVALUE1 VARCHAR(300) CHARACTER SET UNICODE_FSS,
> SETTINGSGROUP1 VARCHAR(20) CHARACTER SET UNICODE_FSS
I got it:
My mistake was, that i added the ID-Parameter as String, adding it with
"cmd.Parameters.Add("@IDSYSTEMSETTINGS", null);"
works. But there are no Changes made at the Database. The code is
executed without errors, but i don't find any new records at the DB.
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
