修改数据纪录的一个问题.(30分)

M

moutocean

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #1

有一段程序:
with query1do
begin
close;sql.clear;
sql.add('update "d:/employee1.db"');
sql.add('set lastname='tt' ');
open;
end;
编译时有错误,why?而且错误出在'set lastname='tt' '处.

 

W

wgzhang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #2

注意引号配对,tt前的引号改为双引号,就向上一句一样

 

B

Blade

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #3

使用单引号时用''，
...
SQL.Add('Set lastname=''tt''');
...

 

M

menxin

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #4

想用单引,可以这样.
sql.add('set lastname=''tt''');

 

T

tai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #5

open也不对，好象是应该execsql;

 

M

moutocean

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #6

按诸位的指导程序改为下:
with query1do
begin
close;query1.active:=true;
sql.clear;
sql.add('update "d:/employee1.db"');
sql.add('set lastname=''tt'' ');
execsql;
end;
编译时还是有错误:
unexpected end of command
token:
line number :1
why?

 

L

LSS

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-24

• #7

把单引号改成双引号，SQL支持双引号

 

W

wgzhang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-25

• #8

with query1do
begin
close;
// query1.active:=true;
//错在这一句
sql.clear;
sql.add('update "d:/employee.db"');
sql.add('set lastname=''aa''');
//或者sql.add('set lastname="aa"');
execsql;
end;

 

M

moutocean

Unregistered / Unconfirmed

GUEST, unregistred user!

• 1999-07-25

• #9

多人接受答案了。