SQL语句有错,改为:Insert Into jydjb (jydjh,sh,sm,ym,....) Values(Value1,Value2,Value2....)
其实就是将两个表的部分数据放到一个表中,我记得有这样的sql的语句: (针对你这个问题是:) insert into jydjb values(sh,sm,ym,zgbh,jyz,zw,jyks,jysq) select jydjh.sh,jydjh.sm,jydjh.ym,jydjh.zgbm,jydjh.jyz,jydjh.zw,jyks.jysq from jydjh,jyks
刚才写错了一些地方 其实就是将两个表的部分数据放到一个表中,我记得有这样的sql的语句: (针对你这个问题是:) insert into jydjb values(sh,sm,ym,zgbh,jyz,zw,jyks,jysq) select 表1的某些字段,表2的某些字段 from 表名1,表名2
query1.SQL.Add('insert into "jieshu" values(Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi,'+') select Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi from Book.db,Zhigong.db'); query1.ParamByName('Suoshuhao').asstring:=edit1.Text; query1.ParamByName('Suoquehao').asstring:=edit2.Text; 一按借阅按钮出现.....query1:parameter 'Suoshuhao' not found....的提示,(我没有TStorProc组件,能行吗?)
Everybody: query1.SQL.Add('insert into "jieshu" values(Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi,'+') select Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi from Book.db,Zhigong.db'); query1.ParamByName('Suoshuhao').asstring:=edit1.Text; query1.ParamByName('Suoquehao').asstring:=edit2.Text; 一按借阅按钮出现.....query1:parameter 'Suoshuhao' not found....的提示,(我没有TStorProc组件,能行吗?)
Everybody: query1.SQL.Add('insert into "jieshu" values(Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi,'+') select Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi from Book.db,Zhigong.db'); query1.ParamByName('Suoshuhao').asstring:=edit1.Text; query1.ParamByName('Suoquehao').asstring:=edit2.Text; 一按借阅按钮出现.....query1:parameter 'Suoshuhao' not found....的提示,(我没有TStorProc组件,能行吗?)
(针对你这个问题是:)
insert into jydjb
values(sh,sm,ym,zgbh,jyz,zw,jyks,jysq)
select jydjh.sh,jydjh.sm,jydjh.ym,jydjh.zgbm,jydjh.jyz,jydjh.zw,jyks.jysq
from jydjh,jyks
其实就是将两个表的部分数据放到一个表中,我记得有这样的sql的语句:
(针对你这个问题是:)
insert into jydjb
values(sh,sm,ym,zgbh,jyz,zw,jyks,jysq)
select 表1的某些字段,表2的某些字段
from 表名1,表名2
另外,query好像没有execute方法吧,应该用execsql或者open
query1.ParamByName('Suoshuhao').asstring:=edit1.Text;
query1.ParamByName('Suoquehao').asstring:=edit2.Text;
一按借阅按钮出现.....query1:parameter 'Suoshuhao' not found....的提示,(我没有TStorProc组件,能行吗?)
query1.SQL.Add('insert into "jieshu" values(Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi,'+') select Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi from Book.db,Zhigong.db');
query1.ParamByName('Suoshuhao').asstring:=edit1.Text;
query1.ParamByName('Suoquehao').asstring:=edit2.Text;
一按借阅按钮出现.....query1:parameter 'Suoshuhao' not found....的提示,(我没有TStorProc组件,能行吗?)
query1.SQL.Add('insert into "jieshu" values(Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi,'+') select Suoshuhao,Biaoti,Suoquehao,Bianhao,Keshi,Zhiwei,Renmin,J_riqi from Book.db,Zhigong.db');
query1.ParamByName('Suoshuhao').asstring:=edit1.Text;
query1.ParamByName('Suoquehao').asstring:=edit2.Text;
一按借阅按钮出现.....query1:parameter 'Suoshuhao' not found....的提示,(我没有TStorProc组件,能行吗?)