[sqlite] Multi-User design

2004-06-25 Thread Chris Ulliott
Hi All, When using SQLite3 in a multi user environment is it better to have a single table per database file or is it better to have just one file which contains all tables in the database? I am worried about the file locking, I do not want users to have to wait for a table to become accessible

[sqlite] SPLite3 compiling under MS VC6

2004-06-25 Thread Chris Ulliott
Hi All, Does anyone have a VC6 project of the splite3 DLL. I would like the ability to recompile it myself so that I can add my own specific changes etc.. Also when a new release comes out I would like to take the new code, do a comparison to my own, add the changes and re-compile again. When I

Re: [sqlite] SQLite and Windows 2k

2004-06-24 Thread Chris Ulliott
Andy! FANTASTIC JOB! Thank you! Could you also make the source available please and tell me what changes you made? In the future if a new version comes out, it may not include your change and I need it! I would hate to upgrade and loose your change... Thanks again, Great work! Chris >Waho

Re: [sqlite] SQLite and Windows 2k

2004-06-24 Thread Chris Ulliott
x27;t export sqlite3_exec, but will export sqlite_exec. As for the other, I haven't played around with sqlite3 much as I'm in the middle of a project, but I intend to in a couple of days. Thank you. Richard Boehme Chris Ulliott wrote: Hi All, I have downloaded from the downloa

[sqlite] SQLite crashes during rapid inserts!

2004-06-24 Thread Chris Ulliott
Hi all, I am using the SQLite DB with MS VC++ v 6. In the code below you can see I am looping around a ODBC connection to an access database and I am inserting those records into my new SQLite database. My problem is SQLite.dll causes an access violation after inserting about 190 records. Does an

[sqlite] SQLite and Windows 2k

2004-06-24 Thread Chris Ulliott
Hi All, I have downloaded from the downloads page the DLL (Sqlite.dll) for Windows. I have written some code using the API and everything was going great until I needed to do an execute and it came to my attention that the DLL does not export sqlite3_exec Does anybody have a Win32 DLL of SQLi