[sqlite] any sql command to synchronize two table

Hi, I have two table with same field: Id int, Content text, Inserttime datatime, Updatetime datatime I want to do this: If id not in the other table, then insert it, if id is same, and inserttime diffirent, then insert it to the other table ; if id is same, and updatetime diffirent, then update

[sqlite] how to realize md5 function

sqlite> select md5('mm1234'); Error: no such function: md5

[sqlite] How to insert a pointer data to sqlite?

I have a data: Id pid namemark 1 0 f1 sample 2 1 f2 sample 3 1 f3 sample 4 2 f4 sample 5 2 *id(2).name *id(2).mark These means that under id(2) and id(5) have same

[sqlite] excel vba use sqlite

I don't know how to use sqlite in EXCEL vba? Need I install sqlite connect driver? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] About database structure

I don't know how to create this table: There 4 objects: Aa, bb,cc, res Aa is name of a1,a2,a3,a4,a5 type Bb is name of b1,b2,b3,b4,b5 type Cc is only 1,0 type Res is result value If a1 and b1 and cc=1,then the value is 10; If a1 and b1 and cc=0,then the value is 5; If a2 and b1 and cc=1,then

[sqlite] sqlite login password

I want to know how to setting a loging sqlite passwd? When I input: Sqlite mtdb Command, the console will prompt like this: Pls input your password: ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] use sqlite3 in ios

When I add sqlite3.c and sqlite3.h to xcode ios cocoa project, and compiled, the error msg is: Sqlite3 class is not a objective class, who have any cocoa sqlite source, I don't know how to do. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to use sqlite in COCOA

Who can tell me how to use Sqlite in COCOA in my MAC system? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] de...@ukr.net

Hi, Sorry, I use mysql, not in sqlite, in mysql ,I run this command, the console show this error: do you know why? Thank you very much! mysql> UPDATE adlbk20140520a -> SET pflopf = ( -> SELECT pflopf -> FROM adl -> WHERE adl.ref = adlbk20140520a.ref) -> WHERE ( ->

[sqlite] how to write this commands?

update adla1 set PFLOPF=(SELECT pflopf from adl where adla1.ref=adl.ref) where select count(adl.ref) from adl=1; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] about merge rows

I have a sqlite table like this: id namemnote 7 DDD_POSTE_DE_COND 2;AA35469850.1;DDD;ECRHEMBNETM6X100AC8Z;000

[sqlite] if possible point another table

I have a table named aa like this: id pid namenotetablename 1 0 s12 bbc k1 2 1 sss vac k2 another table named k1: id pid namenote 11 1 f2 aaa 12 1 fs bbc another table named k2: id

[sqlite] how to use sqlite in excel vba?

I wanna use sqlite in EXCEL vba, but I don't know how to compile the sqlite ocx file in vc6. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] anyone know how to use ta-lib api to the sqlite database?

the ta-lib.org, the ta-lib library could use in EXCEL, I wanna use it in the sqlite database, but I don't know how to write the c or c++ code to load the ta-lib api in sqlite database, anyone know it? ___ sqlite-users mailing list

[sqlite] use sqlite to count macd value

DIFF : EMA(CLOSE,12) - EMA(CLOSE,26); DEA  : EMA(DIFF,9); MACD : 2*(DIFF-DEA); I wanna use sqlite to count macd value, have any idea? thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] use sqlite to count macd value

DIFF : EMA(CLOSE,SHORT) - EMA(CLOSE,LONG); DEA  : EMA(DIFF,M); MACD : 2*(DIFF-DEA), COLORSTICK; I wanna use sqlite to count macd value, have any idea? thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] search string in the db question

my table has a table like this: c5 c6 c7 9806062380 9806062380 9806062380 9806062480 9806062680 9806062680 9806063280 9806068980 9806068980 9806062980 9806067980 9806067980 9806062280 9806067880 9806067880 9806734080 9806068280

