Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #1305

Re: Reading Access files

From "Willie Moore" <williem@wmconsulting.com>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Reading Access files
Date 2011-06-08 08:42 -0500
Organization Aioe.org NNTP Server
Message-ID <isnu7p$ea9$1@speranza.aioe.org> (permalink)
References <isl5j1$l8l$1@speranza.aioe.org> <4deea631$0$12375$c30e37c6@exi-reader.telstra.net>

Show all headers | View raw


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

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

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

csiph-web