Zeoslib Portal

What does zeoslib make from your insert statement when sending it to SQLite? You can use a TZSQLMonitor to find that out. not mentioned before that I use TZSQLProcessor to handle instert statement. Seems to me the error comes from SQLite itself. because of a syntax error? I've solved that issues us...

Based on documentaction http://www.sqlite.org/datatype3.html SQLite allow to insert blob file using hex encoding (x character before string), i.e.: INSERT INTO t1 VALUES(x'0500', x'0500', x'0500', x'0500', x'0500'); after executing above example i've got error unrecognized token: x'0500' is there an...

Now everything works fine.

Is possible to put few inserts and updates in one transaction. SQLite code looks like this: with Query.SQL do begin Add('INSERT INTO abc VALUES (''aa'');'); Add('INSERT INTO abc VALUES (''bb'');'); Add('INSERT INTO abc VALUES (''cc'');'); Add('COMMIT;'); end; Query.ExecSQL; The same code doesn't wor...

Problem appears when I use internal functions or expressions and result is a number with decimal separator: SELECT SUM(1.0) fld or SELECT 1.0+2.0 fld After executing I use: ds.FieldByName('fld').AsFloat i've get "3.0 is not a valid floating point value" and here is a bug, in some country's...

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

Thank you very much. btw I found a little problem when I select a view from database example: 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_...