Get Warning Messages

[John Bell]

How do I retrieve any warning messages (not errors)? Am trying to detect if a temporary table exists. Thanks.

[ViktorV]

To resolve the issue, you can use the following code:

Code: Select all

 MyQuery1.Sql.Text := 'SET sql_notes = 1; 
  CREATE TEMPORARY TABLE IF NOT EXISTS TEST (C CHAR(20)); 
  SHOW WARNINGS;';
MyQuery1.Open;
ShowMessage(MyQuery1.FieldByName('Message').AsString);