Mysql change query problem

Comments

• classic12

  April 2012 edited 5:41PM

  Bump. Any ideas on this anyone ?
  

  classic12 wrote: »

  I am new to Fast reports so may be doing something dumb here.
  
  I have the following:
  Mysql component with SLQ = 'SELECT *
  FROM customer a
  INNER JOIN coresspondense b
  ON a.Cust_Num = b.Cust_Num
  INNER JOIN contacts c
  ON a.Cust_Num = c.Cust_Num
  WHERE b.Item = 1
  a report'
  
  a frxDBDataset pointing to the above data
  
  
  Within a report I goto Report-data and add the dataset.
  
  All the fields show correctly.
  
  However when I change the query to
  
  SELECT a.Cust_Num,b.Notes,c.Surname
  FROM customer a
  INNER JOIN coresspondense b
  ON a.Cust_Num = b.Cust_Num
  INNER JOIN contacts c
  ON a.Cust_Num = c.Cust_Num
  WHERE b.Item = 1 AND c.Inc = 2
  
  I still see the old query fields and not the new ones.
  
  Is this a bug or do I need to force a re-fresh somewhere?
  
  I have tried setting the active to false - true. Restarting the IDE.
  
  If I add a datafield from the incorrect list to the report and preview I get an exception error.
  
  
  Cheers
  
  SteveW
• technisoft

  April 2012 edited April 2012

  I don't know if this is of any help as I am not familiar with MySQL.
  You need to close and then reopen the query after the change.
  IMO it should automaticlly close anyway as soon as you make changes.
  Refresh on a Query usually only refreshes the row and not the the whole dataset. If the former is the case then the columns would change.
• classic12

  April 2012 edited 5:41PM

  I have done that and the columns do not change.
  
  I am sure this is a bug where do I report this ?
  
  Cheers
  
  
  steveW