[sqlite] how to compile sqlite3 in ads1.2 environment?

2007-04-25 Thread allen . zhang
Dose anybody compile the sqlite3 in the ads1.2 environment?

[sqlite] lemon compile parse.y error for windows

2007-04-25 Thread allen . zhang
I compile the lemon.c in vc6 environment. (build it the win32 console application ) then I use the command lemon parse.y I successfully get the parse.h file but the file is not right. I only get 137 ids the follwing 15 ids do not exist in the parse.h TK_TO_TEXT TK_TO_BLOB TK_TO_NUMERIC

Re: [sqlite] how to compile sqlite3 in ads1.2 environment?

2007-04-25 Thread allen . zhang
arm developer suite v1.2 support arm7,arm9 Joe Wilson <[EMAIL PROTECTED]> 2007-04-26 11:03 Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] how to compile sqlite3 in ads1.2 environment? What's an ads1.2? --- [EMAIL PROTECTED] wrote: > D

[sqlite] porting sqlite3 to embeded os-----lock question

2007-05-08 Thread allen . zhang
I am porting sqlite3 to the embeded os,such as threadx,nucleus,ect.. I am writing the file such as os_threadx.c,os_nucleus.c according to the os_win.c,os_unix.c. I have read the os_win.c and find that there is a switcher OS_WINCE in the struct winFile. Is this mean the windows platform don't need

[sqlite] create table error

2007-05-10 Thread allen . zhang
the following is my test code. just create table. rc = sqlite3_open("zieckey.db", &db); char *sql = " CREATE TABLE SensorData(ID INTEGER PRIMARY KEY,SensorID INTEGER,SiteNum INTEGER,Time VARCHAR(12),SensorParameter REAL);" ; sqlite3_exec( db , sql , 0 , 0 , &zErrMsg ); sqlite3_close(db);

Re: [sqlite] porting sqlite3 to embeded os-----lock question

2007-05-14 Thread allen . zhang
thank you for your reply. I have make it run on our embeded os and make some simple tests. it runs ok. great!! "Nuno Lucas" <[EMAIL PROTECTED]> 2007-05-12 07:03 Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] porting sqlite3 to embeded os-l

Re: [sqlite] create table error

2007-05-14 Thread allen . zhang
close it. that is for my reason. the relloc memory error! "Mohd Radzi Ibrahim" <[EMAIL PROTECTED]> 2007-05-10 16:44 Please respond to sqlite-users@sqlite.org To cc Subject Re: [sqlite] create table error Could it be that the data where *sql is pointing to is being re-used somewhere?

[sqlite] realloc size smaller than malloc size?is it error in vc6?

2007-07-12 Thread Allen . Zhang
in the os_common.h file there are sqlite3GenericMalloc,sqlite3GenericRealloc,sqlite3GenericFree,sqlite3GenericAllocationSize function. If I run the sqlite in windows,the sqlite3GenericRealloc function just call the realloc function. from the msdn and my test,the realloc(void *p, n)function,the

Re: [sqlite] realloc size smaller than malloc size?is it error in vc6?

2007-07-12 Thread Allen . Zhang
it is my fault. I have read msdn again,copy the remarks The size argument gives the new size of the block, in bytes. The contents of the block are unchanged up to the shorter of the new and old sizes, although the new block can be in a different location. Because the new block can be in a new

[sqlite] How many table can i create in a db?

2007-07-20 Thread Allen . Zhang
I open one db,then create table. How many table can i create? 10,100? what is the max table num in one db? BR allen.zhang