New to SQL, SQLite, and the Delphi wrapper I'm using to talk to sqlite.dll.
A couple of questions: 1. How can I get the dll to return JUST the desired data? When I send the following SQL, for example, select colEntry from tblEntry where colNum = 3 the textbox shows colEntry "The text in the column." <newline> What I really want is just: The text in the column. No header, no quotes, and no newline. Just data. I get the impression the dll is sending all this back, not that the Delphi code is adding it. If so, any way to supress, or must I strip the unneeded stuff off? 2. The Delphi setup is using the 2.something dll. Can I drop in the 3.something dll and change the 'sqlite.dll' line to 'sqlite3.dll' and expect it to work the same? If so, would there be any advantages? Thanks