syahmicro

SQLite version 3.7.13 2012-06-11 02:05:22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table tbl1(char ,int ); ...> insert into tbl1 values('kenneth,10); ...> ;...> ;...>; i has been installed SQLite on ubuntu 12.04lts i got this problem,as u can see from that statement i justdeliberate to dump the comma at 'kenneth.supposely when there have missing character such as comma it must be show the syntax error but then when need terminate the statement i could not work.I don't what is the problem because i was tried 2 times installing sqlite on ubuntu 12.04 so from this,i would like to make another coding to fix up this problem by using c programmingbut then do you all have ideas to make coding?so we can access with sqlite using this commandgcc -o file file.c -lsqlite3 in sqlite,there are having files which is header file and c files.sqlite3.cshell.c

yeah i know that,but I have a problem to change the coding in the shell file which shell.c it is run using gcc compiler,thus i curious if it can be modify the coding there for enhance this type of problem

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;}

thank you bro...

i'm asked for limitations on sqlite..now i was install sqlite3 in my ubuntu.Thus what is limitations on sqlite3 it self,and how to make it the password and protection?

any idea guys?this is my final year project,may i have guide from u guys........................