Search found 1707 matches: query

Return to advanced search

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: 466

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: 229

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: 466

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: 166

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: 120

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: 301

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: 1728

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: 1728

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: 307

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: 249

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: 249

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: 135

Re: Consuta sobre MariaDB/MySql

... esto lo había obtenido de algún hilo de este foro, y me ha funcionado, aunque no se si es la mejor forma o la mas adecuada oQry := oApp:oServer:Query("SELECT 1") También esto me indica si en el transcurso del programa se ha cortado la conexión a internet. Espero tus comentarios sobre ...
by cmsoft
Thu Jan 25, 2024 11:49 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Consuta sobre MariaDB/MySql
Replies: 8
Views: 354

tiny11 core for ARM64

... is reduced to only 8 GB, If you are interested, you can download tiny11, the essential Windows 11, from https://archive.org/search?query=creator%3A%22NTDEV%22&sort=-addeddate UPDATE NOVEMBER 2023 – tiny11 2311 WINDOWS BASED RELEASED 23H2 The system has been updated to Windows ...
by Silvio.Falconi
Thu Jan 18, 2024 10:23 am
 
Forum: FiveWin for Pocket PC
Topic: tiny11 core for ARM64
Replies: 0
Views: 553

Re: Problema usando STRTRAN()

Armando wrote:José:

Agradezco el consejo, no es un query es al momento de grabar, pero al compilar me reclama la función
Val2Escape(), me falta algo?

Code: Select all  Expand view

oRsWrk:Fields("WRK_DES"):Value := Val2escape(oWrk:DES)
 


Saludos


Armando disculpa, creo que es con TDolphin
by JoseAlvarez
Wed Jan 17, 2024 11:25 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Problema usando STRTRAN()
Replies: 10
Views: 323
Next

Return to advanced search