Subject SQL.Add(StrList) - How do you add a quoted string to a query
Author Craig Cox
I am try to add a string list to FB 2.5 blob field using a query within a Delphi application. My code works great, unless the string list contains a quoted string. How do I get around this?

Example String list:

[TatukGIS Layer]
Area.Color=$80FF
Area.OutlineColor=$10101
Area.OutlineWidth=20
Area.ShowLegend=YES
Area.SmartSize=16
Label.Field=MAP_SYMBOL
Label.OutlineWidth=2
Label.SmartSize=16
Legend=Pennsylvanian - Glenshaw Formation
Query=MAP_SYMBOL= 'Pcg'
Visible=YES

My code looks like this:

qry.SQL.Clear;
qry.SQL.Add('UPDATE');
qry.SQL.Add('GIS_CONFIG');
qry.SQL.Add('SET');
qry.SQL.Add('GIS_CONFIG.GIS_CONFIG=+''''+strList.Text+'''');
qry.SQL.Add('Where');
qry.SQL.Add('(');
qry.SQL.Add(UserPKBig);
qry.SQL.Add(')');
qry.Open;
qry.Close;

Thanks