[lazarus] Re: Problems trying to use sqlite database

2005-10-15 Thread Felipe Monteiro de Carvalho
Felipe Monteiro de Carvalho wrote: So I downloaded the stable Lazarus 9.10 for Windows and guess what?? I works perfectly. The Active property appears! And with the exact same source as before now I can save my database modifications with ApplyUpdates. My current theory blames the beta FPC.

Re: [lazarus] Re: Problems trying to use sqlite database

2005-10-14 Thread Joost van der Sluis
On Thu, 2005-10-13 at 19:48 -0300, Felipe Monteiro de Carvalho wrote: Luiz Americo wrote: See the topic Applying changes to the underlying datafile in the database/sqlite section of the wiki. Thanks a lot ... I must have missed it ... but then the other databases I worked with (mysql,

[lazarus] Re: Problems trying to use sqlite database

2005-10-14 Thread Felipe Monteiro de Carvalho
Joost van der Sluis wrote: I call that: bad design. It's a more advanced feature, so that the programmer keeps control so he can maintain the integrity of the database. DBase is so old, that it doesn't care. Mysql can work this way, but you don't need to (same holds for sqlite, btw) and ADO is

Re: [lazarus] Re: Problems trying to use sqlite database

2005-10-13 Thread Joost van der Sluis
On Wed, 2005-10-12 at 19:09 -0300, Felipe Monteiro de Carvalho wrote: Luiz Americo wrote: This is the way TDataset works. If a record is not posted then it can be cancelled (maybe DBGrid is calling cancel in this case). A simple way to add a record is to do a procedure like: I'd like

[lazarus] Re: Problems trying to use sqlite database

2005-10-13 Thread Felipe Monteiro de Carvalho
Hello, I am putting my source code at www.braillevirtual.fe.usp.br/scripts with the name Database.tar so you guys can see what I am doing wrong if you have some free time. I think WinZip should be able to read tar files. If it cannot let me know. Joost van der Sluis wrote: By default, the

Re: [lazarus] Re: Problems trying to use sqlite database

2005-10-13 Thread Luiz Americo
Felipe Monteiro de Carvalho wrote: Hello, I am putting my source code at www.braillevirtual.fe.usp.br/scripts with the name Database.tar so you guys can see what I am doing wrong if you have some free time. I think WinZip should be able to read tar files. If it cannot let me know. Joost

[lazarus] Re: Problems trying to use sqlite database

2005-10-13 Thread Felipe Monteiro de Carvalho
Luiz Americo wrote: See the topic Applying changes to the underlying datafile in the database/sqlite section of the wiki. Thanks a lot ... I must have missed it ... but then the other databases I worked with (mysql, dbase and ADO) didn´t need this. One more thing. Do we really need to have

Re: [lazarus] Re: Problems trying to use sqlite database

2005-10-13 Thread Luiz Americo
Felipe Monteiro de Carvalho wrote: Luiz Americo wrote: See the topic Applying changes to the underlying datafile in the database/sqlite section of the wiki. Thanks a lot ... I must have missed it ... but then the other databases I worked with (mysql, dbase and ADO) didn´t need this. Are

Re: [lazarus] Re: Problems trying to use sqlite database

2005-10-12 Thread Luiz Americo
Felipe Monteiro de Carvalho wrote: Luiz Americo wrote: This is the way TDataset works. If a record is not posted then it can be cancelled (maybe DBGrid is calling cancel in this case). A simple way to add a record is to do a procedure like: ASlite.Append; ASqlite.Post; and associate with

[lazarus] Re: Problems trying to use sqlite database

2005-10-12 Thread Felipe Monteiro de Carvalho
Luiz Americo wrote: Right now i'm seeing it in the object inspector: is the first property. Using Lazarus svn + fpc 2.0.0 + WindowsXP Looking at the source code Active really exists and is published on TCustomSqliteDataset, so it should appear on the object inspector as far as I know. So I