Jump to content

syahmicro

Members
  • Posts

    6
  • Joined

  • Last visited

syahmicro's Achievements

Newbie

Newbie (1/7)

1

Reputation

  1. 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
  2. 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
  3. 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;}
  4. 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?
  5. any idea guys?this is my final year project,may i have guide from u guys........................
×
×
  • Create New...