1. MS ACCESS please help!!

Hi all,

here i am again with the same Question :


Is there any way to read and write records in an MS Access MDB file ??


If anyone knows , please Mail me !!!
(I can't find any info about the Jet engine, and i am stuck in my program)

Thank you

Renzo Beggia
from Belgium.

new topic     » topic index » view message » categorize

2. Re: MS ACCESS please help!!

Wow, that would be great.  Work with Access files from Euphoria.
I guess someone will have to crack open a book and either figure out the
MDB format or Do some fancy Windows programming and hook some DLL's.


We listen.  If we don't answer then we don't know.
        Lucius L. Hilley III
        lhilley at cdc.net
+----------+--------------+--------------+
| Hollow   | ICQ: 9638898 | AIM: LLHIII  |
|  Horse   +--------------+--------------+
| Software | http://www.cdc.net/~lhilley |
+----------+-----------------------------+

> ---------------------- Information from the mail
header -----------------------
> Sender:       Euphoria Programming for MS-DOS
<EUPHORIA at LISTSERV.MUOHIO.EDU>
> Poster:       Renzo Beggia <renzo.beggia at VSK.BE>
> Subject:      MS ACCESS please help!!
> --------------------------------------------------------------------------
-----
>
> Hi all,
>
> here i am again with the same Question :
>
>
> Is there any way to read and write records in an MS Access MDB file ??
>
>
> If anyone knows , please Mail me !!!
> (I can't find any info about the Jet engine, and i am stuck in my program)
>
> Thank you
>
> Renzo Beggia
> from Belgium.
>

new topic     » goto parent     » topic index » view message » categorize

3. Re: MS ACCESS please help!!

On Fri, 17 Mar 2000 15:25:40 -0500, Renzo Beggia wrote:

>Hi all,
>
>here i am again with the same Question :
>
>
>Is there any way to read and write records in an MS Access MDB file ??
>
>
>If anyone knows , please Mail me !!!
>(I can't find any info about the Jet engine, and i am stuck in my program)

I can point you to ODBC on MSDN:
http://msdn.microsoft.com/isapi/msdnlib.idc?
theURL=/library/psdk/dasdk/odbc4vcn.htm

It would be huge project to wrap these functions but would likely be quite
useful.  I have no idea how much work would go into creating a EuODBC
library but it looks like a lot.  I'm interested in doing a front-end for
an Access database as well so maybe I'll take a look.  Even if I don't
finish what I start, I might be able to come up with a good foundation for
others to build on.

Has anybody else considered doing this project?  Any feedback would be nice.

-- Brian

new topic     » goto parent     » topic index » view message » categorize

4. Re: MS ACCESS please help!!

> It would be huge project to wrap these functions but would likely be quite
> useful.  I have no idea how much work would go into creating a EuODBC
> library but it looks like a lot.  I'm interested in doing a front-end for
> an Access database as well so maybe I'll take a look.  Even if I don't
> finish what I start, I might be able to come up with a good foundation for
> others to build on.
This brings up a good point - shouldn't it be possible to write a programme
to automatically create simple euphoria wrappers for something like this?
Just run a programme and poof, you have odbc access? (It would obviously
need fine tuning...)

Nick

new topic     » goto parent     » topic index » view message » categorize

5. Re: MS ACCESS please help!!

Nick Johnson wrote:

>> It would be huge project to wrap these functions but would likely be quite
>> useful.  I have no idea how much work would go into creating a EuODBC
>> library but it looks like a lot.  I'm interested in doing a front-end for
>> an Access database as well so maybe I'll take a look.  Even if I don't
>> finish what I start, I might be able to come up with a good foundation for
>> others to build on.
>This brings up a good point - shouldn't it be possible to write a programme
>to automatically create simple euphoria wrappers for something like this?
>Just run a programme and poof, you have odbc access? (It would obviously
>need fine tuning...)
>
>Nick

Swig for Euphoria. Wouldn't that be nice. Actually, it should be doable.
ODBC has a full API. If Euphoria could directly access these API's without
having to write a wrapper for each one, then all we would need is API doc
for whatever target we had and voila...or poof...as you say. Of course then
all you have to do is be able to read all that lovely API documentation and
make sense of it. Not even Euphoria can do that for you sad

Everett L.(Rett) Williams
rett at gvtc.com

new topic     » goto parent     » topic index » view message » categorize

6. Re: MS ACCESS please help!!

Hi Nick

I think a program to wrap functions for a DLL is a must. I am considering
doing this for the Morfit for Euphoria thing. Whenever they add functions to
the DLL I'm adding the wrappers by hand. It's very easy to miss stuff if
it's been added somewhere in the middle of an include. I'm definitely going
to try it before their next DLL release.

On this topic, could the clever people on the list possibly provide a list
of things to watch out for when creating wrappers? Such a list would be a
handy guide.

Mark


----- Original Message -----
From: Nick Johnson <arachnid at MAD.SCIENTIST.COM>
To: <EUPHORIA at LISTSERV.MUOHIO.EDU>
Sent: Saturday, March 18, 2000 2:32
Subject: Re: MS ACCESS please help!!


> > It would be huge project to wrap these functions but would likely be
quite
> > useful.  I have no idea how much work would go into creating a EuODBC
> > library but it looks like a lot.  I'm interested in doing a front-end
for
> > an Access database as well so maybe I'll take a look.  Even if I don't
> > finish what I start, I might be able to come up with a good foundation
for
> > others to build on.
> This brings up a good point - shouldn't it be possible to write a
programme
> to automatically create simple euphoria wrappers for something like this?
> Just run a programme and poof, you have odbc access? (It would obviously
> need fine tuning...)
>
> Nick

new topic     » goto parent     » topic index » view message » categorize

7. Re: MS ACCESS please help!!

At 10:29 PM 3/17/00 -0500, you wrote:
>Nick Johnson wrote:
>
>>> It would be huge project to wrap these functions but would likely be quite
>>> useful.  I have no idea how much work would go into creating a EuODBC
>>> library but it looks like a lot.  I'm interested in doing a front-end for
>>> an Access database as well so maybe I'll take a look.  Even if I don't
>>> finish what I start, I might be able to come up with a good foundation for
>>> others to build on.
>>This brings up a good point - shouldn't it be possible to write a programme
>>to automatically create simple euphoria wrappers for something like this?
>>Just run a programme and poof, you have odbc access? (It would obviously
>>need fine tuning...)
>>
>>Nick
>
>Swig for Euphoria. Wouldn't that be nice. Actually, it should be doable.
>ODBC has a full API. If Euphoria could directly access these API's without
>having to write a wrapper for each one, then all we would need is API doc
>for whatever target we had and voila...or poof...as you say. Of course then
>all you have to do is be able to read all that lovely API documentation and
>make sense of it. Not even Euphoria can do that for you sad
>
>Everett L.(Rett) Williams
>rett at gvtc.com
>


   This sounds rather fascinating , please give further details ; when able.

new topic     » goto parent     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu