[sqlite] Cannot get it to work

[Erwin Jabor]

Hello Richard.

I have a great problem. Until 3.0 everyting was working perfect. Then I try
since it is avalable to implement it. What ever I do I cannot get it
working. Finally I make a very simple testroutine for 2.x. No problem. Works
like a sharm.
Then I try to implement 3.0.1 in this. No success. I cannot get it to work.
 I cannot even create a file manually: "SQLite3 create database test.db / ".

Using here : WindowsXP.

I know you are full of work. Please help just this time to bring this
following testprogram to work.
Or maybe a other "Crack" can help in this case.

Thanks in advance.

Erwin


here the v2.x version:
//-------------------------------------------------------------------------

#include <stdio.h>
#include "sqlite.h"

static int callback(void *NotUsed, int argc, char **argv, char **azColName)
{
 int i;
 for(i=0; i<argc; i++)
 {
  printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
 }
 printf("\n");
 return 0;
}

int main()
{
 char *errMsg;
 sqlite *db = sqlite_open("DBase.000", 1, &errMsg);
 if(!db)
 {
  fprintf(stderr, "Could not open the database!\n");
  return 42;
 }

 sqlite_exec (db, "DROP   TABLE  Petty", callback, 0, &errMsg);
 sqlite_exec (db, "CREATE TABLE  Petty(SQLRe INTEGER PRIMARY KEY, SQLDat
VARCHAR(22))", callback, 0, &errMsg);
 sqlite_exec (db, "INSERT INTO   Petty VALUES(NULL              ,
'2002-11-12'      )", callback, 0, &errMsg);
 sqlite_exec (db, "SELECT * FROM Petty"
, callback, 0, &errMsg);
 sqlite_close(db);
 return 0;
}

//------------------------------------------------------------------------




---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.699 / Virus Database: 456 - Release Date: 6/4/2004




---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]