[sqlite] update to limits infomation

I hava a table like this: id,name,score,rank 1,anna,80,0 2,qera,65,0 6,kero,90,0 10,rosa,95,0 what I would like to do is to update the rank position. I have this, update mytable set rank= 1 where max(score); update mytable set rank= 2 where max(score-1) ; the result should be like

[sqlite] about delete problem

create table mytable( ID integer primary key autoincrement, name nvarchar(32) ); insert into mytable(name) values("aa1"); insert into mytable(name) values("aa2"); insert into mytable(name) values("aa3"); insert into mytable(name) values("aa4"); insert into mytable(name) values("aa5"); insert into

[sqlite] update value from another tow tables

updat table1 set name=selet name from table2 where table2.id=table1.id; this command couldn't work, how to update this status? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] what diffrent with this two sql command?

SELECT c FROM mytable AS m1 WHERE NOT EXISTS (SELECT b FROM mytable AS m2 WHERE m2.b = m1.c); SELECT c FROM mytable WHERE NOT EXISTS (SELECT b FROM mytable WHERE b = c); Sincerely, Cordialement / Best Regards / Mit freundlichen Grüßen / Cordiali saluti !

[sqlite] get diffrent column C from table

b c 854809 868763 854808 854809 854980 854808 854974 854980 854973 854974 854780 854973 854778 854780 854769 854778 854768 854769 854738 854768 854691 854738 854690 854691 853709 854690 856707 853709 856697 856707 856695 856697 927681 856695 927696 927681 927695 927696

Re: [sqlite] sqlite-users Digest, Vol 59, Issue 28

b c 897313 897313 854809 868763 854808 854809 854980 854808 854974 854980 854973 854974 854780 854973 854778 854780 854769 854778 854768 854769 854738 854768 854691 854738 854690 854691 853709 854690 856707 853709 856697 856707 856695 856697 927681 856695 927696

[sqlite] about date question

sqlite> select strftime(importdate) from t93c_adl3 limit 5; 2012-9-13 2012-9-5 2012-10-9 2012-10-9 2012-10-9 sqlite> select strftime('%y-%m-%d',importdate) from t93c_adl3 limit 5;

[sqlite] about date question

The result let crazy. sqlite> select distinct importdate from t93c_adl3 order by importdate desc limit 12; 2012-9-7 2012-9-6 2012-9-5 2012-9-4 2012-9-3 2012-9-29 //---here , why? 2012-9-28 2012-9-27 2012-9-26 2012-9-25 2012-9-24 2012-9-20 sqlite>

[sqlite] about date question

sqlite> select fmn,DATE('NOW'),supplierDate,date('now'),strftime(supplierDate),s trftime(supplierDate)-date('now') from t93c_adl where strftime(supplierDate) why use supplierDate,date('now'),strftime(supplierDate) the result is not same result format? the one is 2012-11-09 another is 12/01/2012

[sqlite] how to use julianday function

sqlite> select fmn,DATE('NOW'),supplierDate,julianday('now'),julianday(supplierDate),julianday('supplierDate') from t93c_adl where supplierDate>julianday('now') limit 5 ; 854954|2012-11-09|12/01/2012|2456240.61186149|| 854952|2012-11-09|03/01/2013|2456240.61186149||

Re: [sqlite] couldn't use is null function

sqlite> SELECT fmn,IMPLANTATIONgrading FROM T93C_ADL WHERE IMPLANTATIONgrading i s not null and fmn like '85495%'; 854954|R 854952| //-here is NULL, but I don't know why it shows in the not null

Re: [sqlite] sqlite-users Digest, Vol 59, Issue 7

ers@sqlite.org> Subject: Re: [sqlite] FW: about date question Message-ID: <cang6ahschcfgybcfsyuf_btdfmry+g9k4auxrsnyni-4yr8...@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 On 7 November 2012 09:42, YAN HONG YE <yanhong...@mpsa.com> wrote: > the table had

