FiveTech Software tech support forums

I have been using an ADODB RecordSet object to connect to my server over the internet. oRs:Open( cUrl ). Actually very fast, works well. What I don't know, or can't figure out is if I can use this on a secure site. Can't seem to get it ...

... es preferible usar QueryResult, no tiene sentido usar RowSet, dado que no se hará búsqueda, 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 ...

... es preferible usar QueryResult, no tiene sentido usar RowSet, dado que no se hará búsqueda, 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 ...

... case, I just open the table and I want to show it in an empty xBrowse, the example of your answer is when they try to record. We can safely show a recordset with 0 records in an xbrowse. If oRs != nil   XBROWSER oRsendif  This works even if the recordset has 0 records

With ADO we can use MoveFirst(), Move(), etc. when the recordset is empty. It is the normal practice to check (whether fivewin, vb, c#, etc) oRs := FW_OpenRecordSet( ... )if oRs == nil   ? "failed to open"else   if ...

Mr. Rao: the browse recordset has several columns although in the browse I only show three, the ones necessary to form the tree, and the editing of all the columns is done in a dialog, I am going to upload a video to better explain ...

... RETURN(.F.) END // since here de code works ok // now try to open de recorset and here is the problem TRY orsPed := TOleAuto():New("adodb.recordset") // orsPed:= CreateObject("ADODB.Recordset") CATCH oError MsgStop( "No se ha podido crear el RECORDSET de Pedidos!", ...

... también, la conexión odbc me la hace perfectamente, el problema es cuando le lanzo el : <CODE> TRY orsPed := TOleAuto():New("adodb.recordset") // orsPed:= CreateObject("ADODB.Recordset") CATCH oError MsgStop( "No se ha podido crear el RECORDSET de Pedidos!", ...

... con acceso a mysql mediante ado, pero ahora nos han cambiado la base de datos por sql server, y me estoy volviendo loco me da error en el recordset, os paso como lo hago a ver si a alguien se le ocurre el porqué: oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist ...

... con acceso a mysql mediante ado, pero ahora nos han cambiado la base de datos por sql server, y me estoy volviendo loco me da error en el recordset, os paso como lo hago a ver si a alguien se le ocurre el porqué: oApp:oCon:ConnectionString:= "Provider=SQLOLEDB;Password=xxxx3;Persist ...

Hola Leandro, Se me ocurre que conviertas a un Hash el recordset algo así, esta hecho al vuelo no se si funciona.   cBusqueda:="ll_consec="+alltrim(cFcEn)  hhash    :={ => }    oRs:MoveFirst() /// Voy al primero  ...

... := "ARRAY" but get no data. Not sure how to set the bGoTop, bGoBottom, bSkip, bLogicLen blocks. For now I am creating a dynamic recordset from the json object, but I feel like it is an extra step. Thanks, again...

Jeorge Try the old fashoned way where you set the Recordset properties manually ... oRs1 := TOleAuto():New( "ADODB.Recordset" )oRs1:CursorType     := 1        // opendkeysetoRs1:CursorLocation := 3       // local cacheoRs1:LockType ...

Jeorge Try the old fashoned way where you set the Recordset properties manually ... oRs1 := TOleAuto():New( "ADODB.Recordset" )oRs1:CursorType     := 1        // opendkeysetoRs1:CursorLocation ...

... FASTEDIT with vertical and horizontal scrolling and facility to edit values inside the cell, validate and immediately save to dbf,recordset or whatever. So they choose what helps them to develop the application faster. In fact I have been thinking of personally approaching you ...