Data on lower into xBrowse!?

[JC]

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?

[nageswaragunupudi]

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.

[JC]

I believe! Only in this case, it's happening!

My code of xBrowse (it's into a folder):

Code: Select all | Expand

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

The data before


The data after

[nageswaragunupudi]

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?

[JC]

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?

Sorry Nages.... Yes! With :setRDD() method!

[nageswaragunupudi]

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"

[JC]

I'm using this way, just forgot to put the code here!
Only the posted the codes amending the state it

The complete code:

Code: Select all | Expand

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()
END

I'm using many others xBrowse's but with only this happening!

[nageswaragunupudi]

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

[JC]

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

I'm using the SQLLIB for Fivewin! This creates the area like a valid ALIAS. Works with all others!

[nageswaragunupudi]

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

[JC]

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

The SQLLIB for Fivewin
http://www.sqllib.com.br/v4/index.php?module=SQLDown