----- Original Message -----
Sent: Wednesday, August 28, 2002 10:18
AM
Subject: [DUG]: weird behavour with
Format
I have struck some weird behaviour:
We use "Format" to format SQL Strings - this
usually works (has so far, used three times) ...
The following code will not work if contained
inside the "with" statement - and it is only setting a local variable
!!!
I can't see or understand why ?
I have the same constructs in other parts of my
code - all working fine
- I have checked the TIBQueries,
they are identical apart from SQLString, SQLParameters, and
Name.
- I even copied 1 across and used it - same
result!
This should not affect the assigning of a local
variable ...
I am avoiding the "with" (it all works) but I
would love to know why and if anyone else has come across this ?
procedure MyProcedure ...
const
csString = 'This is an
example string '
+
'this %s
string '
+
'is
a test';
var
TestString: String;
ResultString:
String;
begin
TestString := 'Blah
Blah Blah;
with qryMyQuery do
begin
ResultString := Format(csString, [TestString]); // Inserts ''
end;
ResultString := Format(csString, [TestString]); //
Inserts 'Blah Blah Blah'
end;
Regards
Paul McKenzie
Analyst
Programmer
SMSS Ltd.