Re: [sqlite] Re: Re: Merging two tables

2007-09-08 Thread RaghavendraK 70574
Hi, In sqlite3_create_function, xFunc func pointer signature does not allow to have a return value.Any other possible way achieving it apart from collation? regards ragha ** This email and its attachments

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Joe Wilson
--- Scott Hess <[EMAIL PROTECTED]> wrote: > - for newly-created files, create them during the transaction. If > the transaction rolls back, delete the file. If the transaction > commits, leave them alone. > > - for deleted files, leave them in place. If the transaction > commits, delete the

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Joe Wilson
--- Yves Goergen <[EMAIL PROTECTED]> wrote: > On 08.09.2007 21:06 CE(S)T, Joe Wilson wrote: > > Are you able to store this file in the database itself as a BLOB? > > No, its an input file that I'm processing and saving the results in the > database. When processing and database import are

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Trevor Talbot
On 9/7/07, Yves Goergen <[EMAIL PROTECTED]> wrote: > I'm currently using a transaction for this on the database side and > rolling it back if the file cannot be deleted. But what if the file is > gone and then SQLite says it doesn't accept my records? Since we're > inside a transaction, integrity

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Scott Hess
In general, you have to do something like: - for newly-created files, create them during the transaction. If the transaction rolls back, delete the file. If the transaction commits, leave them alone. - for deleted files, leave them in place. If the transaction commits, delete the files. If

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Yves Goergen
On 08.09.2007 21:06 CE(S)T, Joe Wilson wrote: > Are you able to store this file in the database itself as a BLOB? No, its an input file that I'm processing and saving the results in the database. When processing and database import are successful, the file must be deleted so that it won't be

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Dwight Ingersoll
On 9/7/07, Yves Goergen <[EMAIL PROTECTED]> wrote: > > Hi, > > in a scenario when multiple operations need to be transactionally > synchronised, I have a file that must be deleted when the database > records are added successfully, but the database operations must be > rolled back, if the file

Re: [sqlite] Can I simulate a COMMIT?

2007-09-08 Thread Joe Wilson
--- Yves Goergen <[EMAIL PROTECTED]> wrote: > in a scenario when multiple operations need to be transactionally > synchronised, I have a file that must be deleted when the database > records are added successfully, but the database operations must be > rolled back, if the file cannot be deleted. >

Re: [sqlite] HELP! DDD & SQLite

2007-09-08 Thread Uma Krishnan
Hello Ken, I just realized that sqlite3 is a bash program. When I do ddd sqlite3, it gives an error. So when I need to load a program, thru GUI interface I load main.o. But I guess that's not right What should I do? Thanks Uma Ken <[EMAIL PROTECTED]> wrote: you

Re: [sqlite] HELP! DDD & SQLite

2007-09-08 Thread Ken
you need to set a breakpoint. hit the continue button in DDD. That will allow execution of the code and allow the attached program to continue. It would be better however to run ddd as follows: ddd sqlite3 Then set a breakpoint. Then run the program inside the ddd that way you can first set