# Re: 请问传入 SQL 的字串长度问题

Posted by 老怪 on September 27, 1998 at 17:13:38:

In Reply to: 请问传入 SQL 的字串长度问题 posted by Haha on September 15, 1998 at 17:05:17:

: 请问各位，用 RDO 要传 SQL string 到 SQL SERVER 时,
: 自串长度太长，会不会有问题

: 因为我用的字串好像超过 256 个字元, 如下：

: sqls = "insert tablemeaningfacet (word,zhuyin,sense,meaningfacet,source," & _
: "lloce,cilin,freq,meaning,Constitutive,formal,telic,agentive,Collocates)" & _
: " values ('" & sWord & "','" & sZhuYin & "','" & sSense & "','" & txtMeaningFacet.Text _
: & "','" & txtSource.Text & "','" & txtLLOCE.Text & "','" & txtCILIN.Text _
: & "'," & txtFreq.Text & ",'" & txtMeaning.Text & "','" & txtQcon.Text _
: & "','" & txtQfor.Text & "','" & txtQtel.Text & "','" & txtQage.Text _
: & "','" & txtCollocates.Text & "')"

: 请帮忙解答， 感激不尽

做两个 QueryDef ，再用一个 Sql 去连两个 QureyDef。

Follow Ups: