hi, i’m trying to insert values into an sql Database, i’ve created the connection with DECS, then with the designer, i’ve created a database with fields containing external data source, each fields contains one field of the table in the SQL Database, now i would create a button and when i click the button i want to insert a new record in the SQL db, how can i do that?
Thanks in advance
nik
Subject: [SQL] insert record into SQL Database
i think if u hav properly mapped the fields with the table it will automatically update the SQL Db when will you submit the document.
Subject: RE: [SQL] insert record into SQL Database
how can i submit the document?
which actions must done the button?
Subject: RE: [SQL] insert record into SQL Database
i’ve created a button that contains these commands:@Command([FileSave]);
@Command([CloseWindow]) ,when i clik the button the form close without any error but the record is added only in the domino db and not in the SQL db