On Sun, 5 Feb 2006, Dan wrote:
> I am using lates Lazarus version (0.9.11) and this insert statement run OK. > You can try set "Dataset.ParseSQL := False;" before any Dataset.ExecSQL or > Dataset.Open Nevertheless it is a bug. There should be no parsing inside string constants in the SQL statement. Alexander Todorov, Can you please submit this in the FPC (not Lazarus) bugtracker, so it won't be forgotten ? Michael. > > ----- Original Message ----- From: "Alexander Todorov" > <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Sunday, February 05, 2006 8:23 PM > Subject: [lazarus] SQLdb bug > > > > Good evening, > > I am using SQLdb 1.0 / Lazarus 0.9.8 / FPC 2.0.1 on Windows XP with > > Firebird 1.5 database. > > When a statement like > > INSERT INTO TEST (ID, DATAFIELD) VALUES (1, 'this :is a :test') is > > executed i get an error. > > The problem is that values after the colon ':' characters are parsed > > as parameters. In my particular case FSQLQuery.Params.Count was 2. > > > > Should I create a test project and report it, or it is solved with > > newer version ? > > Can anyone confirm that with other database servers? > > > > _________________________________________________________________ > > To unsubscribe: mail [EMAIL PROTECTED] with > > "unsubscribe" as the Subject > > archives at http://www.lazarus.freepascal.org/mailarchives > > _________________________________________________________________ > To unsubscribe: mail [EMAIL PROTECTED] with > "unsubscribe" as the Subject > archives at http://www.lazarus.freepascal.org/mailarchives > _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
