Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2014-12

SQL Editor produces wrong string constant

1 message · 1 person ·

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

John Landmesser

Hi,

Lazarus 1.3 r47221 FPC 2.6.4 x86_64-linux-gtk 2

example SQL-Editor:

SELECT Datum, Zeit FROM Daten
WHERE Datum > '01.01.2014'

After create String constant:
SQL = 'SELECT Datum, Zeit FROM Daten'+LineEnding+
'WHERE Datum > ''01.01.2014''';

This statement will not be executed!
Before and after +LineEnding+ is missing a blank: ' ' +LineEnding+ ' '

simple to fix!!

Reply by email