Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #1254 > unrolled thread
| Started by | Martin <spam@spam.spam> |
|---|---|
| First post | 2011-06-06 09:34 +0100 |
| Last post | 2011-06-08 15:02 +0100 |
| Articles | 15 — 6 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
Reading Access files Martin <spam@spam.spam> - 2011-06-06 09:34 +0100
Re: Reading Access files E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-06 10:48 +0200
Re: Reading Access files Johan Nel <johan.nel@xsinet.co.za> - 2011-06-06 02:51 -0700
Re: Reading Access files E®!k \\/!$$E® <nospam@nospam.url> - 2011-06-06 17:24 +0200
Re: Reading Access files Johan Nel <johan.nel@xsinet.co.za> - 2011-06-07 02:07 -0700
Re: Reading Access files "Willie Moore" <williem@wmconsulting.com> - 2011-06-07 07:29 -0500
Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:29 +0000
Re: Reading Access files "Willie Moore" <williem@wmconsulting.com> - 2011-06-08 08:42 -0500
Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:31 +0000
Re: Reading Access files "Willie Moore" <williem@wmconsulting.com> - 2011-06-06 06:56 -0500
Re: Reading Access files D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-07 22:56 +0200
Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-07 22:21 +0000
Re: Reading Access files D.J.W. van Kooten <public@ic2remove.this.com> - 2011-06-10 11:50 +0200
Re: Reading Access files "Geoff Schaller" <geoffx@softwarexobjectives.com.au> - 2011-06-10 21:27 +0000
Re: Reading Access files Martin <spam@spam.spam> - 2011-06-08 15:02 +0100
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2011-06-06 09:34 +0100 |
| Subject | Reading Access files |
| Message-ID | <qi0Hp.5466$r52.1063@newsfe02.ams2> |
Hello I need to read abd write to an access file, how do I do use them please? Is there a RDD? Thanks Martin
[toc] | [next] | [standalone]
| From | E®!k \\/!$$E® <nospam@nospam.url> |
|---|---|
| Date | 2011-06-06 10:48 +0200 |
| Message-ID | <953ij1F9glU1@mid.individual.net> |
| In reply to | #1254 |
MArtin, You can use ADO or VO2ADO or VO2Jet or the VO2ADO RDD I would not recommend the last one, but I do use it for reports with RPRO. Erik "Martin" schreef in bericht news:qi0Hp.5466$r52.1063@newsfe02.ams2... Hello I need to read abd write to an access file, how do I do use them please? Is there a RDD? Thanks Martin
[toc] | [prev] | [next] | [standalone]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2011-06-06 02:51 -0700 |
| Message-ID | <f2d7f9b9-8213-4896-a09e-52518d3deeb5@n10g2000vby.googlegroups.com> |
| In reply to | #1254 |
Martin, Depending on the complexity of what is required, VO2ADO is the best, however even the build in SQL classes of VO should suffice (ODBC connection required though). Regards, Johan Nel Pretoria, South Africa. On Jun 6, 10:34 am, Martin <s...@spam.spam> wrote: > Hello > > I need to read abd write to an access file, how do I do use them please? > > Is there a RDD? > > Thanks > > Martin
[toc] | [prev] | [next] | [standalone]
| From | E®!k \\/!$$E® <nospam@nospam.url> |
|---|---|
| Date | 2011-06-06 17:24 +0200 |
| Message-ID | <9549qaFudvU1@mid.individual.net> |
| In reply to | #1256 |
Johan, > Depending on the complexity of what is required, VO2ADO is the best, Better than VO2JET ??? I do agree however if you say VO2ADO gives more flexibility, as you can use the same code for MS SQLServer and others. (You will need to change the queries however, as the Jet engine has other function names for common tasks and the Sql slightly differs.) Erik "Johan Nel" schreef in bericht news:f2d7f9b9-8213-4896-a09e-52518d3deeb5@n10g2000vby.googlegroups.com... Martin, Depending on the complexity of what is required, VO2ADO is the best, however even the build in SQL classes of VO should suffice (ODBC connection required though). Regards, Johan Nel Pretoria, South Africa. On Jun 6, 10:34 am, Martin <s...@spam.spam> wrote: > Hello > > I need to read abd write to an access file, how do I do use them please? > > Is there a RDD? > > Thanks > > Martin
[toc] | [prev] | [next] | [standalone]
| From | Johan Nel <johan.nel@xsinet.co.za> |
|---|---|
| Date | 2011-06-07 02:07 -0700 |
| Message-ID | <7df86595-00d9-4eef-8019-f95796ed8805@g28g2000yqa.googlegroups.com> |
| In reply to | #1260 |
Erik, > > Depending on the complexity of what is required, VO2ADO is the best, > > Better than VO2JET ??? Sorry if I was not clear. Depending the complexity of what Martin wants to do, even a SQLTable, SQLSelect, SQLStatement, SQLConnection might be enough. Had a couple of systems that were build around the VO native SQL* classes that ran quite successfully. As you stated, VO2ADO has a lot of flexibility. My response was more in line of what does Martin believe is the future of the Access interface? If long-term, I would rather consider going the .NET route (if he does not have VO2ADO). If it is a short-term solution, just go with the SQL* classes in VO until a permanent long-term solution is decided upon. Hope this clear any confusion. Johan.
[toc] | [prev] | [next] | [standalone]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-06-07 07:29 -0500 |
| Message-ID | <isl5j1$l8l$1@speranza.aioe.org> |
| In reply to | #1276 |
Johan, Reading access from dotNet is very easy. If you define your data access in dotNet, you can expose that to VO. Once you are fully in dotNet, you just reference the class directly instead of using COM. It set mine up as a WCF component. That way I can use the same business logic on the PC as well as the web. Regards, Willie "Johan Nel" wrote in message news:7df86595-00d9-4eef-8019-f95796ed8805@g28g2000yqa.googlegroups.com... Erik, > > Depending on the complexity of what is required, VO2ADO is the best, > > Better than VO2JET ??? Sorry if I was not clear. Depending the complexity of what Martin wants to do, even a SQLTable, SQLSelect, SQLStatement, SQLConnection might be enough. Had a couple of systems that were build around the VO native SQL* classes that ran quite successfully. As you stated, VO2ADO has a lot of flexibility. My response was more in line of what does Martin believe is the future of the Access interface? If long-term, I would rather consider going the .NET route (if he does not have VO2ADO). If it is a short-term solution, just go with the SQL* classes in VO until a permanent long-term solution is decided upon. Hope this clear any confusion. Johan.
[toc] | [prev] | [next] | [standalone]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-06-07 22:29 +0000 |
| Message-ID | <4deea631$0$12375$c30e37c6@exi-reader.telstra.net> |
| In reply to | #1281 |
Willie, When you say you reference the class "directly", do you mean that you build a large library of prototypes to go in the VO app to call into the DLL? Seems a little bit of overkill for something very easy natively out of VO? There is also a lot of work to get data types across the boundary properly, especially if you need arrays from memos etc. But COM also solves a lot of access issues and means the target app doesn't need to manually generate a prototype library. > Reading access from dotNet is very easy. And statements like this will get you into trouble <g>. Yes it is easy once you know how, but it is a paradigm shift to get there. There are also around 4 key ways to manage data access (table/adapters, entity framework, direct sql, webservice...) so which one do you pick and why. Geoff
[toc] | [prev] | [next] | [standalone]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-06-08 08:42 -0500 |
| Message-ID | <isnu7p$ea9$1@speranza.aioe.org> |
| In reply to | #1291 |
Geoff, In VO I have my business classes separate from the GUI. The business classes have a VOCOM layer so I can serve them up from a web server. When the VO client (not the web client) uses the library, I include it as a library instead of a COM and I just call the classes I need. The web pages instantiate the COM object and use the exported methods to get to the classes. In dotNet I do things in a similar fashion. But instead of using VOCOM I create a WCF service that exposes the classes and the methods I need. My web site uses the web reference to get to the exposed methods but my Vulcan client just uses a reference to that class #USING wmConsulting.SFM and access the class / methods directly. I could use WCF on my Vulcan client too but I don’t want to add the extra layer in if I don’t have to. Regards, Willie "Geoff Schaller" wrote in message news:4deea631$0$12375$c30e37c6@exi-reader.telstra.net... Willie, When you say you reference the class "directly", do you mean that you build a large library of prototypes to go in the VO app to call into the DLL? Seems a little bit of overkill for something very easy natively out of VO? There is also a lot of work to get data types across the boundary properly, especially if you need arrays from memos etc. But COM also solves a lot of access issues and means the target app doesn't need to manually generate a prototype library. > Reading access from dotNet is very easy. And statements like this will get you into trouble <g>. Yes it is easy once you know how, but it is a paradigm shift to get there. There are also around 4 key ways to manage data access (table/adapters, entity framework, direct sql, webservice...) so which one do you pick and why. Geoff
[toc] | [prev] | [next] | [standalone]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-06-07 22:31 +0000 |
| Message-ID | <4deea6ac$0$12375$c30e37c6@exi-reader.telstra.net> |
| In reply to | #1276 |
Johan, You are right on two fronts. Whilst I guess VO2Jet is somehow optimised for MS Access, we just use VO2Ado for the limited needs we have. Our SQL syntax just needs to obey the rules for access. And in C# we just use our regular data adapters and tables to get to MS Access. Geoff "Johan Nel" <johan.nel@xsinet.co.za> wrote in message news:7df86595-00d9-4eef-8019-f95796ed8805@g28g2000yqa.googlegroups.com: > Erik, > > > > > Depending on the complexity of what is required, VO2ADO is the best, > > > > > Better than VO2JET ??? > > > Sorry if I was not clear. Depending the complexity of what Martin > wants to do, even a SQLTable, SQLSelect, SQLStatement, SQLConnection > might be enough. Had a couple of systems that were build around the > VO native SQL* classes that ran quite successfully. > > As you stated, VO2ADO has a lot of flexibility. My response was more > in line of what does Martin believe is the future of the Access > interface? If long-term, I would rather consider going the .NET route > (if he does not have VO2ADO). If it is a short-term solution, just go > with the SQL* classes in VO until a permanent long-term solution is > decided upon. > > Hope this clear any confusion. > > Johan.
[toc] | [prev] | [next] | [standalone]
| From | "Willie Moore" <williem@wmconsulting.com> |
|---|---|
| Date | 2011-06-06 06:56 -0500 |
| Message-ID | <isif9s$vjd$1@speranza.aioe.org> |
| In reply to | #1254 |
Martin, I use VO2ADO. Regards, Willie
[toc] | [prev] | [next] | [standalone]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-06-07 22:56 +0200 |
| Message-ID | <lf3tu69abisgai3b17nua7e1ocruv4b6m6@4ax.com> |
| In reply to | #1254 |
On Mon, 06 Jun 2011 09:34:27 +0100, Martin <spam@spam.spam> wrote: Hello Martin. > >I need to read abd write to an access file, how do I do use them please? > The simplest way in VO (without the need to buy Vo2ADo) is to create an ODBC connection with this database using Windows. Then go to the DBServer editor and select New entity, SQL Editor. Unfortunately it's been a few years ago so I am not sure anymore about the exact order/steps but in the end you will have a database which you can instantiate an approach exactly like you do with a DBF file. Dick
[toc] | [prev] | [next] | [standalone]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-06-07 22:21 +0000 |
| Message-ID | <4deea46a$0$12376$c30e37c6@exi-reader.telstra.net> |
| In reply to | #1285 |
Dick, Sorry, wrong advice. The VO SQL classes will generate more in lost time and hair pulling than the purchase price of VO2Ado (which is actually very low). I'm not here to drum up business for Robert but this really is the best way to go.The VO SQL classes will just give you endless grief. Geoff "D.J.W. van Kooten" <public@ic2remove.this.com> wrote in message news:lf3tu69abisgai3b17nua7e1ocruv4b6m6@4ax.com: > On Mon, 06 Jun 2011 09:34:27 +0100, Martin <spam@spam.spam> wrote: > > Hello Martin. > > > > >I need to read abd write to an access file, how do I do use them please? > > > > The simplest way in VO (without the need to buy Vo2ADo) is to create > an ODBC connection with this database using Windows. Then go to the > DBServer editor and select New entity, SQL Editor. > > Unfortunately it's been a few years ago so I am not sure anymore about > the exact order/steps but in the end you will have a database which > you can instantiate an approach exactly like you do with a DBF file. > > Dick
[toc] | [prev] | [next] | [standalone]
| From | D.J.W. van Kooten <public@ic2remove.this.com> |
|---|---|
| Date | 2011-06-10 11:50 +0200 |
| Message-ID | <tvp3v61qm4c09ttlq4gv4okhiiaab69hf4@4ax.com> |
| In reply to | #1290 |
On Tue, 7 Jun 2011 22:21:29 +0000, "Geoff Schaller" <geoffx@softwarexobjectives.com.au> wrote: Hello Geoff, > >Sorry, wrong advice. The VO SQL classes will generate more in lost time >and hair pulling than the purchase price of VO2Ado (which is actually >very low). I'm not here to drum up business for Robert but this really >is the best way to go.The VO SQL classes will just give you endless >grief. > I agree with you (surprise, surprise...<g>) but having said that, once an ODBC connection was set up to the Access database (in Windows, which was the hardest part) I found (years ago) that having access to Access (I used it read only) was working without problems. Depending on the goal (full blown data processing or just able to read some data besides your own dbf data) it could be a quick solution without the need to install anything. Dick
[toc] | [prev] | [next] | [standalone]
| From | "Geoff Schaller" <geoffx@softwarexobjectives.com.au> |
|---|---|
| Date | 2011-06-10 21:27 +0000 |
| Message-ID | <4df28c50$0$12373$c30e37c6@exi-reader.telstra.net> |
| In reply to | #1346 |
..and that is the secret. If you have a quick solution to a simple need than I would always advocate using it. The problem with the VO sql classes and odbc is that if you start to need more, you will get into trouble <g>. Guaranteed. Geoff "D.J.W. van Kooten" <public@ic2remove.this.com> wrote in message news:tvp3v61qm4c09ttlq4gv4okhiiaab69hf4@4ax.com: > On Tue, 7 Jun 2011 22:21:29 +0000, "Geoff Schaller" > <geoffx@softwarexobjectives.com.au> wrote: > > Hello Geoff, > > > > >Sorry, wrong advice. The VO SQL classes will generate more in lost time > >and hair pulling than the purchase price of VO2Ado (which is actually > >very low). I'm not here to drum up business for Robert but this really > >is the best way to go.The VO SQL classes will just give you endless > >grief. > > > > I agree with you (surprise, surprise...<g>) but having said that, once > an ODBC connection was set up to the Access database (in Windows, > which was the hardest part) I found (years ago) that having access to > Access (I used it read only) was working without problems. > > Depending on the goal (full blown data processing or just able to read > some data besides your own dbf data) it could be a quick solution > without the need to install anything. > > Dick
[toc] | [prev] | [next] | [standalone]
| From | Martin <spam@spam.spam> |
|---|---|
| Date | 2011-06-08 15:02 +0100 |
| Message-ID | <zhLHp.9373$w86.5757@newsfe22.ams2> |
| In reply to | #1254 |
Thanks for all the replies The Access files will be accessed by our current software as we will need to update values of things used. Not a lot of access, just very occasionally. ODBC access if easy enough should be fine. Any simple worked examples? Thanks Martin
[toc] | [prev] | [standalone]
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web