Re: [sqlite] reg:BOLB data

Thank you very much Snyder. - Original Message - From: "Gerry Snyder" <[EMAIL PROTECTED]> To: Sent: Wednesday, September 13, 2006 6:56 PM Subject: Re: [sqlite] reg:BOLB data > sandhya wrote: > > Hi, > > I created a table with fileds filename and the value of type text and BLOB > > res

Re: [sqlite] to retreive OID

abiramip wrote: > Hi, > In the command prompt if i give the following, > select OID from tablename; > am able to get the corresponding OID... > If i use sqlite3_prepare() APIhow do i proceed inorder to do the same ? > > Please suggest a procedure to perform this. Look at this page: http:/

[sqlite] to retreive OID

Hi, In the command prompt if i give the following, select OID from tablename; am able to get the corresponding OID... If i use sqlite3_prepare() APIhow do i proceed inorder to do the same ? Please suggest a procedure to perform this. Thanks in advance . Regards, abirami p

[sqlite] Error: database is locked on _all_ sqlite tables

I'm having a strange problem since earlier today where all sqlite tables on my shared webserver seem to be locked. I have a trac installation using sqlite that started giving me "database is locked" errors earlier today and continues to do so. This is not an intermittent problem -- since it bega

[sqlite] null pointer problem

I am running version 3.3.6 compiled with Visual Studio .net 2003 in a single threaded app. While using sqlite3_exec to execute a "COMMIT;", in run into a null pointer problem in sqlite3_step. I added tests for the null pointer to vdbeapi.c: if (NULL == p) { DebugBreak(); }

[sqlite] legacy_file_format

With sqlite version 3.3.7 if I create a new database using: if (sqlite3_open("/var/tmp/solarwave/aem.db", &db)!=0) { printf("Cannot open db\n"); return(false); } and then issue the following: snprintf(query, QUERY_SIZE, "%s", "PRAGMA legacy_file_format = ON");

Re: [sqlite] met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

Sarah wrote: I'm facing new problems right now. the record cann't be inserted correctly when I execute the following statements. .. char * database = ":memory:"; sqlite3 * db; sqlite3_open(database, &db); sqlite3_exec(db, "create table myt(name varchar(30),age smallint)", NULL, NULL, N

Re: [sqlite] Retrieving data

Richard Stern wrote: Hi all. I'm using sqlite in VC++ 2005. When I started this I knew nothing about sqlite or indeed SQL at all so its been tough going trying to work out how this all works. So far I have created a database and a table and added columns and rows filled with data. But I'm havin

[sqlite] Re: to retrieve OID

abiramip <[EMAIL PROTECTED]> wrote: In the command prompt if i give the following, select OID from tablename; am able to get the corresponding OID... Is it possible to do the same by using APIs? Sure. You use the API to run the query "select OID from tablename;", just as you would any other qu

[sqlite] Re: Retrieving data

Richard Stern <[EMAIL PROTECTED]> wrote: Lets say I have the columns MemberNo, Name and Address. I want to use a specific MemberNo to retrieve a name and address and store them in separate variables. I tried: sqlite3_exec(AccDataBase,"SELECT Name,Address FROM Accounts WHERE MemberNo = 2;",Callba

Re: [sqlite] to retrieve OID

abiramip wrote: In the command prompt if i give the following, select OID from tablename; am able to get the corresponding OID... Is it possible to do the same by using APIs?If so which API can i use inorder to retreive OID from a table. Can i use sqlite3_get_table() or sqlite3_prepare() APIs

Re: RE: [sqlite] Retrieving data

Hi Richard >> You don't need a Callback-Function in any case. Try it >> without > I'm confused. > How does the SELECT command return any data? In what > form would it give you this data back? There doesn't seem to > be a pointer to pass by reference and no out variables. The Prepare-Command

Re: [sqlite] Very wide tables and performance

Hi Dennis, This is an OLAP product and indeed we don't know upfront how much of that data is relevant to the processing. I had a normalized group of tables for those sets but it took an awfull time to load and to process. In practice the wider tables are usually 25,000 columns per 50 to 100 rows

RE: [sqlite] Retrieving data

> > I tried: > > sqlite3_exec(AccDataBase,"SELECT Name,Address FROM Accounts WHERE > MemberNo = > > 2;",Callback(cError,10,&result,&Names),test,&cDatabaseError); > > You don't need a Callback-Function in any case. Try it > without I'm confused. How does the SELECT command return any data? I

Re: [sqlite] met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

Hi, When you ported sqlite to your os-less ARM based platform, did you do any other changes to the sqlite source code? I'm facing new problems right now. the record cann't be inserted correctly when I execute the following statements. .. char * database = ":memory:"; sqlite3 * db; sqli

[sqlite] to retrieve OID

Hi, In the command prompt if i give the following, select OID from tablename; am able to get the corresponding OID... Is it possible to do the same by using APIs?If so which API can i use inorder to retreive OID from a table. Can i use sqlite3_get_table() or sqlite3_prepare() APIs? Or is ther

RE: [sqlite] Very wide tables and performance

Hi Jose! It is really hard to believe that you do not have a sparse matrix. I mean that for every single row: from 2 colums only a several columns are used and others are nil. This is a point to perform so-called normalizations for the table. The single exception what I remember is OLAP databa

Re: [sqlite] met "ARM7TDMI raised an exception,data abort" when executing sqlite3Parser() in ARM environment

I've got the reason. That is because some stupid mistake I've made. During the execution of sqlite3Parser(), realloc() is called. Because here SQLite is running in an embedded environment without OS, so I need to wrap realloc() of my platform. I just wrapped malloc() and free(), but forgot this