Check if an adoquery field exists

Comments

• Anu de Deus Hampshire, UK

  January 2011 edited January 2011

  try using the ADOQuery2.GetFieldNames procedure and analise the results.
  
  They are part of TDataset and implemented in the frx editor, should be fine, take a look at the Classes tab in the right side of the frx editor, plenty of good stuff there.
• stol

  January 2011 edited 9:24PM

  Anu de Deus wrote: »

  try using the ADOQuery2.GetFieldNames procedure and analise the results.
  
  They are part of TDataset and implemented in the frx editor, should be fine, take a look at the Classes tab in the right side of the frx editor, plenty of good stuff there.
• stol

  January 2011 edited 9:24PM

  I tried that showmessage(adoquery2.GetFieldNames); but didn't work. The message Undeclared Idendifier : 'GetFieldNames' appeared. Am I doing something wrong?
• Anu de Deus Hampshire, UK

  January 2011 edited 9:24PM

  yes, you are.
  As I said, look at the tab, there is the function declaration there, with its required parameters
• stol

  January 2011 edited 9:24PM

  Sorry but I can't find the solution. I found the procedure GetFieldNames(List: TStrings) but I don't know how to use it. What should I write in the parenthesis? Can you send me an example? Thanks.
• gpi

  January 2011 edited 9:24PM

  var List: TStringList;           
  begin
       ADOQuery1.Open;              
       List := TStringList.Create;                                                                                 
       ADOQuery1.GetFieldList(List);
       if List.IndexOf('Company') <> -1 then ShowMessage('Company field exists');
       List.Free;                           
  end.
  
• stol

  January 2011 edited 9:24PM

  It works!!! Thank you very much.