有两张表:表1(role),表2(userrole)
role表字段:roleid,rolename,re
userrole表字段:roleid,rolename,nameform中有一个listbox,窗体启动时listbox中显示role表中的rolename字段(多条记录)问题:
我怎样将listbox中显示的rolename字段所对应表的roleid和rolename写入到userrole表中,高手指点
role表字段:roleid,rolename,re
userrole表字段:roleid,rolename,nameform中有一个listbox,窗体启动时listbox中显示role表中的rolename字段(多条记录)问题:
我怎样将listbox中显示的rolename字段所对应表的roleid和rolename写入到userrole表中,高手指点
with adoquery do
begin
close;
sql.clear;
sql.text:= 'select * from role where roleName='''+ trim(listbox1.item[listbox1.itemindex])+'''';
open;
if recordcount <> 0 then
begin
with adoquery1 do
begin
close;
sql.clear;
sql.text:= 'inset into userrole(roleid,rolename) values('''+adoquery.fieldbyName('roleid').asstring+''','''+adoquery1.fieldbyName('rolename').asstring+''')';
try
execsql;
except
end;
end;
end;