table1 对应员工表,表的主关键字段是oracle的employee_id.nextval,怎样插入记录?
以下为什么会提示错误?
var
next_id:integer;
query1.sql.add('select employee_id.nextval into next_id from dual');
table1.filedbyname('id').asinteger:=next_id;
以下为什么会提示错误?
var
next_id:integer;
query1.sql.add('select employee_id.nextval into next_id from dual');
table1.filedbyname('id').asinteger:=next_id;
query1.sql.add('INSERT INTO table1 (employee_id,……) Select employee_id.nextval,…… From dual');
query1.SQL.Clear;
query1.SQL.Add('insert into bb values(xu.nextval,:wname,:wpric)');
query1.ParamByName('wname').AsString:=edit2.Text;
query1.ParamByName('wpric').AsInteger:=strtoint(edit3.Text);
query1.Prepare;
query1.Open;
错误:erro cusor