语法问题！我是菜鸟……(5分)

R

redwood

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #1

我想问的是SQL语句中select段的长度超过了255，这就不能通过编译。我应该怎么办呀？

 

张

张一健

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #2

with DateSet do
begin
Close;
SQL.Clear;
SQL.Add(str1);
SQL.Add(str2);
.
.
Open/ExecSQL;
end;

 

R

redwood

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #3

看不懂……
比如说这一段
form2_query4.SQL.Add('SELECT Xueji_main.学号,Xueji_main.姓名,Xueji_main.专业,Xueji_main.班级,Xueji_chengji.课程,Xueji_chengji.成绩 FROM "xueji_main.DB" Xueji_main,"xueji_chengji.DB" Xueji_chengji WHERE Xueji_chengji.课程=:n and Xueji_chengji.成绩<60 and Xueji_main.学号=Xueji_chengji.学号');
后边的查询语句，放在哪里都是超长的

 

张

张一健

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #4

with form2_query4 do
begin
SQL.Clear;
SQL.Add('SELECT Xueji_main.学号,Xueji_main.姓名,Xueji_main.专业,Xueji_main.班级,Xueji_chengji.课程,Xueji_chengji.成绩');
SQL.Add('FROM "xueji_main.DB" Xueji_main,"xueji_chengji.DB" Xueji_chengji');
SQL.Add('WHERE Xueji_chengji.课程=:n and Xueji_chengji.成绩<60 and Xueji_main.学号=Xueji_chengji.学号');
Open;
end;

 

罗

罗子

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #5

with DateSet do
begin
Close;
SQL.Clear;
SQL.Add('SELECT Xueji_main.学号,Xueji_main.姓名,Xueji_main.专业,Xueji_main.班级,Xueji_chengji.课程,Xueji_chengji.成绩 FROM ');
SQL.Add('"xueji_main.DB" Xueji_main,"xueji_chengji.DB" Xueji_chengji ');
SQL.ADD(' WHERE Xueji_chengji.课程=:n and Xueji_chengji.成绩<60 and Xueji_main.学号=Xueji_chengji.学号');
Open;
end;

 

雪

雪中漫步

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #6

或者
sql.text:='SELECT Xueji_main.学号,Xueji_main.姓名,Xueji_main.专业,Xueji_main.班级,Xueji_chengji.课程,Xueji_chengji.成绩'+#13+
'FROM "xueji_main.DB" Xueji_main,"xueji_chengji.DB" Xueji_chengji'+#13+
'WHERE Xueji_chengji.课程=:n and Xueji_chengji.成绩<60 and Xueji_main.学号=Xueji_chengji.学号';

 

R

redwood

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-05

• #7

谢谢各位了