我的一个ADOQuery中的SQL语句如下:
select max(room.id) id,max(room.place) place,max(room.re) re
from room
where room.state=0
and room.room_level=:level
and (select count(sheet_items.id)
from sheet_items
where sheet_items.room=room.id
and (not(sheet_items.start_time>:end_time or
sheet_items.end_time<:start_time)))=0
group by room.id当用DBGrid用其中的数据时,老是提示:Parameter 对象被不正确的定义,提供了不完整或不一致的信息。
select max(room.id) id,max(room.place) place,max(room.re) re
from room
where room.state=0
and room.room_level=:level
and (select count(sheet_items.id)
from sheet_items
where sheet_items.room=room.id
and (not(sheet_items.start_time>:end_time or
sheet_items.end_time<:start_time)))=0
group by room.id当用DBGrid用其中的数据时,老是提示:Parameter 对象被不正确的定义,提供了不完整或不一致的信息。
from room
where room.state=0
and room.room_level=:level
and (select count(sheet_items.id)
from sheet_items
where sheet_items.room=room.id
and (not(sheet_items.start_time>:end_time or
sheet_items.end_time<:start_time)))=0
group by room.id
AdoQuery.Parambyname("Start_time"):=...