A can only insert a field SQL, how to insert, all fields is inserted is not modified-CodePudding

Can only insert, cannot be modified.,,,,,,

CodePudding user response:

VB insert and modify the distinction is merely, insert a Addnew statements, change without Addnew statements, but in the modify the record must be must be linked with you need to modify the record , for example, the following statement is to insert statement:

 SQLY="select * from table Where ID=" & amp; XMF & amp; "
"RS. The Open SQLY, db, 3, 2

This statement is to modify the statement, connection is the ID=XMF record, no Addnew statements, the following insert statement is:

 SQLK="select * from table" 
Call SJK (db) 
RS. The Open SQLK, db, 3, 2 
RS. AddNew

This statement has a RS. AddNew statements, and are not connect specific data records,

CodePudding user response:

What is inserted into the field, is to change the table structure? It's best not to do,

If you mean to add a new record when writing field values, it is very simple,

CodePudding user response:

Insert into table name (field 1, 2,... , the field N) values (the value 1, 2,... And the value of N)