[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 ( - SELECT

[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

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

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

] 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 a column: SupplierDate Date I wanna add 84 days : SELECT

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

: CANG6AhQU9J5rOo3h-WouE0Gr=nutj2sdnxnoyf31oo+356m...@mail.gmail.com Content-Type: text/plain; charset=ISO-8859-1 On 7 November 2012 08:27, YAN HONG YE yanhong...@mpsa.com wrote: SELECT * FROM ADL WHERE Project_grading is null; can't select anything. sqlite create table ADL( id integer primary key, data

[sqlite] how to use julianday function

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

[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)dat e('now') limit 10; 854954|2012-11-09|12/01/2012|2012-11-09|12/01/2012|-2000 854952|2012-11-09|03/01/2013|2012-11-09|03/01/2013|-2009

[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] 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] 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] 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(\'img src=\\'||pic||\'\ height=220/\',1,180) as img,pcs from engine where id7;\ n.html); system(bh1); //here couldn't work error: sqlite3 -html -header

[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(\'img src=\\'||pic||\'\ height=220/\',1,180) as img,pcs from engine where id7;\ n.html); system(bh1); //here couldn't work error: sqlite3 -html -header

[sqlite] how to select

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

[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 id7; n.html here \abc.jpg\ couldn't work. sqlite3 -html -header t9_engine.db select id,partnumber,'img src=\ '||pic||' \ height=220/' as img,pcs from engine where id7; n.html

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(\'img src=\\'||pic||\'\ height=220/\',1,180) as img,pcs from engine where id7;\ n.html); system(bh1); //here couldn't work

[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 in (select bb from tb1 where bb group by 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:\t9sqlite3 -html -header t9_engine.db select id,partnumber,'lt;img src=quo t'||pic||quot;'height=120pxgt;',pcs from engine where id7 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 kmedc...@dessus.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Subject: Re: [sqlite] select ... where problem Message-ID: dccc8dcdf36303448ae1d39bb3070...@mail.dessus.com Content-Type: text/plain;

[sqlite] problem about output html in c++

sqlite3 -html -header t9_engine.db select id,partnumber,pic,pcs from engine where id7; mm.html the pic result is c:\abc.jpg... but I wanna the result is img src=\ c:\abc.jpg \ width=120px 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] 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

[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

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 kmedc...@dessus.com 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.sco180 ,select count(*) from db2 where db2.sco290; 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 number180; but it doesn't work ___ sqlite-users mailing list sqlite-users@sqlite.org

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] 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

[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] sqlite3_stat problem

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

[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

[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 error

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: Keith

[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(z12.5)=2

If I wanna to know how much z12.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(z12.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 qph0 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 sqlite db image in html

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

[sqlite] how to show image

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

[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, db1); rc2 = sqlite3_open(myfile2, db2); 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 qph0; .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 sqlite3.c or

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

when I use : .output akk.txt select * from dhq where qph0; .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 slav...@bigfraud.org 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 means:

[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 price112 WHEN 1 THEN 1 ELSE 0 END + CASE price130 WHEN 1 THEN 1 ELSE 0 END + CASE price220 WHEN 1 THEN 1 ELSE 0 END + CASE price230 WHEN 1 THEN 1 ELSE 0 END + case... csse... ... CASE price280 WHEN 1 THEN 1 ELSE 0 END; in this command, I don't know

[sqlite] globe variable convert to sql

int iwk is a globe variable,sql command is: update mydb set ml= case iwk5 and score80 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-users

[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] 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 score60 and score 80 update the db.remarks value strcat(remark,high) where

[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] 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] 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,stat,0); sqlite3_bind_blob(stat,1,ffile,filesize,NULL); sqlite3_step(stat); free(ffile); sqlite3_finalize(stat); trans.commit(); ___ sqlite-users mailing

[sqlite] about The open-source Fossil http://www.fossil-scm.org/ version control system

Date: Tue, 03 Apr 2012 20:56:15 +0200 Kees Nuyt k.n...@zonnet.nl wrote: The open-source Fossil http://www.fossil-scm.org/ 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 the code

[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 GB2312,not utf-8, I don't know why

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 ^table border='1'^ mm.html); system(sqlite3 -html -header foods.db \select * from dzh where qph1510;\ mm.html); system(echo ^/table^ mm.html);

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

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

[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 string.h #includestdio.h #includestdlib.h #includesqlite3.h #pragma comment(lib, sqlite3.lib) sqlite3 * db; sqlite3_stmt *stat; int main(int argc, char **argv) { char

[sqlite] about sqlite3_exec function

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

[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 'table' my.html sqlite3 -html -header my.db select * from BOD my.html sqlite3 my.db select '/table' my.html is this follow right? char bbb[300]; strcpy(bbb,BEGIN\n select 'table' my.html\n \

[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] 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 export to html file with table

Date: Mon, 26 Mar 2012 08:22:56 +0200 From: Steinar Midtskogen stei...@latinitas.org 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 column

[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] .headers error

C:\sqlite\libsqlite3 -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 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 id20 from mytable ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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] 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] ABOUT IMPORT TXT FILE TO SQLITE

On Date: Wed, 14 Mar 2012 23:13:57 -0400 From: Kevin Benson kevin.m.ben...@gmail.com 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 needed:

[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 the sqlite3 command line tool have to be on separate lines. Do

[sqlite] import txt file to sqlite

I wanna import a text file to sqlite db, this follow code is right? char *zErrMsg = 0; sqlite3 *db; rc=sqlite3_open(foods.db,db); sqlite3_exec(db, CREATE TABLE contact (fliename varchar(128) UNIQUE, fzip blob, ntest int, ntest1 int);, 0, 0, zErrMsg);

[sqlite] import a text to sqlite

here my code,where is wrong? char mma[250]; strcpy(mma,sqlite3 foods.db \ .separator ',' \ \.import dzhhkmysql.txt dzh\); system(mma); ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] where wrong

C:\sqlite\libsqlite3 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

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

For a table named bb: I have a sqlite database named bb: NamePrice1Price2Slevel A123 231 NULL A22212 NULL A3 21223 NULL UPDATE bb SET Slevel = CASE price112 WHEN 1 THEN 1 ELSE 0 END +

  1   2   >