[sqlite] FW: about date question

the table had a column: SupplierDate Date I wanna add 84 days : SELECT SupplierDate+84 as date1 FROM ADL; BUT result have noting when use: select date(supplierdate+'2 day') from t93c_adl limit 3; the result is: -4713-12-08 -4713-11-29 -4713-12-01 ___

[sqlite] about date question

the table had a column: SupplierDate Date I wanna add 84 days : SELECT SupplierDate+84 as date1 FROM ADL; BUT result have noting ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] couldn't use is null function

SELECT * FROM ADL WHERE Project_grading is null; can't select anything. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite on Nokia symbian

I wanna use sqlite on my Nokia C7 symbian, but I don't know how to compile sqlite c api or sqlite source on the QT symbian. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] FW: how to select " char in sqlite

char bh1[320]; memset(bh1,0,320); strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select id,partnumber,substr(\'\',1,180) as img,pcs from engine where id>7;\" >> n.html"); system(bh1); //here couldn't work error: sqlite3 -html -header t9_engine.db "select

[sqlite] FW: how to select " char in sqlite

char bh1[320]; memset(bh1,0,320); strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select id,partnumber,substr(\'\',1,180) as img,pcs from engine where id>7;\" >> n.html"); system(bh1); //here couldn't work error: sqlite3 -html -header t9_engine.db "select

Re: [sqlite] how to select " char in sqlite

char bh1[320]; memset(bh1,0,320); strcpy(bh1,"sqlite3 -html -header t9_engine.db \"select id,partnumber,substr(\'\',1,180) as img,pcs from engine where id>7;\" >> n.html"); system(bh1); //here couldn't work ___ sqlite-users

[sqlite] FW: how to select " char in sqlite

sqlite3 -html -header t9_engine.db "select id,partnumber,\"abc.jpg\" as img,pcs from engine where id>7;" >> n.html here \"abc.jpg\" couldn't work. sqlite3 -html -header t9_engine.db "select id,partnumber,'' as img,pcs from engine where id>7; ">> n.html Same problem.

[sqlite] how to select "

sqlite3 -html -header t9_engine.db "select id,partnumber,\"abc.jpg\" as img,pcs from engine where id>7;" >> n.html here \"abc.jpg\" couldn't work. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] insert if in SQL cmd

I need a function to run step 2 in sql cmd, but I don't know how to write in the sql environment. 1. BEGIN TRANSACTION; 2. if today is mondy to fridy,then run 3-6 ELSE run 6. 3. prepare and step stmt A (SELECT * FROM foo WHERE rowid=1), A is not finalized or reset; 4. execute stmt B (DELETE

Re: [sqlite] how to write sql cmd for this situation

"Igor Tandetnik" <itandet...@mvps.org> reply: YAN HONG YE <yanhong...@mpsa.com> wrote: > mysql sql cmd is: > > select tb2.bb,tb2.cc,(max(tb1.mdate)-min(tb1.mdate)) as mmd,(mmd. > max(tb1.mdate).cc-mmd. min(tb1.mdate).cc) as mmc from tb1,tb2 > where tb2.bb

[sqlite] how to write sql cmd for this situation:

I have a 2 table: 1. tb1: aa bb cc mdate 1 d1 2.5 2012-08-07 2 d2 3.3 2012-08-07 3 d1 6.4 2012-08-09 2. tb2: aa bb cc 1. d1 5.3 2. d2 7.6 mysql sql cmd is: select tb2.bb,tb2.cc,(max(tb1.mdate)-min(tb1.mdate)) as mmd,(mmd. max(tb1.mdate).cc-mmd. min(tb1.mdate).cc) as mmc from

[sqlite] export html error

C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img src= t'||pic||'height=120px',pcs from engine where id>7 " >> n.html Error: near "&": syntax error ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] select ... where problem

Message: 25 Date: Thu, 20 Sep 2012 07:44:00 -0600 From: "Keith Medcalf" To: "General Discussion of SQLite Database" Subject: Re: [sqlite] select ... where problem Message-ID: Content-Type:

[sqlite] problem about output html in c++

sqlite3 -html -header t9_engine.db "select id,partnumber,pic,pcs from engine where id>7;" >> mm.html the pic result is "c:\abc.jpg"... but I wanna the result is "" how to do? maybe use sqlite3_step, but I don't know how to realize. thank you! ___

[sqlite] how to re_update the id item

my database have a column named id auto_increament inter primary key, when I delete any rows , the id item may be indiscriminate , how to update it and reorder the column from 1 to max(id) order by id asc? ___ sqlite-users mailing list

[sqlite] about sqlite3_create_function

who give me a sample about function sqlite3_create_function,I can't search by google. thank you! sqlite3_create_function(db, "hello_newman", 0, SQLITE_UTF8, 0, hello_newman, 0, 0); ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] update moving avg value

select round(((select avg(close) from test2 b where b.tkid between a.tkid-12 and a.tkid) - (select avg(close) from test2 b where b.tkid between a.tkid-26 and a.tkid)),2) from test2 a could be select the result,but when update use this sql script: update test2 set diff =(select round(((select

[sqlite] datetime question

create table test( Date datetime); insert test now(); select date+2 as bbb,date-12 as cc from test; the result is 2014,2000 I wanna know how to add any day use sql command ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to update the Moving average value

select dexin, code,new, (select avg(new) from tb1 where dexin between dexin-3 and dexin)as mavg from tb1; the result is only one value, and table only one: tb1 I don't know why have tbl b and tbl a >From: "Keith Medcalf" >To: "General Discussion of SQLite Database"

[sqlite] insert two select count(*) problem

The sqlcmd is: insert into mydb (co1,co2) select count(*) from db1 where db1.sco1>80 ,select count(*) from db2 where db2.sco2>90; It doesn't work. If one column, it can do,but when many column count(*), I don't know how to write the sql command. ___

Re: [sqlite] sqlite-users Digest, Vol 56, Issue 5

I wanna insert into a value to my sqlte db: insert into mydb (number1) select count(number1) from db2 where number1>80; but it doesn't work ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] query function release problem

You could download the origin zip source file by the link: www.yycred.com/sqlte_crypto1.zip when I use command " jii select ccc" it shows a problem: "jii.exe has encountered a problem and needs to close. We are sorry for the inconvenience." I couldn't resolve it. void query_table(sqlite3

Re: [sqlite] sqlite3_stat problem (YAN HONG YE)

sqlite3_bind_text(stat,1,uu2,140,NULL); change to sqlite3_bind_blob(stat,1,uu2,140,NULL); it's ok! thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_stat problem

sprintf(sql,"insert into student select 1,?,22;"); sqlite3_prepare(l_db,sql,-1,,0); char *uu1="bb"; char *uu2="Öйú"; HINSTANCE mod; Connect foo; mod

[sqlite] no such function problem

I write a function in my program: char *ldll(char *s1) { return s1; } and use it to modify my sqlite db: sprintf(sql,"insert into student select 3,ldll('bb'),22;"); but the error msg is "no such function: ldll" ___ sqlite-users mailing list

[sqlite] read sql script file

in the shell.c source file ,have a function .read file, and I wanna use it to my c++ code, when I hava a sql script file,such as : create table test (id integer primary key, value text); insert into test (id, value) values(1, 'eenie'); insert into test (id, value) values(2, 'meenie'); insert

[sqlite] how to write this sql command?

INSERT INTO myTable (Rd, en, ue) VALUES ("aa","bb",select ue from othertable); ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: datatype mismatch (Yanhong Ye)

I know the reason: if I change the file encode to latin, it will suecess import the data; but when I change the txt file to utf8 encode, It will get the error: Error: datatype mismatch I wanna know how to import utf8 encode file to my database? >Date: Mon, 16 Jul 2012 02:19:12 -0600 >From:

[sqlite] Error: datatype mismatch

the table is: CREATE TABLE webinfo (inx INTEGER PRIMARY KEY ,website varchar(50) UNIQUE,userna me varchar(50),password varchar(50)); and the txt file kk.txt is utf8: 0,nytime,gf,a1..7 1,bbc,1982,tbth432 2,oknic,y...@sohu.com,bbaa1122 when I use " .import kk.txt webinfo" in cmd line I got the

[sqlite] cann't work

two same structure tables, when use this sql: insert into table2 values(select * from table1 where filename like "%55"); but show error: sqlite error 1 - near "select": syntax error ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] group by z HAVING count(z>12.5)=2

If I wanna to know how much z>12.5 result in the database,could I use this following cmd? SELECT * from TableA WHERE z in ( SELECT z FROM TableA GROUP BY z HAVING count(z>12.5)=2 ); ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] order by clause should come after union not before

select * from hbc order by cmc desc limit 10 union select * from hbc where qph>0 union select * from hbc where hctl=1 this sql cmd cause the error: order by clause should come after union not before ___ sqlite-users mailing list

[sqlite] rekey

hello, when I use sqlite3_key to crypt my sqlite database "my.db" and the key is "abc", and when I use sqlitespy to open the database, then sqlitespy require me to input the key, when I input "abc" to it,but show me couldn't open the database, I don't know why, these following function is the

[sqlite] how to show image

sqlite3_exec(db,"create table image (filename varchar(128) unique,img blob);",0,0,); and put image to my sqlite db: sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); I export the html use this command: sqlite3 -html film.db "select * from image;">my.html but I

[sqlite] how to show sqlite db image in html

sqlite3_exec(db,"create table image (filename varchar(128) unique,img blob);",0,0,); and put image to my sqlite db: sqlite3_prepare(db,"insert into image values('.jpg',?);",-1,,0); the problem is: how to show my image in the web? sqlite3 -html film.db "select * from film;">my.html is

[sqlite] Query runs in SQLite Database Browser but not in iPad app

I have a sqlite db file in my pc, and now I wanna to copy my db file to my ipad. I need open db files in ipad,but I don't know how to open the file. and where should I copy my db files to my ipad. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] copy table to another db file

I have two db files: sqlite3 *db1; sqlite3 *db2; rc1 = sqlite3_open("myfile1", ); rc2 = sqlite3_open("myfile2", ); I want to copy db1.table1 to db2 file, but I don't know how to do? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to write "\n\r" each line in the output txt file?

>when I use : > >.output akk.txt >select * from dhq where qph>0; >.output stdout > > command to write a txt file,I found no "\n\r" in the each line, when I use ultraedit to open the txt file, I found end of each line is 0x0D, How to write "0x0D 0x0A" each line? may be should change the

[sqlite] how to write line feed "\n\r" when output a txt file

when I use : .output akk.txt select * from dhq where qph>0; .output stdout command to write a txt file,I found no "\n\r" in the each line , how to write "\n\r" each line in the output txt file? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] run sql file

I have a database {TABLE t( num integer, date text );} file, and a bbb.sql file content: INSERT INTO "t" VALUES(1,'1/1/2011'); INSERT INTO "t" VALUES(2,'1/1/2011'); INSERT INTO "t" VALUES(2,'2/1/2011'); INSERT INTO "t" VALUES(3,'1/1/2011'); INSERT INTO "t" VALUES(3,'2/1/2011'); INSERT INTO "t"

Re: [sqlite] sqlite-users Digest, Vol 53, Issue 9

On Wed, 9 May 2012 02:24:58 +0100 Simon Slavin wrote: > alter table myref add stkcode varchar(30); > update myref set stkcode = dzhhq.stkcode; > > this sql command couldn't run in my sqlite. It does not know which row from the table dzhhq it is meant to use. Simon. I

[sqlite] two table update question

alter table myref add stkcode varchar(30); update myref set stkcode = dzhhq.stkcode; this sql command couldn't run in my sqlite. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] inner join problem

update dzhhq set mnote= case when mnote in (select mnote from dzhhq inner join (select bs,stkcode from buysell) b on dzhhq.stkcode=b.stkcode) then 'sell'||mnote else mnote end is ok, but when I use this cmd then appear error msg: update dzhhq set mnote= case when mnote in (select mnote from

[sqlite] how much "case...when..." command?

UPDATE bb SET Slevel = CASE price1>12 WHEN 1 THEN 1 ELSE 0 END + CASE price1>30 WHEN 1 THEN 1 ELSE 0 END + CASE price2>20 WHEN 1 THEN 1 ELSE 0 END + CASE price2>30 WHEN 1 THEN 1 ELSE 0 END + case... csse... ... CASE price2>80 WHEN 1 THEN 1 ELSE 0 END; in this command, I don't

[sqlite] globe variable convert to sql

int iwk is a globe variable,sql command is: update mydb set ml= case iwk>5 and score>80 when 1 then 1 else 0 end; but command run failed,the reason is iwk varible not a sql variable, how can I convert globe variable to sql variable? ___

[sqlite] Select time('now')

the current time is 15:15 when I use this following command: sqlite> Select time('now'); return 07:15:42 not current time,why? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite gui app

hello, I wana show my sqlite database in wxwidgets gui library,but I don't know how to do this. could you tell me any resource about this? thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] two tables question

update dzhhq set dzhhq.mlevel= case dzhhq.stkname=myref.stkname when 1 then 88 else 0 end; show error: Query Error: near ".": syntax error Unable to execute statement ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to update value of string

my sqlite database "db" have a column remarks text default "2012", I want to add string "high" to the string of remark as "2012high" when the score >80 and add string "middle" to the string of remark as "2012middle" when the score>60 and score <80 update the db.remarks value

[sqlite] sqlite3_transaction trans(db); can't work in c, I don't know why?

sqlite_transaction trans(db); sqlite3_prepare(db,"insert into image values('.rar',?);",-1,,0); sqlite3_bind_blob(stat,1,ffile,filesize,NULL); sqlite3_step(stat); free(ffile); sqlite3_finalize(stat); trans.commit(); ___ sqlite-users mailing list

[sqlite] sqlite3_transaction can't work

sqlite3_transaction trans(db); can't work in c, I don't know why? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] about The open-source Fossil version control system

Date: Tue, 03 Apr 2012 20:56:15 +0200 Kees Nuyt wrote: >The open-source Fossil version control system >used by SQLite contains an implementation of system() that correctly deals >with UTF8 even on windows systems. Perhaps the OP can copy some of

[sqlite] how to use c binding and write output in c

Date: Mon, 2 Apr 2012 00:37:18 -0400 From: Richard Hipp <d...@sqlite.org> wrote: On Sun, Apr 1, 2012 at 11:21 PM, Roy Tam <roy...@gmail.com> wrote: > 2012/4/2 YAN HONG YE <yanhong...@mpsa.com>: > > when I run this following code , the html file encoding changed to

Re: [sqlite] sqlite-users Digest, Vol 52, Issue 1

when I run this following code , the html file encoding changed to GB2312,not utf-8, I don't know why? system("echo ^ >mm.html"); system("sqlite3 -html -header foods.db \"select * from dzh where qph15>10;\" >>mm.html"); system("echo ^ >>mm.html");

[sqlite] how to wrie "" char in my html file?

>sqlite3 -html C:\mydatabase\mydzh.db "select ''">mm.html this command result is not in the mm.html file, it's this following text: table not I wanted, how to wrie char in my html file? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] about sqlite3_exec function

sqlite3_exec( db, "???", 0, 0, ); I wanna add this following command into sqlite3_exec func: "sqlite3 -html -header mydzh.db \"select * from dhq where ph15>10;\" >mm.html" like this: sqlite3_exec( db, "-html -header \"select * from dhq where ph15>10;\" >mm.html", 0, 0, ); but it doesn't work

[sqlite] put jpg into sqlite database

this following code is my import girl.jpg to my sqlite database, but I don't know why JPG didn't up to the bin.db. #include #include #include #include"sqlite3.h" #pragma comment(lib, "sqlite3.lib") sqlite3 * db; sqlite3_stmt *stat; int main(int argc, char **argv) { char *zErrMsg=0; FILE

[sqlite] how to merge this three command in c++

This follow 3 commands,I wanna merge to c++,but don't know how to do: sqlite3 my.db " select '' " > my.html sqlite3 -html -header my.db " select * from BOD " >> my.html sqlite3 my.db " select '' " >> my.html is this follow right? char bbb[300]; strcpy(bbb,"BEGIN\n " select '' " > my.html\n \

[sqlite] how to add time in a new column

sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; Error: Cannot add a column with non-constant default ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to built xml file from sqlite database?

how to built xml file from sqlite database? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] .headers error

C:\sqlite\lib>sqlite3 -html foods.db "select * from dzh;" >mm.html "-headers on" sqlite3: Error: too many options: "-headers on" Use -help for a list of options. how to write this command? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] HOW TO EXPORT TABLE HEAD

