線上訂房服務-台灣趴趴狗聯合訂房中心
發文 回覆 瀏覽次數:1029
推到 Plurk!
推到 Facebook!

Query有字數的限制?

答題得分者是:william
kagaya
中階會員


發表:74
回覆:175
積分:59
註冊:2002-12-28

發送簡訊給我
#1 引用回覆 回覆 發表時間:2003-01-15 14:28:10 IP:61.219.xxx.xxx 未訂閱
原碼如下.q1是ADOQuery物件 錯誤訊息是string literals may have at most 255 elements 有解決的方法嗎?謝謝 form2.q1.Close; form2.q1.SQL.Clear; form2.q1.SQL.Add('select wdate as 記錄日期,high as 身高,weight as 體重,b2 as 胸,b12 as 頸,b3r as 上臂右,b3f as 上臂左,b32r as 前輩右,b32f as 前臂左,b22 as 腰,b23 as 臀,b4r as 大腿右,b4f as 大腿左,b42r as 小腿右,b42f as 小腿左,b51 as 血壓收,b52 as 血壓舒,b53 as 心跳 from cust2 where manid=''' form1.id.Text ''' order by wdate desc'); //form2.q1.SQL.Text:='select wdate as 記錄日期,high as 身高,weight as 體重,b2 as 胸,b12 as 頸,b3r as 上臂右,b3f as 上臂左,b32r as 前輩右,b32f as 前臂左,b22 as 腰,b23 as 臀,b4r as 大腿右,b4f as 大腿左,b42r as 小腿右,b42f as 小腿左,b51 as 血壓收,b52 as 血壓舒,b53 as 心跳 from cust2 where manid=''' form1.id.Text ''' order by wdate desc'; form2.q1.Open;
------
KUSO 無處不在
william
版主


發表:66
回覆:2535
積分:3048
註冊:2002-07-11

發送簡訊給我
#2 引用回覆 回覆 發表時間:2003-01-15 14:37:56 IP:147.8.xxx.xxx 未訂閱
It is because a string constant cannot exceed 255 characters. Try breaking the long string and add them using ' '.
系統時間:2024-06-18 2:01:50
聯絡我們 | Delphi K.Top討論版
本站聲明
1. 本論壇為無營利行為之開放平台,所有文章都是由網友自行張貼,如牽涉到法律糾紛一切與本站無關。
2. 假如網友發表之內容涉及侵權,而損及您的利益,請立即通知版主刪除。
3. 請勿批評中華民國元首及政府或批評各政黨,是藍是綠本站無權干涉,但這裡不是政治性論壇!