OpenEuphoria

2. Re: eDBI problem simplified

• Posted by ChrisB (moderator) Jan 04, 2010
• 1152 views

Hi

Thats actually quite strange, because in sqlite3 all data fields are strings, I know edbi does some conversion, but for some reason its not recognising the strings as strings.

Try

while 1 do  
	    object o = edbi:next(dbr)  
	    if atom(o) then exit end if  
	    printf(1, "Desc=%s, Dues=%d length=%d\n", { o[1], o[2], length(o[1])})  
	end while  
	edbi:closeq(dbr)  
	  
	data = edbi:query_rows("SELECT * FROM MembershipTypes")  
	for i = 1 to length(data) do  
	    object o = data[i]  
	    printf(1, "Desc=%s, Dues=%d length=%d\n", { o[1], o[2], length(o[1])})  
	end for 	 

Looks like empty strings are being returned, the above will confirm it, if so there's an edbi problem.

4. Re: eDBI problem simplified

• Posted by RogerL Jan 04, 2010
• 1151 views

Further - in ex.err it shows that the value of data is correct! ie

example.ex: data = { { {70'F',117'u',108'l',108'l',32' ',77'M',101'e',109'm',98'b', 101'e',114'r'}, 140 }, { {67'C',111'o',117'u',110'n',116't',114'r',121'y',32' ',77'M', 101'e',109'm',98'b',101'e',114'r'}, 70'F' }, { {83'S',101'e',99'c',114'r',101'e',116't',97'a',114'r',121'y'}, 10 } }

6. Re: eDBI problem simplified

• Posted by ChrisB (moderator) Jan 04, 2010
• 1239 views

Hi

I'm afraid I can't help you any more with eDBI - there may be a simple thing you are doing wrong, or it may be that that the interface has a problem - I have had a look through the code, and what's basically happening is your program is calling the euphoria eDBI include, which is then calling a C library which then calls sqlite - and this is written by someone who programs for a living, so it starts to become hideously complicated for mortals to read (or me at least)!

However, if you want a quick and reliable way to read sqlite databases, then use eusqlite (originally by Ray Smith, maiantained (sort of) by me, and write your own conversion routine to one of the many other database wrappers available. I'm sure that eDBI is going to be great, but it has a level of complexity that at this stage I (personally) just don't need, and also will cater to the 'lowest common denominator' set of functions for all the databases.

eusqlite is here http://eusqlite.wikispaces.com/

Cheers

Chris

8. Re: eDBI problem simplified

• Posted by mattlewis (admin) Jan 07, 2010
• 1213 views

I took a quick look at this today. There were a couple of changes required. Basically, I'd updated it previously to work with an earlier v4, but the std library had changed slightly, and some new reserved words happened. I updated these spots in the several libraries used by wxedb to work with the current head of the trunk. The easiest way right now (I'm not going to package it up ATM) is to just get them from their various svn repositories. There are several, and I think that these are all of them:

https://wxedb.svn.sourceforge.net/svntrunk/wxedb/trunk 
https://ooeu.svn.sourceforge.net/svntrunk/ooeu/trunk 
https://eudbc.svn.sourceforge.net/svntrunk/eudbc/trunk 
https://eusql.svn.sourceforge.net/svntrunk/eusql/trunk 
https://euslibs.svn.sourceforge.net/svntrunk/euslibs/trunk 
https://matheval.svn.sourceforge.net/svntrunk/matheval/trunk 

These are in addition, of course, to the latest bleeding edge version of wxEuphoria. I recommend checking them out to their respective directories, and then adding those directories to your eu.cfg file.

I haven't done extensive testing, but I was able to run it and open a database and inspect some data.

Matt