Re: [lazarus] parameterized queries

2006-08-24 Thread Adrian Maier
On 23/08/06, Zlatko Matić [EMAIL PROTECTED] wrote: Can you give me the download link for fpc-2.0.4-rc3 ? Thanks. I think that's it : ftp://ftp.freepascal.org/fpc/beta/2.0.4-rc3/ Are the 2.0.4 release candidates not really visible on purpose? I could not find no references on the

Re: [lazarus] parameterized queries

2006-08-24 Thread Vincent Snijders
Adrian Maier wrote: On 23/08/06, Zlatko Matić [EMAIL PROTECTED] wrote: Can you give me the download link for fpc-2.0.4-rc3 ? Thanks. I think that's it : ftp://ftp.freepascal.org/fpc/beta/2.0.4-rc3/ Are the 2.0.4 release candidates not really visible on purpose? I could not find no

Re: [lazarus] parameterized queries

2006-08-24 Thread Adrian Maier
On 24/08/06, Vincent Snijders [EMAIL PROTECTED] wrote: They were announce of the fpc mailing lists and people were invited to test them. Further more the Lazarus snapshots were modified to use the release candidates too. This has been announce on this mailing too. Not all possibly interested

Re: [lazarus] parameterized queries

2006-08-24 Thread Adrian Maier
On 24/08/06, Joost van der Sluis [EMAIL PROTECTED] wrote: On Thu, 2006-08-24 at 11:45 +0300, Adrian Maier wrote: On 24/08/06, Vincent Snijders [EMAIL PROTECTED] wrote: It is not interesting for the developers, if people just use the release candidate. They are looking for people to really

Re: [lazarus] parameterized queries

2006-08-24 Thread Vincent Snijders
Adrian Maier wrote: On 24/08/06, Joost van der Sluis [EMAIL PROTECTED] wrote: Then you should better use the snapshots. There are now already fixes in the 2.1.1 snapshot for postgres, which won't make it in 2.0.4. The rc's were only meant to test the installation-procedures on all

Re: [lazarus] parameterized queries

2006-08-23 Thread Zlatko Matić
Can you give me the download link for fpc-2.0.4-rc3 ? Thanks. - Original Message - From: Joost van der Sluis [EMAIL PROTECTED] To: lazarus@miraclec.com Sent: Tuesday, August 22, 2006 7:25 PM Subject: Re: [lazarus] parameterized queries Try fpc-2.0.4(rc3) On Tue, 2006-08-22 at 18:57

Re: [lazarus] parameterized queries

2006-08-22 Thread Zlatko Matić
? - Original Message - From: Zlatko Matić To: lazarus@miraclec.com Sent: Sunday, August 20, 2006 2:24 PM Subject: [lazarus] parameterized queries Hello. I just tried to put some parameterized query on a form and pass the parameter's value through

Re: [lazarus] parameterized queries

2006-08-22 Thread Joost van der Sluis
] To: lazarus@miraclec.com Sent: Monday, August 21, 2006 10:53 PM Subject: Re: [lazarus] parameterized queries Look in the examples in fcl/db/sqldb/examples (You have to set the value of the parameterer before you can make it active) On Mon, 2006-08-21 at 18:16 +0200, Zlatko Matić

Re: [lazarus] parameterized queries

2006-08-22 Thread Zlatko Matic
@miraclec.com Sent: Tuesday, August 22, 2006 9:35 PM Subject: Re: [lazarus] parameterized queries 2006/8/22, Zlatko Matic [EMAIL PROTECTED]: What is wrong with passing parameters through ParamByName, such as: SQLQuery1.Params.ParamByName('parameter').AsString:='blah, blah' ? There is nothing wrong: I

Re: [lazarus] parameterized queries

2006-08-21 Thread Zlatko Matić
Is there any articleexplaining how to useparameterized queries in TSQLQuery ? - Original Message - From: Zlatko Matić To: lazarus@miraclec.com Sent: Sunday, August 20, 2006 2:24 PM Subject: [lazarus] parameterized queries Hello. I just tried to put

Re: [lazarus] parameterized queries

2006-08-21 Thread Alexandre Leclerc
Simply use the StringReplace() function to replace you parameter with the desired value. Personally, I used the Format function... Format('select * from %s where %s', ['table','a=b']); Best regards. -- Alexandre Leclerc _ To

Re: [lazarus] parameterized queries

2006-08-21 Thread Joost van der Sluis
- From: Zlatko Matić To: lazarus@miraclec.com Sent: Sunday, August 20, 2006 2:24 PM Subject: [lazarus] parameterized queries Hello. I just tried to put some parameterized query on a form and pass

Re: [lazarus] parameterized queries

2006-08-21 Thread Joost van der Sluis
On Mon, 2006-08-21 at 12:59 -0400, Alexandre Leclerc wrote: Simply use the StringReplace() function to replace you parameter with the desired value. Personally, I used the Format function... Format('select * from %s where %s', ['table','a=b']); And what if the string %s is : ' table; drop

[lazarus] parameterized queries

2006-08-20 Thread Zlatko Matić
Hello. I just tried to put some parameterized query on a form and pass the parameter's value through code. The query is the following: select distinct sampling_types.sampling_type, plants.plant, plants.departmentfrom ((sampling_types join batches_microbs on