VO Beginner: how to use Oracle with VO 2.6?
in [Visual Objects]
|
From: Marc Verkade [Marti IT] on 21 Oct 2006 18:53 Aha Thomas Olszewicki I did a google on VO2Oracle. It is you yourself! Hello to you! I was using your library but then it stopped working for 2.7b. I have contacted you once in a while, but then suddenly Electric People was selling the stuff for 9999,00 USD. I know it was your work, do you still have somthing to do with VO2Oracle. Are you selling it? Grtz, Marc <ThomasO(a)cpas.com> schreef in bericht news:1161469174.825824.83550(a)k70g2000cwa.googlegroups.com... > > Marc Verkade [Marti IT] wrote: >> Hai, >> >> You could use VO2Oracle, but it is quite expensive (9999,00 $). >> VO2Ado uses the standard window way to communicate with other databases >> like >> Oracle, Acces, MS-Sql etc. It works very well and is actively supported >> by >> Robert from SAS Software. >> Try the samples found on your 2.6 CD, it is all there. >> >> Grtz, Marc >> >> "NewUserVO" <mclbdn(a)libero.it> schreef in bericht >> news:1161249458.030316.82440(a)m73g2000cwd.googlegroups.com... >> > Hi all >> > >> > I've just known VO 2.6 and I have done some simple tools using .dbf >> > file. >> > >> > Now, I want to improve my tools and I want to start to use SQL with >> > Oracle. >> > First, I suppose that I have to convert my .dbf into.sql file >> > then I have to change my project. >> > >> > How can I use Oracle with my application? >> > Is this difficult to implement? >> > Can I use the SQL editor instead DB sever editor? >> > >> > What is Vo2Ado? is it useful? >> > >> > I'm a little confused. >> > >> > Thanks in advance >> > >> > Best Regards >> > > Mark, > Who is selling it for 9999,00 $ ? > Where did you get this info? > Thx > Thomas >
From: Terje Barman on 23 Oct 2006 08:18 Hi NewUserVO! I've been using Oracle the last five years now, and as Marc refers to down this thread, I also use VO2Oracle. I have experienced that it is very fast and 100% stable and reliable. For VO 2.6 it wouldn't work because a strange implementation of the evaluation of logic statements. But for VO 2.7 it just needed a few changes and was ready. A few code examples follows. Good luck on your Oracle project! Terje .... liRet := S_OK cbErrorBlock := ErrorBlock({|o|_Break(o)}) begin sequence .... iPersonID := 4711 sStmt := "SELECT LName,FName FROM Person WHERE PersonID= :PersonID " oSQLSelect := ORASelect{sStmt,oConn} oSQLSelect:addParam(":PersonID",int) oSQLSelect:paramPut(":PersonID",iPersonID) if .Not. oSQLSelect:Execute() sErrMsg := oSQLSelect:errInfo:errorMessage break 1L // remember to close the select object in the recover sequence endif oSQLSelect:goTop() sFName := oSQLSelect:fieldget(#FName) sLName := oSQLSelect:fieldget(#LName) oSQLSelect:close() // don't forget this one! .... // personID is inserted from a trigger executed before insert... sFName := "New" sLName := "VOuser" sStmt := "INSERT INTO Person(LName,FName)VALUES(:LName,:FName)" oSQLStatement := ORAStatement{sStmt,oConn} oSQLStatement:addParam(":LName",string,60) oSQLStatement:addParam(":FName",string,60) oSQLStatement:paramPut(":LName",sLName) if .NOt. oSQLStatement:execute() sErrMsg := oSQLStatement:ErrInfo:ErrorMessage break 1L endif oSQLStatement:close() "NewUserVO" <mclbdn(a)libero.it> skrev i melding news:1161249458.030316.82440(a)m73g2000cwd.googlegroups.com... > Hi all > > I've just known VO 2.6 and I have done some simple tools using .dbf > file. > > Now, I want to improve my tools and I want to start to use SQL with > Oracle. > First, I suppose that I have to convert my .dbf into.sql file > then I have to change my project. > > How can I use Oracle with my application? > Is this difficult to implement? > Can I use the SQL editor instead DB sever editor? > > What is Vo2Ado? is it useful? > > I'm a little confused. > > Thanks in advance > > Best Regards >
From: ThomasO on 23 Oct 2006 23:11 Marc Verkade [Marti IT] wrote: > Aha Thomas Olszewicki > I did a google on VO2Oracle. > > It is you yourself! Hello to you! > I was using your library but then it stopped working for 2.7b. > I have contacted you once in a while, but then suddenly Electric People was > selling the stuff for 9999,00 USD. > > I know it was your work, do you still have somthing to do with VO2Oracle. > Are you selling it? > > Grtz, Marc > > > <ThomasO(a)cpas.com> schreef in bericht > news:1161469174.825824.83550(a)k70g2000cwa.googlegroups.com... > > > > Marc Verkade [Marti IT] wrote: > >> Hai, > >> > >> You could use VO2Oracle, but it is quite expensive (9999,00 $). > >> VO2Ado uses the standard window way to communicate with other databases > >> like > >> Oracle, Acces, MS-Sql etc. It works very well and is actively supported > >> by > >> Robert from SAS Software. > >> Try the samples found on your 2.6 CD, it is all there. > >> > >> Grtz, Marc > >> > >> "NewUserVO" <mclbdn(a)libero.it> schreef in bericht > >> news:1161249458.030316.82440(a)m73g2000cwd.googlegroups.com... > >> > Hi all > >> > > >> > I've just known VO 2.6 and I have done some simple tools using .dbf > >> > file. > >> > > >> > Now, I want to improve my tools and I want to start to use SQL with > >> > Oracle. > >> > First, I suppose that I have to convert my .dbf into.sql file > >> > then I have to change my project. > >> > > >> > How can I use Oracle with my application? > >> > Is this difficult to implement? > >> > Can I use the SQL editor instead DB sever editor? > >> > > >> > What is Vo2Ado? is it useful? > >> > > >> > I'm a little confused. > >> > > >> > Thanks in advance > >> > > >> > Best Regards > >> > > > Mark, > > Who is selling it for 9999,00 $ ? > > Where did you get this info? > > Thx > > Thomas > > Mark, Send me private email at ThomasO -at- cpas -dot- com Thomas
From: Marc Verkade [Marti IT] on 24 Oct 2006 05:21
Hai Thomas, Since I do not do Oracle anymore, i do not need it anymore. I just was curious. Thanx for your offer to communicate privately Grtz, Marc <ThomasO(a)cpas.com> schreef in bericht news:1161659483.009117.281800(a)e3g2000cwe.googlegroups.com... > > Marc Verkade [Marti IT] wrote: >> Aha Thomas Olszewicki >> I did a google on VO2Oracle. >> >> It is you yourself! Hello to you! >> I was using your library but then it stopped working for 2.7b. >> I have contacted you once in a while, but then suddenly Electric People >> was >> selling the stuff for 9999,00 USD. >> >> I know it was your work, do you still have somthing to do with VO2Oracle. >> Are you selling it? >> >> Grtz, Marc >> >> >> <ThomasO(a)cpas.com> schreef in bericht >> news:1161469174.825824.83550(a)k70g2000cwa.googlegroups.com... >> > >> > Marc Verkade [Marti IT] wrote: >> >> Hai, >> >> >> >> You could use VO2Oracle, but it is quite expensive (9999,00 $). >> >> VO2Ado uses the standard window way to communicate with other >> >> databases >> >> like >> >> Oracle, Acces, MS-Sql etc. It works very well and is actively >> >> supported >> >> by >> >> Robert from SAS Software. >> >> Try the samples found on your 2.6 CD, it is all there. >> >> >> >> Grtz, Marc >> >> >> >> "NewUserVO" <mclbdn(a)libero.it> schreef in bericht >> >> news:1161249458.030316.82440(a)m73g2000cwd.googlegroups.com... >> >> > Hi all >> >> > >> >> > I've just known VO 2.6 and I have done some simple tools using .dbf >> >> > file. >> >> > >> >> > Now, I want to improve my tools and I want to start to use SQL with >> >> > Oracle. >> >> > First, I suppose that I have to convert my .dbf into.sql file >> >> > then I have to change my project. >> >> > >> >> > How can I use Oracle with my application? >> >> > Is this difficult to implement? >> >> > Can I use the SQL editor instead DB sever editor? >> >> > >> >> > What is Vo2Ado? is it useful? >> >> > >> >> > I'm a little confused. >> >> > >> >> > Thanks in advance >> >> > >> >> > Best Regards >> >> > >> > Mark, >> > Who is selling it for 9999,00 $ ? >> > Where did you get this info? >> > Thx >> > Thomas >> > > Mark, > Send me private email at ThomasO -at- cpas -dot- com > Thomas > |