OpenEuphoria

Re: EDS and SQL

• Posted by Matthew Lewis <MatthewL at KAPCOUSA.COM> Aug 30, 2000
• 487 views

> -----Original Message-----
> From:  budmeister1 at JUNO.COM
>
> I was working on the beginnings of an SQL engine for EDS called EQUAL,
> but I
> didn't really get very far on it (due to lack of time). But, I'm in
> college
> now, so maybe I'll have some more spare time to put into it.
> Now that EDS
> 0.5
> has been out for a while, it seems like this would be the
> time to do it.
>
> If you're interested in helping with it, I'd be more than
> happy to work
> with
> you :)  The same offer goes out to anyone else interested also.
>
> Btw, does anyone have suggestions for improvements/fixes to the EDS
> Toolbox?
>

How far along have you gotten with your SQL engine?  I've made some progress
with my code.  It's much more robust than the original version I put up on
the user contributions page.  Inner, right and left joins all seem to work
now, and you can also sort using 'order by' commands.

Some of the restrictions I had originally are gone.  In your select
statement, you don't have to include the fields that are being joined, and
there is no need to keep fields from the same table together.

My to do list (not necessarily in this order) looks something like this:
* calculated fields
* more complicated 'WHERE' statements (nested 'AND's and 'OR's)
* append, update, union queries

The latest (v0.2a) is at:


Matt Lewis