Thx for the reply, I do indeed want to insert a value from the inserted record in another table, but I still can't get this to work.
When I try what you suggest, I get an error during compilation :
Artikeleninfo.cs(1091,95):Error CS1002 ; expected
Artikeleninfo.cs(1091,108):Error CS1002 ; expected
I used this:
string sInsertSql = "INSERT INTO Voorraad (artikelnummer, locatie, aantal) VALUES (rsnew["Artikelnummer"], 'EM', 0)";
ew_Execute(sInsertSql);
After that I've tried to use single quote's (rsnew['Artikelnummer']), then the page does compile, however I get an error on the page after adding (Incorrect syntax near ''Artikelnummer''.)
This is the whole piece:
// Row Inserted event
public void Row_Inserted(OrderedDictionary rsold, OrderedDictionary rsnew) {
//ew_Write("Row Inserted");
// Insert record
// NOTE: Modify your SQL here, replace the table name, field name and field values
string sInsertSql = "INSERT INTO Voorraad (artikelnummer, locatie, aantal) VALUES (rsnew['Artikelnummer'], 'EM', 0)";
ew_Execute(sInsertSql);
}