UC知道关于主键查询
来源：百度知道 编辑：UC知道 时间：2024/05/12 02:17:49
我建了一个student表,里面有NO,NAME,SEX,BIRTHDAY,MEMBER,MAJOR_KEY字段,我将NO设为KEY,NAME和MAJOR_KEY为第二索引,进行如下查询:
query1.SQL.Add('select NO from student where NO between :s1 and :s2');
query1.Params.Clear;
query1.Params.CreateParam(ftstring,'s1',ptInput);
query1.Params.CreateParam(ftstring,'s2',ptInput);
query1.ParamByName('s1').AsString:=MaskEdit1.Text;
query1.ParamByName('s2').AsString:=MaskEdit2.Text;
查询学号从s1到s2的学生信息
运行是出现错误:invalid use of keyword
token:NO
line number:'1'
该如何解决?
还是不行啊,按你的代码就会报找不到's1'和's2'
query1.SQL.Add('select NO from student where NO between :s1 and :s2');
query1.Params.Clear;
query1.Params.CreateParam(ftstring,'s1',ptInput);
query1.Params.CreateParam(ftstring,'s2',ptInput);
query1.ParamByName('s1').AsString:=MaskEdit1.Text;
query1.ParamByName('s2').AsString:=MaskEdit2.Text;
查询学号从s1到s2的学生信息
运行是出现错误:invalid use of keyword
token:NO
line number:'1'
该如何解决?
还是不行啊,按你的代码就会报找不到's1'和's2'
我帮你改改代码
if query1.active then query1.close;
query1.sql.clear;
query1.sql.add('select NO from student where NO between :s1 and :s2');
query1.ParamByName('s1').Value := MaskEdit1.Text;
query1.ParamByName('s2').Value := MaskEdit2.Text;
query1.open;