Search found 1710 matches: query

Return to advanced search

Re: Filter on Xbrowse

... an email with a very interesting approach to setting filter conditions. I think this is really a good way to set extensive filters. I coded this query for webview and mod harbour use. Best regards, Otto https://mybergland.com/fwforum/ch_filter.gif <!DOCTYPE html><html lang="en"><head>  ...
by Silvio.Falconi
Mon May 06, 2024 9:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Filter on Xbrowse
Replies: 42
Views: 750

Re: Filter on Xbrowse

... an email with a very interesting approach to setting filter conditions. I think this is really a good way to set extensive filters. I coded this query for webview and mod harbour use. Best regards, Otto https://mybergland.com/fwforum/ch_filter.gif <!DOCTYPE html><html lang="en"><head>  ...
by Otto
Sun May 05, 2024 10:00 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Filter on Xbrowse
Replies: 42
Views: 750

xbrowse (likely a custom table) whose contents change dynam

... the request that we receive from the client in this code. It is only for demonstration purposes. Here, one would then integrate the harbour query, i.e. plain harbour code. The result would then be assigned to the HASH and sent back to the client. hData['data'] := here is the result of the ...
by Otto
Sat May 04, 2024 7:42 am
 
Forum: mod_harbour
Topic: xbrowse (likely a custom table) whose contents change dynam
Replies: 0
Views: 71

Re: Question about performance RowSet

... ordenaciones, etc. otro tip importantes es que, en un recordset, cuando usamos la asignación ( oQry:FIELD1 := 10 ) y lectura de un campo del query ( ?oQry:FIELD1 ), (tanto tmysq y tdolphin, en fwh no lo tengo claro ya que no se proporcionan los fuentes), se hace uso del método error para ...
by Eroni
Fri Mar 15, 2024 1:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 4161

Fulltext-Search

... build your own input DIALOG. Using a HASHis a bit unusual at the beginning. I need this search for my DMS system. I will gradually expand the query filters. Best regards, Otto #include "fivewin.ch"static h := {=>}static oTimerREQUEST DBFCDXREQUEST DBFFPTfunction main  ...
by Otto
Fri Mar 15, 2024 9:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Fulltext-Search
Replies: 6
Views: 1291

Re: Question about performance RowSet

... ordenaciones, etc. otro tip importantes es que, en un recordset, cuando usamos la asignación ( oQry:FIELD1 := 10 ) y lectura de un campo del query ( ?oQry:FIELD1 ), (tanto tmysq y tdolphin, en fwh no lo tengo claro ya que no se proporcionan los fuentes), se hace uso del método error para ...
by carlos vargas
Fri Mar 15, 2024 3:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 4161

Re: FW_DbfSqlQuery GROUP BY no funciona

Syntax of SQL Query has nothing to do with FWH function. It is for the programmer to know the correct syntax of SQL supported by Jet OLE/ACE ole Normally GROUP BY clause is used for Aggregate functions. Example: SELECT STATE,SALARY ...
by nageswaragunupudi
Mon Feb 26, 2024 12:48 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: FW_DbfSqlQuery GROUP BY no funciona
Replies: 4
Views: 213

Help. Password/MySQL

... Desktop [FHW] I want to maintain compatibility [Hb_decrypt / SX_Decrypt ] -> It is not compatible 2. Is there any [Rdd.] for MySQL or Samples, Query/[Fields] Read data and load into a variable? Thank you in advance for your cooperation. lZanardo - Brazil
by lzanardo
Tue Feb 13, 2024 1:31 pm
 
Forum: mod_harbour
Topic: Help. Password/MySQL
Replies: 1
Views: 166

Re: Switching my setup program to webview2

... I can't figure out how to use localStorage or the ExecuteScriptAsync method of WebView2. Also, appending parameters to the local HTML file with query parameters gives me the error "Page not found" because, as I then found out, the file:// protocol does not support URL parameters by ...
by Otto
Sat Feb 10, 2024 7:14 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Switching my setup program to webview2
Replies: 9
Views: 419

Re: Clase Nativa MySql

Como ser, quiero saber como saber la ultima consulta que que hizo (query)


Code: Select all  Expand view
? oCn:cLastSQL


Also you can view last 10 sql statements executed
Code: Select all  Expand view
XBROWSER oCn:aSQL


This works from FWH2102 onwards.
by nageswaragunupudi
Mon Feb 05, 2024 7:52 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1884

Re: Clase Nativa MySql

Buen dia
Antonio, anios anteriores habia. una pagina donde estaban todos los. metodos que se podían. usar. de mariadb, ahora no estan, donde puedo ubicarlos?
Como ser, quiero saber como saber la ultima consulta que que hizo (query)

gracias
by goosfancito
Mon Feb 05, 2024 8:11 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Clase Nativa MySql
Replies: 18
Views: 1884

connecting SQL SERVER VIA ODBC PROLEM

... adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA COMPROBAR CONEXIÓN orsPed:ActiveConnection( oApp:oCon ) TRY orsped:open() CATCH oError MsgStop( "No se ha podido abrir el ...
by MANOLO
Mon Jan 29, 2024 5:18 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: connecting SQL SERVER VIA ODBC PROLEM
Replies: 0
Views: 334

Re: CONEXION ADODB SQL SERVER

... oApp:cAplicacion) ShowError(oError) CLOSE_DBF(ODTEMP) RETURN(.F.) END </code> es justo aquí cuando lanzo el recorset para pasarle el query cuando me dice que la función open() no existe. gracias de todos modos, a ver si lo conseguimos.
by MANOLO
Mon Jan 29, 2024 5:09 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 4
Views: 295

CONEXION ADODB SQL SERVER

... adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA COMPROBAR CONEXIÓN orsPed:ActiveConnection( oApp:oCon ) TRY orsped:open() CATCH oError MsgStop( "No se ha podido abrir el ...
by MANOLO
Mon Jan 29, 2024 9:12 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 4
Views: 295

CONEXION ADODB SQL SERVER

... adUseClient orsPed:LockType := adLockOptimistic orsPed:CursorType := adOpenDynamic orsped:source:="SELECT * FROM ERP6_base" // ENVIAMOS QUERY DE PRUEBA PARA COMPROBAR CONEXIÓN orsPed:ActiveConnection( oApp:oCon ) TRY orsped:open() CATCH oError MsgStop( "No se ha podido abrir el ...
by MANOLO
Mon Jan 29, 2024 9:12 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: CONEXION ADODB SQL SERVER
Replies: 0
Views: 153
Next

Return to advanced search