Jump to content

problem with sqlite


syahmicro
 Share

Recommended Posts

i had some problems with sqlite while i create tbl.beside that,can we modify existing programs to reduce this problem

sqlite> create table tbl1(one varchar(10), two smallint);sqlite> insert into tbl1 values('hello!',10);sqlite> insert into tbl1 values('goodbye', 20);sqlite> insert into tbl1 values('hello maye, 30);   ...> insert into tbl1 values('hello maye', 30);   ...> ;   ...> ;   ...> '   ...> '   ...> ;   ...> ;   ...> ;   ...> '   ...> ;Error: near "hello": syntax errorsqlite>    is it true?   [CODE]/* Run commands received from standard input    */    if( stdin_is_interactive ){	  char *zHome;	  char *zHistory = 0;	  int nHistory;	  printf(	    "SQLite version %s %.19s\n" /*extra-version-info*/	    "Enter \".help\" for instructions\n"	    "Enter SQL statements terminated with a \";\"\n",	    sqlite3_libversion(), sqlite3_sourceid()	  );	  zHome = find_home_dir();	  if( zHome ){	    nHistory = strlen30(zHome) + 20;	    if( (zHistory = malloc(nHistory))!=0 ){		  sqlite3_snprintf(nHistory, zHistory,"%s/.sqlite_history", zHome);	    }	  }#if defined(HAVE_READLINE) && HAVE_READLINE==1	  if( zHistory ) read_history(zHistory);#endif	  rc = process_input(&data, 0);	  if( zHistory ){	    stifle_history(100);	    write_history(zHistory);	    free(zHistory);	  }    }else{	  rc = process_input(&data, stdin);    }  }  set_table_name(&data, 0);  if( data.db ){    sqlite3_close(data.db);  }  return rc;}

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...