FiveTech Software tech support forums

... have the :SetMultiSelectCol() the procedure must create the :SetMultiSelectCol() as the first column of the xbrowse and give the possibility to select the row If there are no selected rows in the xbrowse the procedure must remove the :SetMultiSelectCol() instead the test samples\xbmulsel.prg ...

... user, I made some changes created by Francisco and created a sub class of xbrowse Is it not a option to set the colums, save the state of xbrowse (selected from users) and the let the users select one of the saved states ? I still like the idea to subclass xbrowse for our own purposes, and will ...

... user, I made some changes created by Francisco and created a sub class of xbrowse Is it not a option to set the colums, save the state of xbrowse (selected from users) and the let the users select one of the saved states ? I still like the idea to subclass xbrowse for our own purposes, and will ...

i have a xbrowse with :SetMultiSelectCol() with bRClicked I associated a menupopup with :bLClicked I click on a row and select it I made the same with :bKeyChar ( space button)   :bLClicked := { |r,c,f,oBrw| if( oBrw:Mousecolpos( c ) == 1, ;    ...

I have an xbrowse created with an array without the :SetMultiSelectCol() and I have the ability to display a menupopup like this MENU oMenu POPUP if oBrw:IsSelectedRow() MENUITEM "Deselect the current row" action DeSelect_One_array(oBrw) MENUITEM ...

Or, if we want to deselect a specific row number, which is not the current row, we can do like this. if ( nAt := AScan( oBrw:aSelected, nRecNo ) ) > 0HB_ADel( oBrw:aSelected, nAt, .t. )endifoBrw:Refresh() ...

If I made to select all record on xbrowse

oBrw:SelectRow( 4 )

and the I wish deselect only one record

If I made oBrw:SelectRow( 0 ) it deselect all

how resolve ?

... nights, I have finally solved the problem, the problem was in the last line of this code. [code] oRsWrk := FW_OpenRecordSet(oApp:oCon,"SELECT " +; "*," +; "RUB_DES," +; "CON_DES " +; "FROM " +; cTabNam + " " +; "LEFT JOIN " ...

give me an error when I try to select a date @ nRow, 70 DTPICKER  aGet[1] VAR ddatacambio OF oDlgSub SIZE 198, 25 PIXEL ;      FONT oFont UPDATE PICTURE "ddd dd mmm yyyy"  ;     VALID ( DoSwitch( ddatacambio, oBtnGetExchange) ...

ok.
And so that the column that is ordered by "SELECT" appears the TRIANGULITE as it is done?

... SIZE 10,14 // bold DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-15 DEFINE DIALOG oDlg RESOURCE "CodLiqVar" . . . select _CoLiAux _CoLiAux->(DbGotop()) REDEFINE LISTBOX oLbx FIELDS str(_CoLiAux->Locatario,4,0) , ; _CoLiAux->Nombre , ; str(_CoLiAux->Propiedad,4,0) ...

... SIZE 10,14 // bold DEFINE FONT oFont NAME "TAHOMA" SIZE 0,-15 DEFINE DIALOG oDlg RESOURCE "CodLiqVar" . . . select _CoLiAux _CoLiAux->(DbGotop()) REDEFINE LISTBOX oLbx FIELDS str(_CoLiAux->Locatario,4,0) , ; _CoLiAux->Nombre , ; str(_CoLiAux->Propiedad,4,0) ...

... 5.1 Driver][mysqld-5.1.53-community]Undeclared variable: oRsWrk (0x80004005): Microsoft OLE DB Provider for ODBC Drivers Args: [ 1] = C SELECT * INTO oRsWrk FROM oRsDet oRsWrk and oRsDet are RecordSets. You should not use recordsets. Use table names. if the table names are "original" ...

Mr. Rao: First of all, thank you very much for your support. Whit this code       oApp:oCon:Execute( "SELECT * INTO oRsWrk FROM oRsDet" )  I get this error Error description: (DOS Error -2147352567) WINOLE/1007 [MySQL][ODBC 5.1 Driver][mysqld-5.1.53-community]Undeclared ...

I am try this: Code: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" ) if aRow == NIL // not found, then inserts aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow } ) endif ...