RE: [sqlite] Difficulty with sqlite3.3.6 under VisualStudio.net

The warnings are normal and unless you want to rewrite sqlite, not much you can do about them. Not sure about the run-time check failure _ From: Dixon Hutchinson [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 8:41 AM To: sqlite-users@sqlite.org Subject: [sqlite] Diff

[sqlite] INSERT into a whole table at once

I have a big table and I want to change all the values in a row to the same thing but I'm not sure what key word would allow me to do this. I tried things like: INSERT INTO Table ALL VALUES ("test"); But it has an error on the ALL. I tried putting the ALL in lots of different places but it didn'

RE: [sqlite] Re: Which API to use to get resultant of query

> Ya now i am getting error code which says SQLITE_DONE...so how can get my > resultant now? > Which API i should use?Please tell me After running prepare, you can get the data like this: //This while loop will step through every row one by one while (sqlite3_step(pStmt) == SQLITE_ROW) {

RE: [sqlite] Retrieving data

> > I tried: > > sqlite3_exec(AccDataBase,"SELECT Name,Address FROM Accounts WHERE > MemberNo = > > 2;",Callback(cError,10,&result,&Names),test,&cDatabaseError); > > You don't need a Callback-Function in any case. Try it > without I'm confused. How does the SELECT command return any data? I

[sqlite] Retrieving data

Hi all. I'm using sqlite in VC++ 2005. When I started this I knew nothing about sqlite or indeed SQL at all so its been tough going trying to work out how this all works. So far I have created a database and a table and added columns and rows filled with data. But I'm having trouble retrieving th

RE: [sqlite] building sqlite.lib

> Download the source with the .DEF file, then run: > > LIB /DEF:sqlite.def > > That will make a lib file. Pardon my ignorance, but run how? What sort of command is that? I tried in the dos shell that obviously didn't work, oh I'm running win XP if that makes a difference. Where do I run this

[sqlite] building sqlite.lib

Hi. I'm trying to use sqlite with VC++ 2005, I downloaded the sqlitedll-3_3_7.zip but it seems I need a .lib file as well. Does anyone know where I can get one? After reading some messages here, I tried building the source as a .dll project but all I got was the .dll it didn't make a .lib I'm s