Database questions

[meester]

I have two simple(?) questions about databases.

1) Is there a way to add a new record to a database with SWF-kit

2) Is there a way to save records with empty fields.
I always get the following error:

Microsoft JET Database Engine:Waarden voor een of meer vereiste parameters ontbreken.. See also: .
update getallenkennis set OM1='222',OM2=444,OM3=444,OM4=444,OM5=undefined,OM 6=undefined,OM7=undefined,OM8=undefined,OM9=undefi ned,OM10=undefined where id=2

[SWFKit]

Hi,

you can add a new record to a database by two ways
1)Using the INSERT statement
insert into getallenkennis (id, OM1, OM2, OM3, OM4)
values (2, '222', 444, 444, 444)

2)Using the addnew method

rs.addnew();
rs.Fields["id"].value = 3;
rs.Fields["OM1"].value = "222";
rs.fields["OM2"].value = 444;
rs.fields["OM3"].value = 444;
rs.fields["OM4"].value = 444;

rs.update();

To save records with empty fields, please try

"update getallenkennis set OM1='222',OM2=444,OM3=444,OM4=444,OM5=,OM6=,OM7=,O M8=,OM9=,OM10= where id=2"

"undefined" is a FFish Script variable, I think it has not been treated as empty by the SQL driver