FiveTech Software tech support forums

Hi,
I have this code that read Xbrowse object

function TrovanumeroLotto( oBrw, nLotto )
local lFound := .F.
local lEof := .f.

oBrw:GoTop()

do while !lEof

if oBrw:aCols[3]:Value() == nLotto
lFound := .T.
lEof = .t.
endif

oBrw:Skip()
if oBrw:Eof()
lEof = .t.
endif

enddo

return ...

hi jack, Maybe my question was unclear.
When I open the dialog, the focus is on ID 101 (mget1).
If I press the BTNBMP BtnEsc ID 103 button in the dialog, the VALID clause of ID 101 is activated and the gohere() function is started.
In the gohere function, I want to know if the VALID clause was ...

Hi,
in this dialog from resource


DEFINE DIALOG cMyDialog RESOURCE "NESCNC" PIXEL FONT oFont TRUEPIXEL

REDEFINE GET oget1 VAR mget1 ID 101 OF cMyDialog COLOR CLR_BLACK,CLR_GET ;
PICTURE "@ !!!!!!!!!!!!!!!" VALID (gohere())

REDEFINE GET oget2 VAR mget2 ID 102 OF cMyDialog COLOR CLR_BLACK,CLR ...

hi, problem solved.
the query that generated the oRs object returned values ​​with 5 decimal places.
with a CAST in the SQL string I solved the problem.
Thank you all.

Hi,
I still have this problem.
the problem is only in first total.
Why?

Mr. Rao was a master.
Thanks for everything Mr. Rao

Damiano.

Hi,
A my customer (as400 Db2 server) now is in cloud.
My app that export data each morning read db from sql server and write to as400 by oledb connection.
Before cloud export data (50.000 records) in about 10 minutes, now export time is about 1 hour.
Lan connection is very good e internet is very ...

No, totel is 1.351.282,1200000000

I'd like total like the detail with two decimals

Hi,
thisi is my xbrowse
https://i.imgur.com/yCYqE33.png
this is code

@ 40,10 XBROWSE oBrw SIZE -10,-50 PIXEL ;
RECORDSET oRs ;
COLUMNS "cdcli", "rascl", "totale", "pezzi" ;
HEADERS "CLIENTE", "RAGIONE SOCIALE", "TOTALE EURO", "TOTALE PEZZI" ;
PICTURE NIL,NIL, "@ZE 99,999,999.99", "@ZE 99999 ...

good cNavarro
Thank you

in LAST field filter is "simp" and I get SImpson


then I press "Clear Filter" Button but the value "simp" is still in the get header


How can I clear the field?

Hi,
if I press the "clear filter" button the value into the get header remains there.
How can I clean the get fields when I press "clear filter" ?

thank you!!!
next step is filter for each column.
the example of Mark is good for me.
Any example ?

Hi Karinha,
i'd like a column with inside a icon or bitmap with color associated

Hi,
I have a xbrowse that read data by ADOdb.

there are 4 columns: NAME, CITY, AGE, COLOR

in the field COLOR I can only insert 4 option: AR, AB, AC, AO

I would like that xbrowse shows a little icon or bitmap with a color associated (AR YELLOW, AB BLUE, AC GREEN, AO RED)

How can I do it ?