FiveTech Software tech support forums

Mauri

Have a look at the samples AdoRick.prg .... sample uses ado but I think you may be able to modify to use dbfcdx ..

Rick Lipkin

... using Ms Access or MS Sql server for your database .. it will save you a lot of ( connection ) headaches .. have a look at and compile \samples\AdoRick.prg .. Just a quick suggestion .. Rick Lipkin ps .. if you are connecting with OLEDB\Sqloledb please dis-regard my comments ..

... on every Microsoft windows 10 workstation .. ADO is very much like the syntax of TDatabase .. have a look at the FW samples and the example AdoRick.prg ... Rao has also simplified the ADO syntax into FW wrappers ....\source\function\adofuncs.prg which are already built into FiveWin .. there ...

... / función adecuada ? ¿hay más de una forma de hacer lo mismo? Me refiero a Cuándo usar TOleAuto, CreateObject y TActivex. Probando el ejemplo adorick.prg de la carpeta samples de FWH veo que estas dos implementaciones dan el mismo resultado : oRsCust := TOleAuto():New( "ADODB.Recordset" ...

Gentleman ... for those who want to see what ADO is like ... here is the adorick.prg ... notice also .. incorporated into the program is a integrated xbrowse incremental search using filters ( very fast ) .. also as you can see you can use plain old ansi Sql ...

Gemtleman I have been using ( plain ) ADO ( class and methods ) for many years .. 32 and 64 bits ... Have a look in the samples folder and compile AdoRick.prg .. Uses all the Fivewin code .. xbrowse, panels, folders ... etc. You can use ADO to connect to MS Sql Server, MS Access and ( most ) all ...

Gemtleman I have been using ( plain ) ADO ( class and methods ) for many years .. 32 and 64 bits ... Have a look in the samples folder and compile AdoRick.prg .. Uses all the Fivewin code .. xbrowse, panels, folders ... etc. You can use ADO to connect to MS Sql Server, MS Access and ( most ) all ...

... I use Sql Server for large corporate databases and MS Access as a local solution much like dbf\cdx. Have a look at the \samples folder and compile AdoRick.prg . be glad to help you .. Rick Lipkin

... to make the syntax much easier .. look at AdoFuncs.Prg located in source\function .. also there is a full MDI Ado example I wrote \samples\AdoRick.prg Rick Lipkin

\samples\ADORICK.PRG

Code: Select all  Expand view

   oBtn1:Disable()
   oBtn2:Disable()
 

karinha wrote:Look \samples,

ADORICK.PRG

????

Look \samples,

ADORICK.PRG

Antonio,

I try to open with Visual Studio adorick.rc and I get this error:

Code: Select all  Expand view

error RC104: undefinied keyword o kwy name: WS_CHILD

Thanks

Have a look at \samples\adorick.prg ... shows how to make a connection to MS Access .. how to access tables via ADO ( recordsets ) .. browses with xBrowse Rick Lipkin Hola buenos dias Ing. Rick gracias por responder, pero el detalle ...

Have a look at \samples\adorick.prg ... shows how to make a connection to MS Access .. how to access tables via ADO ( recordsets ) .. browses with xBrowse Rick Lipkin Hola buenos dias Ing. Rick gracias por responder, pero el detalle ...