Oracle7.3.4 中的 Insert 问题(50分)

在Query中加入:
query1.sql.add('insert into aaa(a,b) values(12,13)');
query1.sql.add('insert into aaa(a,b) values(13,14)');

query1.execsql 会报错,

报什莫错误。贴出来看看

<font color="#f000f0" face="隶书">谁知道?</FONT><font class=tt7 color=green face="隶书">是什么???</FONT>

<font color=red face="楷体">
"invaild character"
or
"SQL Command not properly ended"


</font>

你试一试这样：
query1.sql.Text:='insert into aaa(a,b) values(12,13)';
query1.sql.Text:=('insert into aaa(a,b) values(13,14)');
query1.execsql

oracle 不支持

多个语句不能一起执行！
必须分开执行：

Query1.Close;
Query1.Sql.Clear;
query1.sql.add('insert into aaa(a,b) values(12,13)');
query1.execsql;

Query1.Close;
Query1.Sql.Clear;
query1.sql.add('insert into aaa(a,b) values(13,14)');
query1.execsql;

同样的语句 SQL server 就可以，难道Oracle就不可以吗？

<font color="#f000ff" face="幼圆"><marquee border="0">分太少！！！<marquee></font>

<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=gb2312">
<script><!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->


<!--
// 东方美女精美壁纸流动播放程序http://m123.126.com -->
var gu=new Array()
gu[1]="http://www.tohome.net/m123/wallpaper/asian/mirei_kuroda/"
gu[2]="http://www.tohome.net/m123/wallpaper/asian/mizuho_nakamura/"
gu[3]="http://www.tohome.net/m123/wallpaper/asian/satomi_yoshida/"
gu[4]="http://www.tohome.net/m123/wallpaper/asian/aya_kawakami/"
gu[5]="http://www.tohome.net/m123/wallpaper/asian/ai_hashimoto/"
gu[6]="http://www.tohome.net/m123/wallpaper/asian/atsuko_okamoto/"
gu[7]="http://www.tohome.net/m123/wallpaper/asian/hiro_mamiya/"
gu[8]="http://www.tohome.net/m123/wallpaper/asian/atsuko_kurusu/"
gu[9]="http://www.tohome.net/m123/wallpaper/asian/kazue_fukiishi/"
gu[10]="http://www.tohome.net/m123/wallpaper/asian/ai_kato/"
gu[11]="http://www.tohome.net/m123/wallpaper/asian/luna_nagai/"
gu[12]="http://www.tohome.net/m123/wallpaper/asian/rena_tanaka/"
gu[13]="http://www.tohome.net/m123/wallpaper/asian/ryoko_hirosue/"
gu[14]="http://www.tohome.net/m123/wallpaper/asian/norika_fujiwara/"
gu[15]="http://www.tohome.net/m123/wallpaper/asian/noriko_kato/"
gu[16]="http://www.tohome.net/m123/wallpaper/asian/mariya_yamada/"
gu[17]="http://www.tohome.net/m123/wallpaper/asian/misao_aikawa/"
gu[18]="http://www.tohome.net/m123/wallpaper/asian/noriko_sakai/"
gu[19]="http://www.tohome.net/m123/wallpaper/asian/mai_hosho/"
gu[20]="http://www.tohome.net/m123/wallpaper/asian/ami_suzuki/"
gu[21]="http://www.tohome.net/m123/wallpaper/asian/yumiko_takahashi/"
gu[22]="http://www.tohome.net/m123/wallpaper/asian/akiko_hinagata/"
gu[23]="http://www.tohome.net/m123/wallpaper/asian/kanako_enomoto/"
gu[24]="http://www.tohome.net/m123/wallpaper/asian/kyoko_fukada/"
gu[25]="http://www.tohome.net/m123/wallpaper/asian/yoshino_kimura/"
gu[26]="http://www.tohome.net/m123/wallpaper/asian/hiroko_anzai/"
gu[27]="http://www.tohome.net/m123/wallpaper/asian/akiko_yada/"
gu[28]="http://www.tohome.net/m123/wallpaper/asian/asuka_yanagi/"
gu[29]="http://www.tohome.net/m123/wallpaper/asian/jun_matsuda/"
gu[30]="http://www.tohome.net/m123/wallpaper/asian/yuka/"
gu[31]="http://www.tohome.net/m123/wallpaper/asian/kokubu_sachiko/"
gu[32]="http://www.tohome.net/m123/wallpaper/asian/yukie_nakama/"
gu[33]="http://www.tohome.net/m123/wallpaper/asian/gigi_leung/"
gu[34]="http://www.tohome.net/m123/wallpaper/asian/yuki_hsu/"
gu[35]="http://www.tohome.net/m123/wallpaper/asian/vivian_hsu/"
gu[36]="http://www.tohome.net/m123/wallpaper/asian/kim_hee_sun/"
gu[37]="http://www.tohome.net/m123/wallpaper/asian/kelly_chen/"
gu[38]="http://www.tohome.net/m123/wallpaper/asian/s.e.s/"
gu[39]="http://m123.net/star/wallpaper/western/adriana_sklenarikova/"
gu[40]="http://m123.net/star/wallpaper/western/angela_lindvall/"
gu[41]="http://m123.net/star/wallpaper/western/eva_herzigova/"
gu[42]="http://m123.net/star/wallpaper/western/kate_moss/"
gu[43]="http://m123.net/star/wallpaper/western/laetitia_casta/"
gu[44]="http://m123.net/star/wallpaper/western/niki_taylor/"
gu[45]="http://m123.net/star/wallpaper/western/tyra_banks/"
var gi=new Array()
gi[1]="http://www.tohome.net/m123/wallpaper/asian/mirei_kuroda/007-.jpg"
gi[2]="http://www.tohome.net/m123/wallpaper/asian/mizuho_nakamura/002-.jpg"
gi[3]="http://www.tohome.net/m123/wallpaper/asian/satomi_yoshida/005-.jpg"
gi[4]="http://www.tohome.net/m123/wallpaper/asian/aya_kawakami/016-.jpg"
gi[5]="http://www.tohome.net/m123/wallpaper/asian/ai_hashimoto/015-.jpg"
gi[6]="http://www.tohome.net/m123/wallpaper/asian/atsuko_okamoto/006-.jpg"
gi[7]="http://www.tohome.net/m123/wallpaper/asian/hiro_mamiya/003-.jpg"
gi[8]="http://www.tohome.net/m123/wallpaper/asian/atsuko_kurusu/013-.jpg"
gi[9]="http://www.tohome.net/m123/wallpaper/asian/kazue_fukiishi/012-.jpg"
gi[10]="http://www.tohome.net/m123/wallpaper/asian/ai_kato/009-.jpg"
gi[11]="http://www.tohome.net/m123/wallpaper/asian/luna_nagai/005-.jpg"
gi[12]="http://www.tohome.net/m123/wallpaper/asian/rena_tanaka/016-.jpg"
gi[13]="http://www.tohome.net/m123/wallpaper/asian/ryoko_hirosue/019-.jpg"
gi[14]="http://www.tohome.net/m123/wallpaper/asian/norika_fujiwara/011-.jpg"
gi[15]="http://www.tohome.net/m123/wallpaper/asian/noriko_kato/023-.jpg"
gi[16]="http://www.tohome.net/m123/wallpaper/asian/mariya_yamada/009-.jpg"
gi[17]="http://www.tohome.net/m123/wallpaper/asian/misao_aikawa/009-.jpg"
gi[18]="http://www.tohome.net/m123/wallpaper/asian/noriko_sakai/027-.jpg"
gi[19]="http://www.tohome.net/m123/wallpaper/asian/mai_hosho/009-.jpg"
gi[20]="http://www.tohome.net/m123/wallpaper/asian/ami_suzuki/010-.jpg"
gi[21]="http://www.tohome.net/m123/wallpaper/asian/yumiko_takahashi/017-.jpg"
gi[22]="http://www.tohome.net/m123/wallpaper/asian/akiko_hinagata/030-.jpg"
gi[23]="http://www.tohome.net/m123/wallpaper/asian/kanako_enomoto/018-.jpg"
gi[24]="http://www.tohome.net/m123/wallpaper/asian/kyoko_fukada/020-.jpg"
gi[25]="http://www.tohome.net/m123/wallpaper/asian/yoshino_kimura/013-.jpg"
gi[26]="http://www.tohome.net/m123/wallpaper/asian/hiroko_anzai/001-.jpg"
gi[27]="http://www.tohome.net/m123/wallpaper/asian/akiko_yada/005-.jpg"
gi[28]="http://www.tohome.net/m123/wallpaper/asian/asuka_yanagi/001-.jpg"
gi[29]="http://www.tohome.net/m123/wallpaper/asian/jun_matsuda/023-.jpg"
gi[30]="http://www.tohome.net/m123/wallpaper/asian/yuka/013-.jpg"
gi[31]="http://www.tohome.net/m123/wallpaper/asian/kokubu_sachiko/016-.jpg"
gi[32]="http://www.tohome.net/m123/wallpaper/asian/yukie_nakama/013-.jpg"
gi[33]="http://www.tohome.net/m123/wallpaper/asian/gigi_leung/001-.jpg"
gi[34]="http://www.tohome.net/m123/wallpaper/asian/yuki_hsu/006-.jpg"
gi[35]="http://www.tohome.net/m123/wallpaper/asian/vivian_hsu/008-.jpg"
gi[36]="http://www.tohome.net/m123/wallpaper/asian/kim_hee_sun/041-.jpg"
gi[37]="http://www.tohome.net/m123/wallpaper/asian/kelly_chen/039-.jpg"
gi[38]="http://www.tohome.net/m123/wallpaper/asian/s.e.s/001-.jpg"
gi[39]="http://www.tohome.net/m123/wallpaper/western/adriana_sklenarikova/006-.jpg"
gi[40]="http://www.tohome.net/m123/wallpaper/western/angela_lindvall/014-.jpg"
gi[41]="http://www.tohome.net/m123/wallpaper/western/eva_herzigova/019-.jpg"
gi[42]="http://www.tohome.net/m123/wallpaper/western/kate_moss/019-.jpg"
gi[43]="http://www.tohome.net/m123/wallpaper/western/laetitia_casta/011-.jpg"
gi[44]="http://www.tohome.net/m123/wallpaper/western/niki_taylor/012-.jpg"
gi[45]="http://www.tohome.net/m123/wallpaper/western/tyra_banks/010-.jpg"

