On Wed, 18 Oct 2006, Terry A Haimann wrote:
> I noticed that now on the mysql connection component there is a
> DeleteSQL, UpdateSQL and InsertSQL varibles of TStrings. How do I use
> them? I am running Lazarus 0.0.18 beta on a FC4 machine.
Just enter something like
Update MyTable
Set
MyField = :MyField,
MyOtherField = :MyOtherField
where
MyKeyField = :OLD_MyKeyField;
or
Delete from MyTable Where MyKeyField=:MyKeyField;
and so on.
The parameters (identifiers starting with : ) will be replaced with the
new field values, the parameter name must match the field name.
Any parameters starting with OLD_ will be replaced with the old
field value.
Michael.
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
