# 请问传入 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 & "')"

请帮忙解答， 感激不尽

Follow Ups:

- Re: 请问传入 SQL 的字串长度问题 老怪 17:13:38 9/27/98 (0)