FiveTech Software tech support forums

... 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" and "work", then the sql is SELECT ...

... else      oRs:MoveFirst()      // or whatever  endifendif  You can xbrowse empty recordsets, because xBrowse knows when to use MoveFirst() and when not to use.

:ActiveConnections is only for ADO recordsets. In fwmaria lib, it is oRs:oCn. To change the sql, please make a new RecSet object, set it to oBrw:oDbf and then close the old RecSet object You may try this sample and use similar logic #include ...

... and the last thing I do with dbfcdx is to move the record pointer after I write to the disk with GoTo Recno() ADO is a bit different with SQL .. Recordsets can be added to or edited one record at a time and when a committ is made all I do is issue oRs:Update(), and perhaps a SysReFresh() and ...

It has no effect on Opening ADO connctions, Opening RecordSets and using the recordsets in any manner we need. hi, ok ... but why "is"   oCn:Properties( "DBMS Name" ):Value and/or   oCn:Properties( "Extended Properties" ...

... function. This is basically intended for internal usage to help the function FW_ValToSQL() It has no effect on Opening ADO connctions, Opening RecordSets and using the recordsets in any manner we need.

... only when the recordset opens a physical table as Serverside Cursor using adUseServer and with adCmdTableDirect option and all other kinds of RecordSets do not support Seek method. (Mostly RecordSets are open with adUseClient) So, this recordset does not support "seek" method. Instead ...

Mr Rao, I have Fivewin 19.12, Can I request recordsets from MSSQl using parameter with my versión? Using the code: cCadsql1:="SELECT e.ITEMNMBR, a.ITEMDESC, e.LOCNCODE, e.QTYONHND, e.ATYALLOC, e.QTYONHND - e.ATYALLOC, a.SELNGUOM, IV40201.baseuofm,"+;" ...

Create your Connection once at the top of your program and use that connection to open all your recordsets throughout your application ..


Rick

There is no need for using Aliases in ADO.
We can open any number of recordsets for the same table at the same time and each recordset acts like different alias for dbf.

elvira wrote:What about Adotohtml()?

Thank you!!

For recordsets not containing BLOB fields:

Code: Select all  Expand view

cHtml := FW_AdoRsToHTML( oRs )

For recordsets containing BLOB fields:

Code: Select all  Expand view

  cHtml := FW_ArrayToHTML( RsGetRows( oRs ), FW_RecSetHeaders( oRs ) )
 

... tree from the data and switches to Tree Browse. This feature works for most datasources like arrays, dbf, rowsets but does not work with ADO recordsets. Now it works with ADO recordsets also. http://forums.fivetechsupport.com/viewtopic.php?f=3&t=39913 - In case of tree browses, COLUMNS ...

... oRs:Bookmark := 0.0 errors out and when oRs:Eof() we can not access any field values. For this reason, we need to modify xbrowse to handle ADO recordsets. These modifications are made in FWH 21.01. We publish here the changes you can make to xbrowse.prg to make it work for ADO recordsets. 1) ...

Hola Señores ! En un módulo de facturación, en el cuál normarmente se abren muchas tablas simultaneamente; ¿ Puedo abrir varios recordsets por cada una ? (simultaneamente) ¿y puedo identificar a cada recordset de alguna manera como lo hacía con los DBF, por ejemplo con sele 1, sele2, etc. ...

Dario Several ways you can do this .. both use RecordSets .. Rao has created a set of ADO wrappers in \source\function\AdoFuncs.prg .. or oRs := TOleAuto():New( "ADODB.Recordset" )oRs:CursorType     := 1   ...