var galt=new Array()
galt[1]="mirei_kuroda 20 pictures"
galt[2]="mizuho_nakamura 20 pictures"
galt[3]="satomi_yoshida 16 pictures"
galt[4]="aya_kawakami 20 pictures"
galt[5]="ai_hashimoto 20 pictures "
galt[6]="atsuko_okamoto 18 pictures "
galt[7]="hiro_mamiya 20 pictures "
galt[8]="atsuko_kurusu 20 pictures "
galt[9]="kazue_fukiishi 20 pictures "
galt[10]="ai_kato 18 pictures "
galt[11]="luna_nagai 18 pictures "
galt[12]="rena_tanaka 20 pictures "
galt[13]="ryoko_hirosue 40 pictures "
galt[14]="norika_fujiwara 50 pictures "
galt[15]="noriko_kato 29 pictures "
galt[16]="mariya_yamada 40 pictures "
galt[17]="misao_aikawa 15 pictures "
galt[18]="noriko_sakai 79 pictures "
galt[19]="mai_hosho 16 pictures "
galt[20]="ami_suzuki 20 pictures "
galt[21]="yumiko_takahashi 20 pictures "
galt[22]="akiko_hinagata 30 pictures "
galt[23]="kanako_enomoto 20 pictures "
galt[24]="kyoko_fukada 20 pictures "
galt[25]="yoshino_kimura 20 pictures "
galt[26]="hiroko_anzai 30 pictures "
galt[27]="akiko_yada 12 pictures "
galt[28]="asuka_yanagi 11 pictures "
galt[29]="jun_matsuda 28 pictures "
galt[30]="yuka 40 pictures "
galt[31]="kokubu_sachiko 17 pictures "
galt[32]="yukie_nakama 20 pictures "
galt[33]="gigi_leung 40 pictures "
galt[34]="yuki_hsu 20 pictures "
galt[35]="vivian hsu 20 pictures "
galt[36]="kim hee sun 50 pictures "
galt[37]="kelly chen 60 pictures "
galt[38]="S.E.S 14 pictures "
galt[39]="adriana_sklenarikova 19 pictures "
galt[40]="angela_lindvall 20 pictures "
galt[41]="eva_herzigova 20 pictures "
galt[42]="kate_moss 20 pictures "
galt[43]="laetitia_casta 40 pictures "
galt[44]="niki_taylor 20 pictures "
galt[45]="tyra_banks 20 pictures "

