FiveTech Support Forums

Hi All,

I created xbrowse with database created with ADS 8.5, However, the dates in xBrowse display as @d and not the actual date e.g. 01/01/1001. I tried using DBFCDX and date displays perfectly. Could somebody explain to me why the dates using ADS table does not display correctly in xbrowse, and how to solve this problem?

Thanks,

ryugarai

It should display dates correctly with ADS also. I have used on ADS 8.1
Can we see a very small table structure and sample code ?

Hi Nageswararao,

This is my declaration of xbrowse:

  REDEFINE XBROWSE oHXBrow OF oBrowDlg ID 1004 FONT oBrowFont UPDATE;  // browse for transact
                             Alias cAlias_TRANSDB AUTOSORT;
                             FASTEDIT

                          WITH OBJECT oHXBrow

                             :nRowHeight       := oBrowFont:nHeight + 12

                          END

fieldname is 'podate', declared in Ads 8.5 as:

         Data Type                                     :   date
         Index                                            :   no
         Minimum Value
         Maximum Value
         Default Value
         Null Valid                                       :   yes
         Failed Validation Message
         Description


  Hope this helps,

  ryugarai

Dear NageswaraRao,

   I think i just figured out the cause of incorrect display in xbrowse. It seems that when SET EXACT is set to .T., xbrowse display dates as "@d". Does SET EXACT affect the dates when displaying in xbrowse? Should i disable SET EXACT command when using xbrowse?

regards,

ryugarai

NageswaraRao,

  Thanks for the modification, xbrowse now display dates correctly.

regards,

ryugarai