WHEN I export sqlite database to a html file or txt file, I couldn't know how to include the database table head. who can tell me? Thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to export to html file with table

Date: Mon, 26 Mar 2012 08:22:56 +0200 From: Steinar Midtskogen to export to the html file command is: sqlite3 -html film.db "select * from film" > mm.html but the result had no table,only a text file without line feed, how to export the html with tables and table

[sqlite] how to export to html file?

my sqlite database want to export to html file, I know the command sqlite3 -html film.db "select * from film;" could show the table in cmd window, but how to export to the html file like sqlite3 -html film.db mm.html "select * from film;" Thank you!

[sqlite] how to get sql result?

I want to get the virable char myresult[200]= select name where id>20 from mytable ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] decimal function not found

my sqlite sql sentens is : "select '88', Convert(decimal(5,1),AVG(qph))" but build the project in c shows the error: Error: no such function: decimal how to process this problem? ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] how to show sqlite database in vc6 listctrl control?

I have a sqlite database, and wish to create a gui application to show the database use vc6 listctrl control, I don't know how to write c++ cource, anyone could tell me the source in the codeproject web or any other website have the resource about this topic? thank you!

[sqlite] ABOUT IMPORT TXT FILE TO SQLITE

On Date: Wed, 14 Mar 2012 23:13:57 -0400 From: Kevin Benson wrote: Quick solution to above error may be to try path with forward slashes: C:\sqlite\lib>".separator ',' \n .import /sqlite/lib/ddl.txt dzh \n" | sqlite3 /sqlite/lib/foods.db and 8.3 path format where

[sqlite] import a text to sqlite

On Tue, 13 Mar 2012 02:28:38 +, YAN HONG YE <yanhong...@mpsa.com> wrote: >here my code,where is wrong? >char mma[250]; >strcpy(mma,"sqlite3 foods.db \" .separator ',' \" \".import dzhhkmysql.txt >dzh\""); >system(mma); dot-commands for t

[sqlite] where wrong

C:\sqlite\lib>sqlite3 foods.db ".separator ',' " ".import dzhhkmysql.txt dzh" sqlite3: Error: too many options: ".import dzhhkmysql.txt dzh" Use -help for a list of options. ___ sqlite-users mailing list sqlite-users@sqlite.org

  1   2   >