gl=document.links.length;
gc=1
function ga(){
if(++gc==gu.length)gc=1
document.gn.src=gi[gc]
document.links[gl].href=gu[gc]
document.gn.alt=galt[gc]
}
document.write("<a href="+gu[1]+" target=_blank onclick=MM_openBrWindow('HTTP://m123.net','','')><img name=gn src="+gi[1]+" width=120 height=90 border=0 alt="+galt[1]+"></a>"); setInterval("ga()",5000);
document.write("<br><a href=http://m123.126.com target=blank>m123免费提供</a>" );
document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?meilvwz target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=meilvwz&amp;refer="+escape(document.referrer)+"&amp;cur="+escape(document.URL)+" border=0 width='1' height='1' alt='网易中文排行榜' ></a>");
document.write("<a href=http://top.263.net/count/top.dll?Type=sharkpwd&amp;id=9693&amp;ReferID=9693 target=_blank>");
document.write("<img src=http://top.263.net/count/top.dll?Type=Img2&amp;add=1&amp;id=9693&amp;refer="+escape(top.document.referrer)+" border=0 width='1' height='1' alt=263统计计数器>");
document.write("</a>");
document.write("<a href=http://www.topcn.com/siteinfo.asp?UserName=m123&amp;SiteType=0 target=_blank><img src=http://www1.topcn.com:8082/statistics.asp?m123&amp;referURL="+escape(top.document.referrer)+"&amp;curURL="+escape(top.document.URL)+"&amp;imgStyle=0"+" border=0 width='1' height='1' alt='Top中文网站龙虎榜' ></a>");
document.write("<a href=http://usa.nedstatbasic.net/cgi-bin/viewstat?name=m123><img src=http://usa.nedstatbasic.net/cgi-bin/nedstat.gif?name=m123 border=0 alt nosave width='1' height='1'></a>");
document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?topfree target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=topfree&amp;refer="+escape(document.referrer)+"&amp;cur="+escape(document.URL)+" border=0 width=0 height=0 alt=网易中文排行榜></a>");</script>

