FiveTech Software tech support forums

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 .. see how I create a new .mdb from scrat...

Ariel It depends on how you setup the recordset ... This is the old fashioned way .. notice openkeyset cSQL := "SELECT * from USERINFO order by USERID"oRsUSER := TOleAuto():New( "ADODB.Recordset" )    oRsUSER:CursorType     := 1        // opendkeysetoRsUSER:Cursor...

As Rao mentions .. many of the methods he has created handy wrappers .. to dig a bit deeper .. have a look and this fivewin wiki

https://wiki.fivetechsoft.com/doku.php? ... ted_stuffs

Rick Lipkin

... I create a script to act as an api to communicate with the server. Anyone has done something similar? The script would need to cover the usual stuffs; adding, editing record, make enquiry TIA

Tim If you are looking to migrate your application to MSSql .. I would like to offer my help .. As you know, I have been using ADO for many years and my favorite RDMS is Sql Server for Enterprise applications and MS Access for local portable applications. There are several ways to code your applicat...

Oscar Have a look at in your FiveWin install under \function and have a look at the file adofuncs.prg .... a nice set of various RDMS SQL connection and recordset wrappers that Rao has put together .. Here is a link that may help in doing it the old fashioned way ... and understanding how ADO works ...

Rodrigo xHarbour\Harbour support ADO .. the link below is a good starting place to familiarize yourself with Sql and Ado .. Rao has done a good job using FW wrappers to simplify the connections and recordsets .. look in \source\function\Adofuncs.prg http://wiki.fivetechsoft.com/doku.php?id=ado-relat...

Here is my original post ( some years ago ) using native Microsoft Ado Class's and methods .. Rao has done a great job with the wrappers found in AdoFunc.Prg ... Here is the FiveWin Wili on ADO.

Rick Lipkin

http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs

Rick,

Thanks for the information:D, I think it is very important that I understand these concepts, while I am programming. I am going to try to get some programs working (fivedbu.prg and your code from http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs).

Pieter

Pieter You have to understand two things about Sql programming .. 1) How am I going to connect to the Sql Database ? Each Sql RDMS has its own 'connector' to its Database .. MySql connects via ODBC, MsAccess, MsSql Server,Oracle,dB2 use an OleDb client. There are advantages and disadvantages in maki...

Mr. Nages, The FW_DateToADO proved to be the solution. Mr. Rick Appreciate your thoughts. Your " ADO-related stuffs " article is what "broke the ice " for me to try ADO. Much learned and much yet to be learned. Many thanks to all, Bruce S

Don I was just wondering if it might be time to investigate other routes to MSSQL. The short answer to your statement above is YES! .. I started using ADO ( sqloledb, or Ms Jet ) many years ago and I never looked back. With recent versions of FiveWin they have created a set of FW_Ado .. functions th...

Avista Here is the Wiki on using ADO and Fivewin that many of our friends have contributed .. http://wiki.fivetechsoft.com/doku.php?id=ado-related_stuffs To Answer your question .. Fetch() is not a method ( as far as I know ) .. Here are the most common methods and their xBase counter parts .. Appen...

Lucas,

Would you like to update the wiki yourself ? thanks

http://wiki.fivetechsoft.com/doku.php?id=ado-related_stuffs

Lucas

Here is the FWH Wiki on the subject compiled from many of our ADO friends including Enrico, Rao and myself ..

Rick Lipkin

http://wiki.fivetechsoft.com/doku.php?i ... ted_stuffs