🚀 go-pugleaf

 I have the following code in C++ builder 6:

 q->CommandText =  "INSERT INTO Locks (LockType, Expiration, Username, Data, 
ExclusiveLock) ";
 q->CommandText += "VALUES (:LockType, :Expiration, :Username, :Data, 
:ExclusiveLock)";
 q->Parameters->ParamByName("LockType")->Value = LockText[type];
 ...

when the third line is executed, I get an error saying that the parameter 
"LockType" does not exist. If, however, I combind the first two lines into a 
single line...

q->CommandText =  "INSERT INTO Locks (LockType, Expiration, Username, Data, 
ExclusiveLock) VALUES (:LockType, :Expiration, :Username, :Data, 
:ExclusiveLock)";

everything works fine. I have made sure CommandType = cmdText, and even 
called Parameters->ParseSQL. I still get the same error. Looking at the 
examples in the BCB6 documentation, I think I am doing what they do there, 
but there appears to be a problem using the '+=' operator with 
CommandText...

Any ideas how I can fix this without having to combine all my long SQL 
statements into long C++ lines?

Thanks,

John F. Lund