The data is recorded on mysql in lower case, but when xbrowse displaying, it's on upper case.
Why? How I can put this data on lower case?
It is certain that xBrowse does not convert the case of data, unless you yourself provided a picture clause like '@!'
You may please recheck ( by msginfo ) the exact case of the data you read from mysql table.
oBrwSis := TXBrowse():new( oFolder:aDialogs[1] )
WITH OBJECT oBrwSis
:lHeader := .F.
:lFooter := .F.
:lRecordSelector := .F.
:aCols[2]:nWidth := 200
:aCols[3]:nWidth := 200
:aCols[4]:nWidth := 450
END
In the above code, where did you inform the xbrowse what object to browse and what columns to browse? In the absense of any information xbrowse by default browses the default workarea ( of the dbfs open ).
Is it the full code for constructing the browse?
nageswaragunupudi wrote:In the above code, where did you inform the xbrowse what object to browse and what columns to browse? In the absense of any information xbrowse by default browses the default workarea ( of the dbfs open ).
Is it the full code for constructing the browse?
If you have not already done, better you use explicity setrdd method by explicity specifying the alias.
oBrw:cAlias := <TheAliasYouWantToBrowse>
oBrw:SetRdd()
or
<DesiredAlias>->( oBrw:SetRDD() )
Then I am sure XBrowse will show fields from that alias and be rest assured that xbrowse does not do any case conversions on its own.
using the command syntax helps us to avoid many mistakes we may commit.
REDEFINE XBROWSE oBrw OF oDlg:aFolders[1] ALIAS "youralias" OR RECSET "mysqlrecset"
oBrwSis := TXBrowse():new( oFolder:aDialogs[1] )
WITH OBJECT oBrwSis
:nMarqueeStyle := 4
:nRowDividerStyle := 4
:nColDividerStyle := 4
:lColDividerComplete := .F.
:lAllowRowSizing := .F.
:lAllowSizing := .T.
:bKeyCount := {|| 1 }
:lHeader := .F.
:lFooter := .F.
:lRecordSelector := .F.
:aCols[2]:nWidth := 200
:aCols[3]:nWidth := 200
:aCols[4]:nWidth := 450
:l2007 := .F.
:nStretchCol := STRETCHCOL_WIDEST
:setRDD()
ENDbefore setrdd(), please write :cAlias := <thealiasyouwanttobrowse>
Please always do that every time we define a browse, because at runtime we dont know what will be the default workarea.
Please specify your work area and see the result
Are you using any RDD for MySql, like ADORDD ? If you are using some other library to read mysql data, SetRDD does not work
nageswaragunupudi wrote:before setrdd(), please write :cAlias := <thealiasyouwanttobrowse>
Please always do that every time we define a browse, because at runtime we dont know what will be the default workarea.
Please specify your work area and see the result
Are you using any RDD for MySql, like ADORDD ? If you are using some other library to read mysql data, SetRDD does not work
Then please specify oBrw:cAlias := <alias> and try.
Also check the actual value ready by rdd by msginfo( <samealis>->chave )
By the way I would like to download and see the demo version of sqllib for borland
nageswaragunupudi wrote:Then please specify oBrw:cAlias := <alias> and try.
Also check the actual value ready by rdd by msginfo( <samealis>->chave )
By the way I would like to download and see the demo version of sqllib for borland