XieY:
I don't knnow what's your mean!!

oracle 的sql语法分析器不支持多sql.
oracle 和sql server 虽然都是关系数据库，但是没有道理要一样。
关于query中sql语句问题，你可以仔细地看看相关的help

<META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=gb2312">
<script><!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->


<!--
// 东方美女精美壁纸流动播放程序http://m123.126.com -->
var gu=new Array()
gu[1]="http://www.tohome.net/m123/wallpaper/asian/mirei_kuroda/"
gu[2]="http://www.tohome.net/m123/wallpaper/asian/mizuho_nakamura/"
gu[3]="http://www.tohome.net/m123/wallpaper/asian/satomi_yoshida/"
gu[4]="http://www.tohome.net/m123/wallpaper/asian/aya_kawakami/"
gu[5]="http://www.tohome.net/m123/wallpaper/asian/ai_hashimoto/"
gu[6]="http://www.tohome.net/m123/wallpaper/asian/atsuko_okamoto/"
gu[7]="http://www.tohome.net/m123/wallpaper/asian/hiro_mamiya/"
gu[8]="http://www.tohome.net/m123/wallpaper/asian/atsuko_kurusu/"
gu[9]="http://www.tohome.net/m123/wallpaper/asian/kazue_fukiishi/"
gu[10]="http://www.tohome.net/m123/wallpaper/asian/ai_kato/"
gu[11]="http://www.tohome.net/m123/wallpaper/asian/luna_nagai/"
gu[12]="http://www.tohome.net/m123/wallpaper/asian/rena_tanaka/"
gu[13]="http://www.tohome.net/m123/wallpaper/asian/ryoko_hirosue/"
gu[14]="http://www.tohome.net/m123/wallpaper/asian/norika_fujiwara/"
gu[15]="http://www.tohome.net/m123/wallpaper/asian/noriko_kato/"
gu[16]="http://www.tohome.net/m123/wallpaper/asian/mariya_yamada/"
gu[17]="http://www.tohome.net/m123/wallpaper/asian/misao_aikawa/"
gu[18]="http://www.tohome.net/m123/wallpaper/asian/noriko_sakai/"
gu[19]="http://www.tohome.net/m123/wallpaper/asian/mai_hosho/"
gu[20]="http://www.tohome.net/m123/wallpaper/asian/ami_suzuki/"
gu[21]="http://www.tohome.net/m123/wallpaper/asian/yumiko_takahashi/"
gu[22]="http://www.tohome.net/m123/wallpaper/asian/akiko_hinagata/"
gu[23]="http://www.tohome.net/m123/wallpaper/asian/kanako_enomoto/"
gu[24]="http://www.tohome.net/m123/wallpaper/asian/kyoko_fukada/"
gu[25]="http://www.tohome.net/m123/wallpaper/asian/yoshino_kimura/"
gu[26]="http://www.tohome.net/m123/wallpaper/asian/hiroko_anzai/"
gu[27]="http://www.tohome.net/m123/wallpaper/asian/akiko_yada/"
gu[28]="http://www.tohome.net/m123/wallpaper/asian/asuka_yanagi/"
gu[29]="http://www.tohome.net/m123/wallpaper/asian/jun_matsuda/"
gu[30]="http://www.tohome.net/m123/wallpaper/asian/yuka/"
gu[31]="http://www.tohome.net/m123/wallpaper/asian/kokubu_sachiko/"
gu[32]="http://www.tohome.net/m123/wallpaper/asian/yukie_nakama/"
gu[33]="http://www.tohome.net/m123/wallpaper/asian/gigi_leung/"
gu[34]="http://www.tohome.net/m123/wallpaper/asian/yuki_hsu/"
gu[35]="http://www.tohome.net/m123/wallpaper/asian/vivian_hsu/"
gu[36]="http://www.tohome.net/m123/wallpaper/asian/kim_hee_sun/"
gu[37]="http://www.tohome.net/m123/wallpaper/asian/kelly_chen/"
gu[38]="http://www.tohome.net/m123/wallpaper/asian/s.e.s/"
gu[39]="http://m123.net/star/wallpaper/western/adriana_sklenarikova/"
gu[40]="http://m123.net/star/wallpaper/western/angela_lindvall/"
gu[41]="http://m123.net/star/wallpaper/western/eva_herzigova/"
gu[42]="http://m123.net/star/wallpaper/western/kate_moss/"
gu[43]="http://m123.net/star/wallpaper/western/laetitia_casta/"
gu[44]="http://m123.net/star/wallpaper/western/niki_taylor/"
gu[45]="http://m123.net/star/wallpaper/western/tyra_banks/"
var gi=new Array()
gi[1]="http://www.tohome.net/m123/wallpaper/asian/mirei_kuroda/007-.jpg"
gi[2]="http://www.tohome.net/m123/wallpaper/asian/mizuho_nakamura/002-.jpg"
gi[3]="http://www.tohome.net/m123/wallpaper/asian/satomi_yoshida/005-.jpg"
gi[4]="http://www.tohome.net/m123/wallpaper/asian/aya_kawakami/016-.jpg"
gi[5]="http://www.tohome.net/m123/wallpaper/asian/ai_hashimoto/015-.jpg"
gi[6]="http://www.tohome.net/m123/wallpaper/asian/atsuko_okamoto/006-.jpg"
gi[7]="http://www.tohome.net/m123/wallpaper/asian/hiro_mamiya/003-.jpg"
gi[8]="http://www.tohome.net/m123/wallpaper/asian/atsuko_kurusu/013-.jpg"
gi[9]="http://www.tohome.net/m123/wallpaper/asian/kazue_fukiishi/012-.jpg"
gi[10]="http://www.tohome.net/m123/wallpaper/asian/ai_kato/009-.jpg"
gi[11]="http://www.tohome.net/m123/wallpaper/asian/luna_nagai/005-.jpg"
gi[12]="http://www.tohome.net/m123/wallpaper/asian/rena_tanaka/016-.jpg"
gi[13]="http://www.tohome.net/m123/wallpaper/asian/ryoko_hirosue/019-.jpg"
gi[14]="http://www.tohome.net/m123/wallpaper/asian/norika_fujiwara/011-.jpg"
gi[15]="http://www.tohome.net/m123/wallpaper/asian/noriko_kato/023-.jpg"
gi[16]="http://www.tohome.net/m123/wallpaper/asian/mariya_yamada/009-.jpg"
gi[17]="http://www.tohome.net/m123/wallpaper/asian/misao_aikawa/009-.jpg"
gi[18]="http://www.tohome.net/m123/wallpaper/asian/noriko_sakai/027-.jpg"
gi[19]="http://www.tohome.net/m123/wallpaper/asian/mai_hosho/009-.jpg"
gi[20]="http://www.tohome.net/m123/wallpaper/asian/ami_suzuki/010-.jpg"
gi[21]="http://www.tohome.net/m123/wallpaper/asian/yumiko_takahashi/017-.jpg"
gi[22]="http://www.tohome.net/m123/wallpaper/asian/akiko_hinagata/030-.jpg"
gi[23]="http://www.tohome.net/m123/wallpaper/asian/kanako_enomoto/018-.jpg"
gi[24]="http://www.tohome.net/m123/wallpaper/asian/kyoko_fukada/020-.jpg"
gi[25]="http://www.tohome.net/m123/wallpaper/asian/yoshino_kimura/013-.jpg"
gi[26]="http://www.tohome.net/m123/wallpaper/asian/hiroko_anzai/001-.jpg"
gi[27]="http://www.tohome.net/m123/wallpaper/asian/akiko_yada/005-.jpg"
gi[28]="http://www.tohome.net/m123/wallpaper/asian/asuka_yanagi/001-.jpg"
gi[29]="http://www.tohome.net/m123/wallpaper/asian/jun_matsuda/023-.jpg"
gi[30]="http://www.tohome.net/m123/wallpaper/asian/yuka/013-.jpg"
gi[31]="http://www.tohome.net/m123/wallpaper/asian/kokubu_sachiko/016-.jpg"
gi[32]="http://www.tohome.net/m123/wallpaper/asian/yukie_nakama/013-.jpg"
gi[33]="http://www.tohome.net/m123/wallpaper/asian/gigi_leung/001-.jpg"
gi[34]="http://www.tohome.net/m123/wallpaper/asian/yuki_hsu/006-.jpg"
gi[35]="http://www.tohome.net/m123/wallpaper/asian/vivian_hsu/008-.jpg"
gi[36]="http://www.tohome.net/m123/wallpaper/asian/kim_hee_sun/041-.jpg"
gi[37]="http://www.tohome.net/m123/wallpaper/asian/kelly_chen/039-.jpg"
gi[38]="http://www.tohome.net/m123/wallpaper/asian/s.e.s/001-.jpg"
gi[39]="http://www.tohome.net/m123/wallpaper/western/adriana_sklenarikova/006-.jpg"
gi[40]="http://www.tohome.net/m123/wallpaper/western/angela_lindvall/014-.jpg"
gi[41]="http://www.tohome.net/m123/wallpaper/western/eva_herzigova/019-.jpg"
gi[42]="http://www.tohome.net/m123/wallpaper/western/kate_moss/019-.jpg"
gi[43]="http://www.tohome.net/m123/wallpaper/western/laetitia_casta/011-.jpg"
gi[44]="http://www.tohome.net/m123/wallpaper/western/niki_taylor/012-.jpg"
gi[45]="http://www.tohome.net/m123/wallpaper/western/tyra_banks/010-.jpg"

