We are currently looking at your product for inclusion in one of our projects and are encountering a problem that I am unable to solve.
Delphi 2009 and SQLite Database 3.6.23
If I drop a UniConnection on a data module, point it to my SQLite database, set my ClientLibrary and "connect" in design mode, everything appears fine in the project.
If I then disconnect during design time and instead try to connect using that same component with variables, the component says it is connected however it then finds none of my tables.
This is the code I am using to utilize that connection, can someone please tell me what i am missing....
if dmSLICData.dbCommon.Connected = false then
begin
dmSLICData.dbCommon.ProviderName := 'SQLite';
dmSLICdata.dbCommon.Database := CommonDBPath;
dmSLICData.dbCommon.SpecificOptions.Values['ClientLibrary'] := 'c:\NextGen\sqlite3.dll';
dmSLICdata.dbCommon.Connect;
end;
Thanks for any help anyone can provide!
Scott