i set up a directory c:\projects\lib\libsql.
everything is dumped in it except that i only use sqlite.dll instead of dumping all the dlls in that directory. i put the path in tools environment options in delphi under library path. i added the units to the project and put uses libsqlite,passqlite; under implementation of unit1.pas .
i cant get it to open or create a db. i looked for somedb on my computer but dont find it. i am using libsql.0.46. this is the folder i used to extract to c:\projects\lib\libsql.
here is some sample code. it shows the message null which is expected but i cant find the newly created db or if i change it around cant open an existing one. thanks for any assistance.
jim
i am kind of new to delphi. i used it years ago when it first came out unsuccessfully. since then i took a few programming courses at college and am giving it another try.
procedure TForm1.Button1Click(Sender: TObject);
var
db: TLiteDB;
somestring: string;
begin
try
db:=TLiteDB.Create (self,'somedb');
db.Query ('select * from mtdew');
somestring:=db.Results[0][0];
showmessage(somestring);
if db.Results[0].IsNull[0] then
ShowMessage ('null');
Finally
db.Free;
end;
end;
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i spent some more time fooling around with libsql. i checked out the demo and tested a query against one of my dbs and it worked fine. so it was able to load the dll and execute a query against the db.
i dont have any idea what i am doing wrong.
i tried installing as a component. i got the component on the component pallete and put it on a form but it doesnt want to activate or load the dll.
i am new with this so i know it is me and not your software.
if you have some ideas ...please let me know.
thank you very much,
jim
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi-
i set up a directory c:\projects\lib\libsql.
everything is dumped in it except that i only use sqlite.dll instead of dumping all the dlls in that directory. i put the path in tools environment options in delphi under library path. i added the units to the project and put uses libsqlite,passqlite; under implementation of unit1.pas .
i cant get it to open or create a db. i looked for somedb on my computer but dont find it. i am using libsql.0.46. this is the folder i used to extract to c:\projects\lib\libsql.
here is some sample code. it shows the message null which is expected but i cant find the newly created db or if i change it around cant open an existing one. thanks for any assistance.
jim
i am kind of new to delphi. i used it years ago when it first came out unsuccessfully. since then i took a few programming courses at college and am giving it another try.
procedure TForm1.Button1Click(Sender: TObject);
var
db: TLiteDB;
somestring: string;
begin
try
db:=TLiteDB.Create (self,'somedb');
db.Query ('select * from mtdew');
somestring:=db.Results[0][0];
showmessage(somestring);
if db.Results[0].IsNull[0] then
ShowMessage ('null');
Finally
db.Free;
end;
end;
hi-
i spent some more time fooling around with libsql. i checked out the demo and tested a query against one of my dbs and it worked fine. so it was able to load the dll and execute a query against the db.
i dont have any idea what i am doing wrong.
i tried installing as a component. i got the component on the component pallete and put it on a form but it doesnt want to activate or load the dll.
i am new with this so i know it is me and not your software.
if you have some ideas ...please let me know.
thank you very much,
jim
never mind. it is working. i will write down the steps to make it work and save them on my computer.
thanks,
jim