Mysql change query problem

classic12

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

classic12

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

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

I have done that and the columns do not change.

I am sure this is a bug where do I report this ?

Cheers


steveW