SQL.Text:='Select BookNo,BookName,Author,Press,BorrowState form Book where BookName=:Name And Press=:Press And Author=:Author';
ParamByName('Name').AsString:=NameEdit.Text;
ParamByName('Author').AsString:=AuthorEdit.Text;
ParamByName('Press').AsString:=PressEdit.Text;
错误如下:
Project Project.exe raised exception class EDBEngineError with message
'General SQL error.[Microsoft][ODBC Microsoft Access Driver]语法错误(操作符丢失)在查询表达式'BorrowState form Book where BookName=Pa_RaM000 And
Press=Pa_RaM001 And Author=Pa_RaM002'中。'.Process stopped.....大虾说说看
什么理由!
ParamByName('Name').AsString:=NameEdit.Text;
ParamByName('Author').AsString:=AuthorEdit.Text;
ParamByName('Press').AsString:=PressEdit.Text;
错误如下:
Project Project.exe raised exception class EDBEngineError with message
'General SQL error.[Microsoft][ODBC Microsoft Access Driver]语法错误(操作符丢失)在查询表达式'BorrowState form Book where BookName=Pa_RaM000 And
Press=Pa_RaM001 And Author=Pa_RaM002'中。'.Process stopped.....大虾说说看
什么理由!
解决方案 »
- 方法指针要怎么用呢?
- 高分求:如何使用XMLDocument控件,取得节点的属性名称??!!
- 我还想问个问题,cxGrid新增一行,如果没有数据集打开就不能输入内容,怎么解决?
- 如何用delphi将结果集中的内容导出成excel格式?
- TClientdataset进行Insert操作后记录不是当前,而是最后,,是不是delphi的Bug
- 好难啊
- 有方法让delphi开发的程序在sco unix下运行么????
- 路过的,进来瞧瞧吧
- 关于xe5 android webservice连接数据问题
- 如何方便读UNIX下的文本文件
- 请问THyperStaticText是Delphi那个控件集中的控件
- 谁有应聘软件质量部经理的演讲报告,给我来一分,非常急!
from//
form and from;hehe;
SQL.Text:='Select BookNo,BookName,Author,Press,BorrowState form Book where BookName=:Name And Press=:Press And Author=:Author';
ParamByName('Name').AsString:=NameEdit.Text;
ParamByName('Author').AsString:=AuthorEdit.Text;
ParamByName('Press').AsString:=PressEdit.Text;
错误如下:Project Project.exe raised exception class EDBEngineError with message
'General SQL error.[Microsoft][ODBC Microsoft Access Driver]参数不足,期待是四。'Process stopped.....各位拜托了~
SQL.Text:='Select BookNo,BookName,Author,Press,BorrowState form Book wh
有没有搞错?form Book ?
应该是: from Book
ParamByName('Author').AsString:=AuthorEdit.Text;
ParamByName('Press').AsString:=PressEdit.Text;
AsString改为Value试试.
改为 From .
ParamByName('Author').value:=AuthorEdit.Text;
ParamByName('Press').valu:=PressEdit.Textplease have a try