var galt=new Array()
galt[1]="mirei_kuroda 20 pictures"
galt[2]="mizuho_nakamura 20 pictures"
galt[3]="satomi_yoshida 16 pictures"
galt[4]="aya_kawakami 20 pictures"
galt[5]="ai_hashimoto 20 pictures "
galt[6]="atsuko_okamoto 18 pictures "
galt[7]="hiro_mamiya 20 pictures "
galt[8]="atsuko_kurusu 20 pictures "
galt[9]="kazue_fukiishi 20 pictures "
galt[10]="ai_kato 18 pictures "
galt[11]="luna_nagai 18 pictures "
galt[12]="rena_tanaka 20 pictures "
galt[13]="ryoko_hirosue 40 pictures "
galt[14]="norika_fujiwara 50 pictures "
galt[15]="noriko_kato 29 pictures "
galt[16]="mariya_yamada 40 pictures "
galt[17]="misao_aikawa 15 pictures "
galt[18]="noriko_sakai 79 pictures "
galt[19]="mai_hosho 16 pictures "
galt[20]="ami_suzuki 20 pictures "
galt[21]="yumiko_takahashi 20 pictures "
galt[22]="akiko_hinagata 30 pictures "
galt[23]="kanako_enomoto 20 pictures "
galt[24]="kyoko_fukada 20 pictures "
galt[25]="yoshino_kimura 20 pictures "
galt[26]="hiroko_anzai 30 pictures "
galt[27]="akiko_yada 12 pictures "
galt[28]="asuka_yanagi 11 pictures "
galt[29]="jun_matsuda 28 pictures "
galt[30]="yuka 40 pictures "
galt[31]="kokubu_sachiko 17 pictures "
galt[32]="yukie_nakama 20 pictures "
galt[33]="gigi_leung 40 pictures "
galt[34]="yuki_hsu 20 pictures "
galt[35]="vivian hsu 20 pictures "
galt[36]="kim hee sun 50 pictures "
galt[37]="kelly chen 60 pictures "
galt[38]="S.E.S 14 pictures "
galt[39]="adriana_sklenarikova 19 pictures "
galt[40]="angela_lindvall 20 pictures "
galt[41]="eva_herzigova 20 pictures "
galt[42]="kate_moss 20 pictures "
galt[43]="laetitia_casta 40 pictures "
galt[44]="niki_taylor 20 pictures "
galt[45]="tyra_banks 20 pictures "

