Zeoslib Portal

get sqlite3.dll from sqlite site for a start... you don't need to copy it to windows folder, it will work if you copy dll to application folder...

bad news for my app
thnx...

Adding Conf.ZQuery.Close on top is good idea...

Hi everyone. can some one help me with this? When i try to exec sql query on sqlite2 database i get "sql error file is encrypted or not database". When i exec it on sqlite3 file everything is ok... sqlite2 database has only one table with few fields (it's created for connectivity test). I ...

i don't have experience with lazarus, but on windows, i should go with TDateTimePicker... i bet there's one on lazarus...

edits are very bad way to enter TDateTime...

can someone post link to lastest zeos build?
thnx

Anyone tried Zeos 7 on new delphi yet?

found it...

need to use ParamByName.AsAnsiString instead of ParamByName.AsWideString...

hello, can some one help me with this? when i execute this code i get "SQL syntax error near ')'" for some reason... when i change ParamByName.AsWideString to ParamByName.Value, my comand execute fine without errors.... table in my database is in utf8 with one text and one varchar field......

I think you can send every non select in the same query, call execsql and then set your select statment and open it. You can, but from my experience, it's safer to exec them one by one... sometimes (when queries are to long or there is to many of them) some of queries won't execute and there's no e...

You can't "drop table if exists..." with open... also can't create table with open... try this... drop table if exists tempTable; execsql; create temporary table tempTable( id char(10) not null primary key, value1 float null, value2 float null); execsql; insert into tempTable (id, value1, ...

i have same problem with d2007... it looks like '00:00:00' value is interpreted as null somewhere...

I think you need to copy all bpl files from build folder to windows\system(32/64)... That's how i solved problem on win7/D2010...

From my knowledge, if you have a table wih 256 fields, something is teribly wrong with your database design....