Re: [sqlite] Transaction Check
Hi, If the sqlite file is deleted at runtime and if there are any open connections,can these connections detect and return error? Pls suggest. regards ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! * - Original Message - From: [EMAIL PROTECTED] Date: Saturday, July 28, 2007 6:20 pm Subject: Re: [sqlite] Transaction Check > RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Is there any api which tell us if a transaction is already > started or not? > > > > sqlite3_get_autocommit() > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction Check
am not sure of select but it may be costly sql_exec("begin",...); regrads ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! * - Original Message - From: Dr Gerard Hammond <[EMAIL PROTECTED]> Date: Sunday, July 29, 2007 8:10 am Subject: Re: [sqlite] Transaction Check > Cool. Is there a way to ask the engine this? > Some SELECT call? > > At 12:50 PM + 28/7/07, [EMAIL PROTECTED] wrote: > >RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > >> Hi, > >> > >> Is there any api which tell us if a transaction is already > started or not? > >> > > > >sqlite3_get_autocommit() > > > > > -- > > Cheers, > > Dr Gerard Hammond > MacSOS Solutions Pty Ltd > [EMAIL PROTECTED] http://www.macsos.com.au > > Proofread carefully to see if you any words out. > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction Check
Cool. Is there a way to ask the engine this? Some SELECT call? At 12:50 PM + 28/7/07, [EMAIL PROTECTED] wrote: RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: Hi, Is there any api which tell us if a transaction is already started or not? sqlite3_get_autocommit() -- Cheers, Dr Gerard Hammond MacSOS Solutions Pty Ltd [EMAIL PROTECTED] http://www.macsos.com.au Proofread carefully to see if you any words out. - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] Static library cross-compile
Thanks Joe. I modified my file to use '--strip-unneeded' aswell as putting '-O2 -DTHREADSAFE=1 -DNDEBUG' into my compile line. I have the static library down to 679.7k (and still linking in my application) but from what I have read on some of the other forum posts it should be possible to reduce the file to less than half of this even still. Is there anything else I am missing? Thanks. -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Friday, 27 July 2007 1:27 p.m. To: sqlite-users@sqlite.org Subject: RE: [sqlite] Static library cross-compile Try using "strip -g" instead of "strip". Alternatively, you could try --strip-unneeded --- Chris Brown <[EMAIL PROTECTED]> wrote: > I seem to have resolved the problem below linking to the static > library by removing the STRIP command for the static library from the makefile. > > The problem I now have is that the library is 1.1 MB which is > approximately twice the size of what the library was before. This is > an embedded application so space is at a premium. Can anyone offer a > suggestion to reduce the size of the static library without > implementing the STRIP which seems to prevent me from statically linking? My current configure is: Sick sense of humor? Visit Yahoo! TV's Comedy with an Edge to see what's on, when. http://tv.yahoo.com/collections/222 - To unsubscribe, send email to [EMAIL PROTECTED] - __ NOD32 2424 (20070726) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction Check
Thank you. ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! * - Original Message - From: [EMAIL PROTECTED] Date: Saturday, July 28, 2007 6:20 pm Subject: Re: [sqlite] Transaction Check > RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Is there any api which tell us if a transaction is already > started or not? > > > > sqlite3_get_autocommit() > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Transaction Check
RaghavendraK 70574 <[EMAIL PROTECTED]> wrote: > Hi, > > Is there any api which tell us if a transaction is already started or not? > sqlite3_get_autocommit() -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] how do i generate a uniqueidentifier ?
"Trevor Talbot" <[EMAIL PROTECTED]> wrote: > Hm, something ate the last part of my message... > > > Note that SQLite contains a decent PRNG which is well seeded, > > if you are running on Mac or Linux. (We need to work on better > > seeding on Win32...) > > The crypto framework on recent versions of Windows can be used to get > a good quality seed. I'm not sure it's worth trying to do better on > older versions. It's something that can be done dynamically, much > like the Unicode filename stuff. > I don't do windows. Can you send suggested patches to the sqlite3WinRandomSeed() function in os_win.c that access the crypto framework on versions of windows that support such a thing? The patches will need to fall back to using some other universal seeding mechanism on systems that lack the crypto framework. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Transaction Check
Hi, Is there any api which tell us if a transaction is already started or not? regards ragha ** This email and its attachments contain confidential information from HUAWEI, which is intended only for the person or entity whose address is listed above. Any use of the information contained herein in any way (including, but not limited to, total or partial disclosure, reproduction, or dissemination) by persons other than the intended recipient(s) is prohibited. If you receive this e-mail in error, please notify the sender by phone or email immediately and delete it! * - To unsubscribe, send email to [EMAIL PROTECTED] -