FiveTech Software tech support forums

Thanks for the advice. Double Click does open the edit screen but editing is disabeld because of the .t. in oTb:=oCn:RowSet( cQuery,.t. ) Using the code in my second posting, double click will not any more open edit screen. Better you use this version. Note: Dbl-click to open edit screen ...

Thanks for the advice.

Double Click does open the edit screen but editing is disabeld because of the .t. in oTb:=oCn:RowSet( cQuery,.t. )

I need to Browse a MySql table in Read only mode. oCn :=maria_Connect( cHost,cUser,cDb,cPwd ) cQuery:="SELECT * FROM EVENTOS" oTb:=oCn:RowSet( cQuery,.t. ) xbrowser oTb TITLE "Eventos " oCn:Close() Works and is readonly but the ADD + EDIT and DELETE ...

... wrapper over TWebView. - Data members include: - `bOldBind`: Presumably used to store previous bindings. - `oWeb`: Instance of TWebView. - `cQuery`, `nSecond`, `cReturn`: Parameters used for querying. - Methods include: - `New`: Constructor that binds the 'SendToFWH' function for callback ...

... wrapper over TWebView. - Data members include: - `bOldBind`: Presumably used to store previous bindings. - `oWeb`: Instance of TWebView. - `cQuery`, `nSecond`, `cReturn`: Parameters used for querying. - Methods include: - `New`: Constructor that binds the 'SendToFWH' function for callback ...

... named TAWaitWeb. To facilitate more convenient usage, I have created user-friendly functions using TAWaitWeb as follows: AWait_QuerySelector(oWeb, cQuery, nSecond) AWait_QuerySelectAll(oWeb, cQuery, nSecond) AWait_GetOuterHTML(oWeb, cSelector, nSecond) 6. The example scenario is as follows: 6-1.Navigate ...

... --- i "think" i got it for Type "C","N","D" and "L"   cQuery := "CREATE TABLE " + cTable + " ( "   iMax := LEN( aDbfStruct )   FOR i = 1 TO iMax      cQuery += aDbfStruct[ ...

MI estimado, prueba asi: cQuery := "SELECT " cQuery += "Cli.rif_cliente, " cQuery += "Cli.razon_social_cliente, " cQuery += "Fac.numero_documento, " cQuery += "Fac.fecha_documento, " cQuery ...

... se le dio a una tabla. Antes lo hacia con GetAutoIncrement y ahora con mariadb? gracias. Saludos, yo lo hago asi, inmediatamente luego del insert cQuery := "SELECT LAST_INSERT_ID() AS nIdItem FROM articulos;" otra forma cQuery := “SELECT MAX(id) AS nIdItem FROM articulos;” esta es otra, ...

Qué es el record set? Esta es la consulta en la función principal: cQuery := 'select * from reporte where mes_fantasma = ' + Str( nMes ) + ' order by fecha DESC' oQry := o : oRep : RowSet( cQuery ) En las funciones siguientes es donde quiero invertir el orden, ...

Amigo:

cQuery := 'select * from reporte where mes_fantasma = ' + Str( nMes ) + ' order by fecha DESC'
oQry := o : oRep : RowSet( cQuery )

// Después de crear el record set (oQry)
oQry:SORT := "CAMPO1,CAMPO2,etc ASC" // o DESC
oQry:MoveFirst()

Saludos

Qué es el record set?

Esta es la consulta en la función principal:

cQuery := 'select * from reporte where mes_fantasma = ' + Str( nMes ) + ' order by fecha DESC'

oQry := o : oRep : RowSet( cQuery )


En las funciones siguientes es donde quiero invertir el orden, de DESC a ASC

... know what could be the problem?? cSQL:=mysql_real_escape_string(::pLib,::hConnection,cSQL) function mysql_real_escape_string(pLib, hConnect, cQuery) return hb_DynCall( { "mysql_real_escape_string", pLib, hb_bitOr( hb_SysLong(),; hb_SysCallConv() ), hb_SysLong(), HB_DYN_CTYPE_CHAR_PTR, ...

Utilizo lo siguiente sin inconvenientes
::oServer:SqlQuery(cQuery )

Se agradece Mr. Rao
Recien me cambio de version