★用pb调用Mysql数据库,当检索书据时出现类似错误 把你的DATAWINDOW 的SOURCE SYNTAX贴出来 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $PBExportHeader$d_shequ_zhu_hide.srd$PBExportComments$天华社区主列表隐藏HIDErelease 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" ) summary(height=0 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" ) 【SQL语句】怎么根据需求除去某列重复结果 sql语句的棘手问题,在线等,哪位大哥能给把力啊!急急急! mysql源码安装时遇到的问题,请高手赐教! mysql 好急! 请教一个sql优化. 请教:mysql用户变量实现分页的问题。 怎么写这样的sql 语句? 关于含自增列(为主键)的表的问题 sql create database on 出错 关于php数据库操作类 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" )