Thanks for the replies.
My first assumption was that it was a memory issue. It seems that this is only a problem with an UPDATE command, we do not have the same problem when using the INSERT command with the same number of columns. Will the UPDATE command require more memory to execute? My embedded platform is as follows:- Processor: Sharp ARM7 LH79520 Memory: 2Mb - SRAM cypress Our stack size is:- 0x7800 bytes (approx 30k) Our heap size is:- 0x1C6000 bytes (approx 1.7Mb) The code is compiled using the IAR EWARM complier. Thanks again. > -----Original Message----- > From: Christian Smith [mailto:[EMAIL PROTECTED] > Sent: 27 July 2005 17:35 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] UPDATE - crash when many columns > > > On Wed, 27 Jul 2005, Mark Allan wrote: > > > > >Hi, > > > >I am using the SQL command:- > > > >UPDATE PATIENTS SET > FIRSTNAME=?,SURNAME=?,SEX=?,WEIGHT=?,HEIGHT=?,FACTOR=?,DYSPNOE > A_SCORE=?,SMOKING_STATUS=?,OCCUPATION=?,REFERRED_BY=? WHERE > PATIENT_ID = '296' > > > >or similar, where the values for the ?'s are all binded via the > >appropriate sqlite3_bind_* C functions. > > > >Now this will run fine when SQLite and our application is > compiled and > >run on Windows, but when the same code is run on our target > harware it > >will crash immediately at sqlite3_prepare(). > > > >If I update a smaller number of columns (maximum seems to be > 6) then it > >runs without any problems, but increase this and it will crash. > > > How big is your stack and heap? You may be running out of memory when > parsing the SQL statement. It may help if you stated what > your embedded > platform is. > > > > > >I cannot determine why this happens. Has anybody had the same or a > >similar problem? Can anyone help me or help me confirm what > the actual > >problem may be? > > > >Thanks in advance for any help > > > >Mark > > > > -- > /"\ > \ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL > X - AGAINST MS ATTACHMENTS > / \ >
