Re: [lazarus] sqlite dataset in thread

2007-01-17 Thread Luiz Americo Pereira Camara
[EMAIL PROTECTED] wrote: thanks Luiz. It resolved your problem? Luiz _ To unsubscribe: mail [EMAIL PROTECTED] with unsubscribe as the Subject archives at http://www.lazarus.freepascal.org/mailarchives

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread Luiz Americo Pereira Camara
[EMAIL PROTECTED] wrote: Hi, I'm working on open source project with lazarus. it is not ready for release. I have problem with sqlite3 in thread. if i want to create like that, thread locked and not working. mydataset := TSqlite3Dataset.Create(Nil); Do you have any idea for using? Can you

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread [EMAIL PROTECTED]
Hi if i want to use this strings tablo.ExecSQL( 'select type_name from servers where id='+ inttostr( record_id) ); type_name:= tablo.FieldByName('type_name').AsString; it is giving error. can i access to sqlite multiple? Best Regards M.Ali VARDAR procedure TMyThread.Execute; var ping:

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread Al Boldi
Does your program work without threads? If it does, make sure you call TThread.Synchronize(SyncMethod) when necessary. Thanks! -- Al [EMAIL PROTECTED] wrote: Hi if i want to use this strings tablo.ExecSQL( 'select type_name from servers where id='+ inttostr( record_id) ); type_name:=

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread Luiz Americo Pereira Camara
[EMAIL PROTECTED] wrote: Hi if i want to use this strings tablo.ExecSQL( 'select type_name from servers where id='+ inttostr( record_id) ); type_name:= tablo.FieldByName('type_name').AsString; it is giving error. can i access to sqlite multiple? Best Regards M.Ali VARDAR procedure

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread [EMAIL PROTECTED]
Thank you guys, I guess i found my problem. Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread Luiz Americo Pereira Camara
[EMAIL PROTECTED] wrote: Thank you guys, I guess i found my problem. Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.

Re: [lazarus] sqlite dataset in thread

2007-01-16 Thread ali
thanks Luiz. [EMAIL PROTECTED] wrote: Thank you guys, I guess i found my problem. Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in

[lazarus] sqlite dataset in thread

2007-01-15 Thread ali
Hi, I'm working on open source project with lazarus. it is not ready for release. I have problem with sqlite3 in thread. if i want to create like that, thread locked and not working. mydataset := TSqlite3Dataset.Create(Nil); Do you have any idea for using? Best Regards M.Ali VARDAR