Zeoslib Portal

Posted: **13.01.2006, 20:52**

Dear developers,

Is anyone busy writing support for SQLite3?

Thank you,

ErikL

Posted: **16.01.2006, 16:49**

Yes, it is already available from cvs.

albert

Posted: **17.01.2006, 19:15**

Thanks very much!

One remark:

sqlite3_result_string function is used but does not exist in sqlite3.dll

ErikL

Posted: **02.03.2006, 14:57**

aducom wrote:Yes, it is already available from cvs. (SQLite3 support)

albert

The latest cvs release is "ZeosDBO 6.5.1-alpha CVS release as of 13/10/2005". This version has no SQLite3 support.
Someone can tell me please how can I get the latest cvs build with SQLite3 support?

Posted: **03.03.2006, 07:15**

I have found SQLite3 support units at
http://cvs.sourceforge.net/viewcvs.py/z ... ework/src/

Posted: **03.03.2006, 08:26**

@ all,

Just checkout all the CVS sources from SourceForge CVS and you will get the SQLite3 support you need

.

At the moment there is on plan to release a new CVS version we are still working forward towards ZeosLib 7.0 beta.

Regards.

Posted: **03.03.2006, 09:04**

Thank you very much.

btw I found a little problem when I select a view from database
example:

Code: Select all

CREATE VIEW vabonament AS
SELECT idabonamentu, idpozycji, idumowy, datanaliczen, tryb, ilosc, liczbarat,
CASE
  WHEN tryb IN (1, 2) THEN (SELECT usluga FROM uslugi WHERE iduslugi=(SELECT iduslugi FROM cennik_pozycje WHERE cennik_pozycje.idpozycji=abonament.idpozycji))
  WHEN tryb=3 THEN usluga
END [usluga]
FROM abonament;

when I try to show something from view (SELECT * FROM vabonament) I've get field usluga as INTEGER (should be VARCHAR). The same problem is in SQLite Administrator.

Posted: **09.03.2006, 15:16**

It's a Bug in SQLite2.x

In SQLite3 the Problem is solved.

Posted: **25.03.2006, 12:32**

I found easier way to show this problem (it also appears in 3.x)

Code: Select all

select * from sqlite_sequence;