把你的DATAWINDOW 的SOURCE SYNTAX贴出来
解决方案 »
- 关于两个结构完成相同的数据表, 快速比较数据
- 如何实现点击按钮后,从MYSQL数据库导出XLS文件并提示下载另存
- mysql -u root -h 127.0.0.1 为何会首先解析成 mysql -uroot -hlocalhost 呢?
- 请教插入数据问题,谢谢大家
- 请教用.sql后缀文件建立mysql数据库的方法
- 求助一个SQL语句
- case when判断日期长度
- 关于mysql远程访问
- 发个求助帖子关于mysql中文显示的
- mysql group by 查询的字段如果不用聚合函数,是怎么保留的?
- MySQL数据导入/导出问题
- 我在window2000中装了一个MySQL4 请问如何把它删除,卸载啊
$PBExportComments$天华社区主列表隐藏HIDE
release 6;
datawindow(units=0 timer_interval=0 color=16777215 processing=1 print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=72 color="536870912" )
footer(height=0 color="536870912" )
detail(height=84 color="536870912" )
table(column=(type=long update=yes updatewhereclause=yes key=yes name=id dbname="community_forum_main.id" )
column=(type=long update=yes updatewhereclause=yes name=sortid dbname="community_forum_main.sortid" )
column=(type=long update=yes updatewhereclause=yes name=userid dbname="community_forum_main.userid" )
column=(type=long update=yes updatewhereclause=yes name=date dbname="community_forum_main.date" )
column=(type=char(17) update=yes updatewhereclause=yes name=ip dbname="community_forum_main.ip" )
column=(type=long update=yes updatewhereclause=yes name=grade dbname="community_forum_main.grade" )
column=(type=char(50) update=yes updatewhereclause=yes name=title dbname="community_forum_main.title" )
column=(type=char(32766) update=yes updatewhereclause=no name=content dbname="community_forum_main.content" )
column=(type=char(50) update=yes updatewhereclause=yes name=photo dbname="community_forum_main.photo" )
column=(type=long update=yes updatewhereclause=yes name=reply_sum dbname="community_forum_main.reply_sum" )
column=(type=long update=yes updatewhereclause=yes name=hits dbname="community_forum_main.hits" )
column=(type=long update=yes updatewhereclause=yes name=good dbname="community_forum_main.good" )
column=(type=char(1) update=yes updatewhereclause=yes name=permission dbname="community_forum_main.permission" )
retrieve="PBSELECT(TABLE(NAME=~"community_forum_main~") COLUMN(NAME=~"community_forum_main.id~")COLUMN(NAME=~"community_forum_main.sortid~")COLUMN(NAME=~"community_forum_main.userid~")COLUMN(NAME=~"community_forum_main.date~")COLUMN(NAME=~"community_forum_main.ip~")COLUMN(NAME=~"community_forum_main.grade~")COLUMN(NAME=~"community_forum_main.title~")COLUMN(NAME=~"community_forum_main.content~")COLUMN(NAME=~"community_forum_main.photo~")COLUMN(NAME=~"community_forum_main.reply_sum~")COLUMN(NAME=~"community_forum_main.hits~")COLUMN(NAME=~"community_forum_main.good~")COLUMN(NAME=~"community_forum_main.permission~"))" update="community_forum_main" updatewhere=1 updatekeyinplace=no )
text(band=header alignment="2" text="Id"border="0" color="0" x="9" y="8" height="56" width="329" name=id_t font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Sortid"border="0" color="0" x="347" y="8" height="56" width="329" name=sortid_t font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Userid"border="0" color="0" x="686" y="8" height="56" width="329" name=userid_t font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="Date"border="0" color="0" x="1024" y="8" height="56" width="329" name=date_t font.face="宋体"
在MYSQL中TEXT的最大长度可达到65535,
也许是MYODBC或PB的BUG 吧,在PB中只映射成CHAR(32766)。
尝试一下:将
column=(type=char(32766) update=yes updatewhereclause=no name=content dbname="community_forum_main.content" )
改为
column=(type=char(65535) update=yes updatewhereclause=no name=content dbname="community_forum_main.content" )