把你的DATAWINDOW 的SOURCE SYNTAX贴出来

解决方案 »

  1.   

    $PBExportHeader$d_shequ_zhu_hide.srd
    $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" )
      

  2.   

    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="宋体"
      

  3.   


    在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" )