orale 中的insert语法:
INSERT INTO TABLE_NAME (FIELD_1,FIELD_2,...) VALUES ( DATA_1,DATA_2,...);
UPDATE TABLE_NAME SET FIELD_1 = DATA_1 WHERE CONDITION;
INSERT INTO TABLE_NAME (FIELD_1,FIELD_2,...) VALUES ( DATA_1,DATA_2,...);
UPDATE TABLE_NAME SET FIELD_1 = DATA_1 WHERE CONDITION;
Me.TxtM0.Text 是我用VB传过来的值
INSERT INTO BBP_INV_DETAIL(M0,M1,M2) VALUES(SDF,DSF,DSF)可显示错误“列在此处不容许”
VB中好像直接写变量名就可以了。
设置两个变量:strinstert,strupdatestrinstert = "INSERT INTO BBP_INV(M0,M1,M2) VALUES('" & Me.TxtM0.Text & "','" & Me.TxtM1.Text & "','" & Me.TxtM2.Text & "')";strupdate = "UPDATE BBP_INV SET M0='" & Me.TxtM0.Text & "' WHERE M1=ABC";在执行时监视 strinstert,strupdate 这两个变量的值就可以了