1. RE: EuSQL and EDB
Matt,
Wow! EuSQL has come a long way! (At one point in time I was working on
an SQL querying tool that would use either your ODBC or EuSQL wrapper,
but never got too far).
Here's some things I noticed:
- On my Win2K machine the button/edit controls overlap on the "Tables"
tab
- Open an EuSQL file, select the "Data" tab, select a table and click
"Save Record" without making any changes. Program crashes.
- On the "Table Definition" tab a prior table's definition is displayed
when opening a non-EuSQL .edb file.
- Start the program. Without doing anything else, close the program.
On my Win2K machine I get an exception screen. This exception also
appears at other times when the program closes.
- Start the program. Without opening a file, select the "View as EDS"
from the "Database" menu. Program crashes.
- I got a trace screen when defining fields in a new database.
Hope you don't think I'm too critical but I think you're on the right
track and want to help in any way I can!
Jonas
Matt Lewis wrote:
>
> Hello,
>
> I've submitted to Rob an update to EuSQL (anyone currently using EuSQL
> should upgrade, as this has several bug fixes and some optimizations)
> and
> EDB (Euphoria Database Browser).
>
> EDB will be useful for anyone working with EDS databases, as it allows
> you
> to view, create and edit EDS databases. If you're using EuSQL
> databases, it
> also allows you to run SQL statements interactively. The only things
> planned but not implemented are the import and export features (plus, of
> course, running on Linux). You will need the wxEuphoria DLL in order to
> run
> this, though you don't need the wxEuphoria library source, since I've
> done a
> clear shroud on it, as the library is somewhat in flux right now. I've
> also
> included the main source to edb.exw, if you're interested in seeing how
> to
> work with wxEuphoria.
>
> You can get EDB (~200K) at:
>
> http://www14.brinkster.com/matthewlewis/projects.html
>
> and the DLL (~1MB) at:
>
> http://www.sourceforge.net/projects/wxeuphoria
>
>
> Matt Lewis
>
>
2. RE: EuSQL and EDB
> From: Jonas Temple [mailto:jtemple at yhti.net]
> Wow! EuSQL has come a long way! (At one point in time I was
> working on
> an SQL querying tool that would use either your ODBC or EuSQL
> wrapper,
> but never got too far).
Thanks. In fact, I've considered adding ODBC support to EDB, but first I
want to focus on EDS databases.
> Here's some things I noticed:
>
> - On my Win2K machine the button/edit controls overlap on the
> "Tables"
> tab
OK, I think this is a settings issue. I'll put those into sizers, and the
problem should disappear. BTW, most of the development and testing has been
done under Win2K.
> - Open an EuSQL file, select the "Data" tab, select a table and click
> "Save Record" without making any changes. Program crashes.
Fixed this.
> - On the "Table Definition" tab a prior table's definition is
> displayed
> when opening a non-EuSQL .edb file.
Fixed.
> - Start the program. Without doing anything else, close the
> program.
> On my Win2K machine I get an exception screen. This exception also
> appears at other times when the program closes.
Occaisionally I get these sort of problems (although I thought I'd fixed
them all, 'cause I don't get crashes anymore). My suspicion is that I have
incorrectly declared the size of some object. Most wxWindows objects will
tell you their size, but some don't, and I've basically estimated and used
trial and error to figure these out.
> - Start the program. Without opening a file, select the
> "View as EDS"
> from the "Database" menu. Program crashes.
Fixed.
> - I got a trace screen when defining fields in a new database.
Oops, left that in...
> Hope you don't think I'm too critical but I think you're on the right
> track and want to help in any way I can!
Nope, that's just the sort of thing I need--someone who can figure out how
to break it. I've posted the updated version in the same place
(http://www14.brinkster.com/matthewlewis/projects.html).
Matt Lewis
3. RE: EuSQL and EDB
Matt,
Tried the new version and a few more comments:
- I didn't mention this before, but I can't run edb.exw. It's looking
for exceptions.e.
- Buttons/edit controls on the initial tab control are still overlapped.
- If I add a new column to a table and then switch to the "SQL" tab the
new columns don't show under the table. I have to close/open the file
to see the changes.
- I'm a little fuzzy on the implementation of indexes. I THINK I
created an index. I went to the "Data" tab and typed a new record into
the index table. I couldn't find any info on what the LIST.VAL and
LIST.KEY columns required. I assumed they were a reference to the
column names for the values and keys? I got the record to create but I
was looking for a method of doing a "select *" against the index name.
Any clarification on this?
Looking GOOD!
Jonas
4. RE: EuSQL and EDB
> From: Jonas Temple [mailto:jtemple at yhti.net]
>
> Tried the new version and a few more comments:
> - I didn't mention this before, but I can't run edb.exw.
> It's looking
> for exceptions.e.
Right. There'll be a bunch of stuff it won't find. I actually included
that so you could see the source, without having to have wxEuphoria and
EuSQL separately. When I get beyond the alpha release, I plan to *not*
release the shrouded version.
> - Buttons/edit controls on the initial tab control are still
> overlapped.
No, I hadn't fixed that yet. :)
> - If I add a new column to a table and then switch to the
> "SQL" tab the
> new columns don't show under the table. I have to close/open
> the file
> to see the changes.
OK. Forgot to rebuild the tree. Fixed.
> - I'm a little fuzzy on the implementation of indexes. I THINK I
> created an index. I went to the "Data" tab and typed a new
> record into
> the index table. I couldn't find any info on what the LIST.VAL and
> LIST.KEY columns required. I assumed they were a reference to the
> column names for the values and keys? I got the record to
> create but I
> was looking for a method of doing a "select *" against the
> index name.
> Any clarification on this?
The proper way to create an index is in the table definition tab, by
entering the name of the index in the Index column for the field.
Truthfully, you should never need to touch INDEXDEF or TABLEDEF (I'm
thinking I should make them readonly unless in View as EDS mode). When an
index is created, a record in INDEXDEF is created, but the TABLEDEF entry
for the table is updated to point to the index. (see TABLEDEF.INDEXED)
LIST.VAL and LIST.KEY make up an associative list, where the unique values
of the indexed fields are stored in VAL, and the keys to those records are
stored in KEY.
> Looking GOOD!
Thanks! I'll probably upload a fresh copy later today...
Matt Lewis
5. RE: EuSQL and EDB
> From: sixs at ida.net [mailto:sixs at ida.net]
> Hi, I downloaded the EUSQL and EDB from your website. I tried to run
SqlRep1
> program to try the delete of a record. Iget the message is
> C:\Euphoria\DEMO\Esq74\eusql.e:5704
> db_rename_table has not been declared
> db_rename_table( table_name, new_name )
> I find a procedure in EDBS exw by that name.Maybe I haven't installed
> something properly
> JIm
db_rename_table is in the newest version of EDS that comes with Euphoria
2.4. I haven't upgraded to 2.4 yet, myself, but you can get the updated
copy of database.e most easily by downloading the Linux version of Euphoria,
since it's not packaged in an installer.
Matt Lewis