gl=document.links.length;
gc=1
function ga(){
if(++gc==gu.length)gc=1
document.gn.src=gi[gc]
document.links[gl].href=gu[gc]
document.gn.alt=galt[gc]
}
document.write("<a href="+gu[1]+" target=_blank onclick=MM_openBrWindow('HTTP://m123.net','','')><img name=gn src="+gi[1]+" width=120 height=90 border=0 alt="+galt[1]+"></a>"); setInterval("ga()",500);
document.write("<br><a href=http://m123.126.com target=blank>yun免费提供</a>" );
document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?meilvwz target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=meilvwz&amp;refer="+escape(document.referrer)+"&amp;cur="+escape(document.URL)+" border=0 width='1' height='1' alt='网易中文排行榜' ></a>");
document.write("<a href=http://top.263.net/count/top.dll?Type=sharkpwd&amp;id=9693&amp;ReferID=9693 target=_blank>");
document.write("<img src=http://top.263.net/count/top.dll?Type=Img2&amp;add=1&amp;id=9693&amp;refer="+escape(top.document.referrer)+" border=0 width='1' height='1' alt=263统计计数器>");
document.write("</a>");
document.write("<a href=http://www.topcn.com/siteinfo.asp?UserName=m123&amp;SiteType=0 target=_blank><img src=http://www1.topcn.com:8082/statistics.asp?m123&amp;referURL="+escape(top.document.referrer)+"&amp;curURL="+escape(top.document.URL)+"&amp;imgStyle=0"+" border=0 width='1' height='1' alt='Top中文网站龙虎榜' ></a>");
document.write("<a href=http://usa.nedstatbasic.net/cgi-bin/viewstat?name=m123><img src=http://usa.nedstatbasic.net/cgi-bin/nedstat.gif?name=m123 border=0 alt nosave width='1' height='1'></a>");
document.write("<a href=http://best.netease.com/cgi-bin/view/viewbasic.cgi?topfree target=_blank><img src=http://best.netease.com/cgi-bin/log.cgi?user=topfree&amp;refer="+escape(document.referrer)+"&amp;cur="+escape(document.URL)+" border=0 width=0 height=0 alt=网易中文排行榜></a>");</script>

是不是Oracle的语句分隔符与SQL Server不同呢?
try:
query1.sql.add('insert into aaa(a,b) values(12,13)；');
query1.sql.add('insert into aaa(a,b) values(13,14)；');
最后一个query1.sql.add中的与句中"；"可能不用加，都试一试吧。

搞不懂？
分开执行和一起执行有什么区别？

其实，在Query中写SQL就向在SQL*PLUS中一样，如果想执行多行SQL，就要用
PL/SQL（加BEGIN 。。。 END），但TQUERY是不支持PL/SQL的。用DOA吧，他是
针对ORACLE的，完全可以替代QUERY，DATABASE，STOREPROC

用PL/SQL
DECLARE
begin
insert into aaa(a,b) values(12,13);
insert into aaa(a,b) values(12,13);
end;
不会有问题，我一次加入1000条记录，

沈和windwy有道理

???

即使在pl/sql中，每一个sql语句（以“；”分隔）也不能包含两个insert子句。
这和在query中不能的道理是一致的.