Re: [lazarus] SqlDB component madness

2007-12-14 Thread Joost van der Sluis
Op woensdag 12-12-2007 om 20:50 uur [tijdzone +0100], schreef Michael Van Canneyt: On Wed, 12 Dec 2007, Michael Van Canneyt wrote: On Wed, 12 Dec 2007, Graeme Geldenhuys wrote: On 12/12/2007, Michael Van Canneyt [EMAIL PROTECTED] wrote: If all works as I want it, this

[lazarus] SqlDB component madness

2007-12-12 Thread Graeme Geldenhuys
Hi, Please bare with me Lets get one thing out of the way. I never use DB Connection components on Forms and never use DB-aware components. I'm a OPF guy, so using the database components on a day-to-day basis is not something I am familiar with. So that said, I thought I would play with the

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Graeme Geldenhuys
On 12/12/2007, Swen Heinig [EMAIL PROTECTED] wrote: if you do step1 then step2 is automatically done (no additional work for you). There is the same situation for step4 and step3 (if you connect to the database the transaction is automatically set). To make sure I'm not going nuts I tried it

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Swen Heinig
Hello Graeme, if you do step1 then step2 is automatically done (no additional work for you). There is the same situation for step4 and step3 (if you connect to the database the transaction is automatically set). Step5b: You can connect the SQLQuery to a second Datasource. If you connect the

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Swen Heinig
Sorry, there was a misunderstanding from my side. If you do step2 then step1 is automatically done (thats the correct way). Swen Graeme Geldenhuys schrieb: On 12/12/2007, Swen Heinig [EMAIL PROTECTED] wrote: if you do step1 then step2 is automatically done (no additional work for you).

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Joost van der Sluis
Op woensdag 12-12-2007 om 15:11 uur [tijdzone +0200], schreef Graeme Geldenhuys: Step 1: == TIBConnection - TSQLTransaction via 'Database' property. No problem here. Step 2: == TIBConnection - TSQLTransaction via 'Transaction' property. Why??? Why must you link

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Graeme Geldenhuys
On 12/12/2007, Joost van der Sluis [EMAIL PROTECTED] wrote: Step 2: You don't need to do this. It is used when the TIBConnection tries to execute some sql-statements itself. If has to know which transaction it should use. You have to see this as the 'default transaction'. If you do

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Michael Van Canneyt
On Wed, 12 Dec 2007, Joost van der Sluis wrote: Op woensdag 12-12-2007 om 15:11 uur [tijdzone +0200], schreef Graeme Geldenhuys: Step 1: == TIBConnection - TSQLTransaction via 'Database' property. No problem here. Step 2: == TIBConnection - TSQLTransaction

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Michael Van Canneyt
On Wed, 12 Dec 2007, Graeme Geldenhuys wrote: On 12/12/2007, Joost van der Sluis [EMAIL PROTECTED] wrote: Step 2: You don't need to do this. It is used when the TIBConnection tries to execute some sql-statements itself. If has to know which transaction it should use. You have to see

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Graeme Geldenhuys
On 12/12/2007, Joost van der Sluis [EMAIL PROTECTED] wrote: Both counts? 5b Is optional? You said that yourself. Sorry, I got Step 4 and 5 mixed up. That's because you don't have any indexes pre-defined. So it tries to fetch the indexes from the database. At that point the TIBConnection

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Graeme Geldenhuys
On 12/12/2007, Michael Van Canneyt [EMAIL PROTECTED] wrote: If all works as I want it, this should be reduced to 4 steps for the default cases, That is what I expected and what I was used to in Delphi. I gather the change you are talking about would work from code as well, and not just some

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Michael Van Canneyt
On Wed, 12 Dec 2007, Graeme Geldenhuys wrote: On 12/12/2007, Michael Van Canneyt [EMAIL PROTECTED] wrote: If all works as I want it, this should be reduced to 4 steps for the default cases, That is what I expected and what I was used to in Delphi. I gather the change you are

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Michael Van Canneyt
On Wed, 12 Dec 2007, Michael Van Canneyt wrote: On Wed, 12 Dec 2007, Graeme Geldenhuys wrote: On 12/12/2007, Michael Van Canneyt [EMAIL PROTECTED] wrote: If all works as I want it, this should be reduced to 4 steps for the default cases, That is what I expected and

Re: [lazarus] SqlDB component madness

2007-12-12 Thread Graeme Geldenhuys
On 13/12/2007, John [EMAIL PROTECTED] wrote: I did put some stuff in the wiki: http://wiki.freepascal.org/SQLdb_Package. Perhaps that doesn't count. Certainly it could be improved. I'll have a look there thanks, but I was actually referring to the class documentation created by fpdoc. So when