1. RE: Euphoria Database Browser
Matt,
Just downloaded the update.
I added some nested sequence fields to an existing database (i.e. -
name.last, name.first, name.middle), change the text in new columns on
the data tab and when I clicked "Save" I got the following error:
C:\EuTools\eusql\edbs.exw:11703 in procedure do_eusql_update()
subscript value 1 is out of bounds, reading from a sequence of length 0
... called from C:\EuTools\eusql\edbs.exw:11788 in procedure
do_select_cell()
... called from C:\EuTools\eusql\edbs.exw:11874 in procedure
save_record_proc()
... called from C:\EuTools\eusql\edbs.exw:8685 in function
event_handler()
^^^ call-back from Windows
... called from C:\EuTools\eusql\edbs.exw:8135 in procedure
call_thiscall_proc()
... called from C:\EuTools\eusql\edbs.exw:8140 in function
call_thiscall()
... called from C:\EuTools\eusql\edbs.exw:8185 in function call_member()
... called from C:\EuTools\eusql\edbs.exw:8936 in procedure wxMain()
... called from C:\EuTools\eusql\edbs.exw:13190
--> see ex.err
Press Enter...
I can send you the .edb file too, if that helps.
Jonas
Matt Lewis wrote:
>
> OK, I'm now declaring it to be in Beta release. I believe I've
> addressed all the issues that Jonas brought up (except for the strange
> crashes on exit, since I haven't been able to duplicate them). I've
> also added everything that I wanted to add. I haven't heard anything
> from anyone else regarding EDB, but I'd be happy to know about any
> problems or requests.
>
> EDB will now import/export using tab delimited text files. It will also
>
> export tables and the results of queries to other EDS databases.
>
> Also included in the zip is my working (unreleased v0.74) version of
> EuSQL, which includes some bug fixes and an updated help file.
>
> Matt Lewis
> http://www14.brinkster.com/matthewlewis/projects.html
>
>
2. RE: Euphoria Database Browser
That's strange. I'm not clear on exactly what you did, and I haven't been
able to replicate. What did the table look like before you added the
fields? Did you save the changes to the table before entering new data?
Please send the file so I can look at it.
Matt Lewis
> -----Original Message-----
> From: Jonas Temple [mailto:jtemple at yhti.net]
>
> Just downloaded the update.
>
> I added some nested sequence fields to an existing database (i.e. -
> name.last, name.first, name.middle), change the text in new
> columns on
> the data tab and when I clicked "Save" I got the following error:
>
>
> C:\EuTools\eusql\edbs.exw:11703 in procedure do_eusql_update()
> subscript value 1 is out of bounds, reading from a sequence
> of length 0
> ... called from C:\EuTools\eusql\edbs.exw:11788 in procedure
> do_select_cell()
> ... called from C:\EuTools\eusql\edbs.exw:11874 in procedure
> save_record_proc()
>
> ... called from C:\EuTools\eusql\edbs.exw:8685 in function
> event_handler()
>
> ^^^ call-back from Windows
> ... called from C:\EuTools\eusql\edbs.exw:8135 in procedure
> call_thiscall_proc()
>
> ... called from C:\EuTools\eusql\edbs.exw:8140 in function
> call_thiscall()
> ... called from C:\EuTools\eusql\edbs.exw:8185 in function
> call_member()
> ... called from C:\EuTools\eusql\edbs.exw:8936 in procedure wxMain()
> ... called from C:\EuTools\eusql\edbs.exw:13190
> --> see ex.err
>
>
> Press Enter...
>
> I can send you the .edb file too, if that helps.
>
> Jonas
>
> Matt Lewis wrote:
> >
> > OK, I'm now declaring it to be in Beta release. I believe I've
> > addressed all the issues that Jonas brought up (except for
> the strange
> > crashes on exit, since I haven't been able to duplicate
> them). I've
> > also added everything that I wanted to add. I haven't
> heard anything
> > from anyone else regarding EDB, but I'd be happy to know about any
> > problems or requests.
> >
> > EDB will now import/export using tab delimited text files.
> It will also
> >
> > export tables and the results of queries to other EDS databases.
> >
> > Also included in the zip is my working (unreleased v0.74)
> version of
> > EuSQL, which includes some bug fixes and an updated help file.
> >
> > Matt Lewis
> > http://www14.brinkster.com/matthewlewis/projects.html
> >
> >
>
>
> TOPICA - Start your own email discussion group. FREE!
>
3. RE: Euphoria Database Browser
OK, I think I figured this out. It looks like I didn't update the
eusql_datatype variable after making changes to the table. I found a
similar feeling bug (although the actual cause is quite different) where if
you create a db, then a table, then add some fields, database.e will crash.
It was a EuSQL bug that could cause multiple copies of a database to be
opened, and that caused problems when reading and writing to the file. I'll
probably post a bug fix later today (for both issues).
To work around the bug you found, click the cancel button after a save.
This should make sure that everything is properly refreshed. As for the
second, it is necessary to close EDB after creating a EuSQL database, then
reopen it to work with it. Normal EDS files shouldn't be affected.
Thanks for the input and testing!
Matt Lewis
> From: Jonas Temple [mailto:jtemple at yhti.net]
> I added some nested sequence fields to an existing database (i.e. -
> name.last, name.first, name.middle), change the text in new
> columns on
> the data tab and when I clicked "Save" I got the following error:
<snipped>
4. RE: Euphoria Database Browser
Matt Lewis wrote:
>
>
> I've updated EDB. It gives you an example of what you can do with
> euscript.
> I've added a feature (still pretty rough, but mainly functional) to
> allow
> you to create forms to view and edit data (like MS Access). You can
> script
> event routines as part of the form. I've included a conversion of
> archive.edb, along with a couple of forms as an example.
>
> http://www14.brinkster.com/matthewlewis/projects.html
>
> The app is 'clear shrouded', although I've included the main source
> files
> (didn't want to include EuSQL and wxEuphoria). Of course, it still
> requires
> the wxEuphoria dll:
>
> http://wxeuphoria.sourceforge.net
>
>
> Matt Lewis
>
Hi Matt
I'm trying to run your browser and got the folloing message:
C:\Euphoria\Matt\Wx\src\msw\dialog.cpp(174):assert failed: Failed to
create dialog. You probably forgot to include wx/msw/wx.rc in your
resources. Do you want to stop the program?
You can also choose [Cancel] to suppress further warning. Yes No Cancel.
What exactly should I do to get this baby going?
Thanks
Serge Lavigne
5. RE: Euphoria Database Browser
--- jondolar <lavigne.s at videotron.ca> wrote:
> I'm trying to run your browser and got the folloing message:
>
> C:\Euphoria\Matt\Wx\src\msw\dialog.cpp(174):assert failed: Failed to
> create dialog. You probably forgot to include wx/msw/wx.rc in your
> resources. Do you want to stop the program?
> You can also choose [Cancel] to suppress further warning. Yes No Cancel.
>
> What exactly should I do to get this baby going?
I'm not sure. Someone else reported this error before, but I haven't been able
to duplicate it. What version of windows are you running?
Matt Lewis
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
6. RE: Euphoria Database Browser
Matt Lewis wrote:
>
>
> --- jondolar <lavigne.s at videotron.ca> wrote:
>
>
> > I'm trying to run your browser and got the folloing message:
> >
> > C:\Euphoria\Matt\Wx\src\msw\dialog.cpp(174):assert failed: Failed to
> > create dialog. You probably forgot to include wx/msw/wx.rc in your
> > resources. Do you want to stop the program?
> > You can also choose [Cancel] to suppress further warning. Yes No Cancel.
> >
> > What exactly should I do to get this baby going?
>
> I'm not sure. Someone else reported this error before, but I haven't
> been able
> to duplicate it. What version of windows are you running?
>
> Matt Lewis
>
> XP Pro
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
>
7. RE: Euphoria Database Browser
Hi Matt
I did 7 error messages screen capture about the browser. I would like to
send you the file personnally. but I don't have an Email adresse for
you. Can I get it or is there another way to send it to you
Regards
Serge Lavigne
8. RE: Euphoria Database Browser
Didn't seem to go 1st time sorry if this is double up.
Hello Matt,
Trying your EUDB Browser
If I run EDB.EXW I get following error:
C:\tony\eds\edb.exw:3
can't find exceptions.ew in C:\tony\eds
or in C:\EUPHORIA\EXINCLUDE; C:\EUPHORIA\WIN32LIB
or in C:\EUPHORIA\include
include exceptions.ew
^
If I run EDBS.EXW I get Following Error:
C:\Euphoria\Matt\Wx\src\msw\dialog.cpp(174):assert failed: Failed to
create dialog. You probably forgot to include wx/msw/wx.rc in your
resources. Do you want to stop the program?
You can also choose [Cancel] to suppress further warning. Yes No Cancel.
If I choose Cancel the program just seizes. If I choose Yes I get the
err file which you can download if interested from
http://members.dodo.net.au/~tsteward/Software/edbex.err
Thanks,
Tony Steward
BTW
WINXP Home, WIN32LIB 59.1, EU2.4
9. RE: Euphoria Database Browser
Yes, there seems to be a problem with wxEuphoria and WinXP. I haven't
figured it out yet, but I think I've decided to port EDB over to win32lib.
Give me a week or two, and I should have it working.
> -----Original Message-----
> From: Tony Steward [mailto:tsteward at dodo.com.au]
> Hello Matt,
> Trying your EUDB Browser
>
> If I run EDB.EXW I get following error:
> C:\tony\eds\edb.exw:3
> can't find exceptions.ew in C:\tony\eds
> or in C:\EUPHORIA\EXINCLUDE; C:\EUPHORIA\WIN32LIB
> or in C:\EUPHORIA\include
> include exceptions.ew
> ^
> If I run EDBS.EXW I get Following Error:
> C:\Euphoria\Matt\Wx\src\msw\dialog.cpp(174):assert failed: Failed to
> create dialog. You probably forgot to include wx/msw/wx.rc in your
> resources. Do you want to stop the program?
> You can also choose [Cancel] to suppress further warning. Yes
> No Cancel.
>
> If I choose Cancel the program just seizes. If I choose Yes I get the
> err file which you can download if interested from
> http://members.dodo.net.au/~tsteward/Software/edbex.err
10. RE: Euphoria Database Browser
OK, it went smoother than I thought. I've got it converted to win32lib,
though I don't doubt that I've introduced some new bugs in doing so. You
can get EDB here:
http://www14.brinkster.com/matthewlewis/edb.zip
http://www14.brinkster.com/matthewlewis/projects.html
You'll need a copy of win32lib in order to run it.
Matt Lewis
> From: Matt Lewis [mailto:matthewwalkerlewis at yahoo.com]
> Yes, there seems to be a problem with wxEuphoria and WinXP. I haven't
> figured it out yet, but I think I've decided to port EDB over
> to win32lib.
> Give me a week or two, and I should have it working.
11. RE: Euphoria Database Browser
Thanks, CK. You can fix it by adding an if statement around setHandler:
if length(recent_menu) then
setHandler( recent_menu[1..length(recent_menu)-1], w32HClick, orf)
end if
I've uploaded an updated copy, and also included my testing db (sql.edb),
which is the ARCHIVE.EDB provided by RDS that I've converted to EuSQL
format. It has a couple of [crude] forms included.
http://www14.brinkster.com/matthewlewis/projects.html
Matt Lewis
> From: C. K. Lester [mailto:cklester at yahoo.com]
> recent_menu is length(0) at the beginning, so this section
> fails for me:
>
> procedure open_recent_file( integer id, atom event, sequence params )
> sequence swap
>
> id = find( id, recent_menu )
> recent_files = {recent_files[id]} & recent_files[1..id-1] &
> recent_files[id+1..length(recent_files)]
> update_recent()
> do_open( recent_files[1][1] & recent_files[1][2] )
> end procedure
> orf = routine_id("open_recent_file")
> setHandler( recent_menu[1..length(recent_menu)-1], w32HClick,
> orf) -- <--
> fails here
