pb中数据窗口中字段只显示255个的解决方法

1、数据库字段修改为text

select   convertf(text,sql)  as sql from tablename

2、transaction的属性修改

Transaction ltr_tmp

ltr_tmp = Create Transaction

ltr_tmp.DBMS = sqlca.DBMS

ltr_tmp.Database = sqlca.Database

ltr_tmp.ServerName = sqlca.ServerName

ltr_tmp.LogID = sqlca.LogID

ltr_tmp.AutoCommit = sqlca.AutoCommit

ltr_tmp.DBParm = "DBTEXTLIMIT='4096'"

ltr_tmp.LogPass = sqlca.LogPass

CONNECT Using ltr_tmp;

IF ltr_tmp.SQLCode = -1 THEN

MessageBox("连接",' 数据连接错误。')

RETURN -1

END IF

...

destroy ltr_tmp
  

 

转载于:https://www.cnblogs.com/kuailewangzi1212/archive/2012/07/06/2578901.html