Hi,
I noticed strange behaviour of the components - CCv5 and CFv5
It looks like it does not read updates of table structure.
Recently I started to implement new CFv5 form joining two tables together.
Unfotumately v5 of CF does not have explicit JOIN and you have to guess how built-in works.
I had structure which could be joined like:
SELECT * FROM parent
JOIN child on child.chParentId = parent.pId
So joining fields were named differently and I didn't discover how to set it up.
First q:
Is this posssible to set the relation and get joined tables in such a way in CFv5 ?
OK, I moved on and renamed the "chParentId" field for "pId"
So now my query looks like:
SELECT * FROM parent
JOIN child on child.pId = parent.pId
It was easy to set the JOIN.
Now JOIN started to work - I could see it in debugger but... I couldnt get the newly named field displayed with child.* expression and the query
still trying to get old chParentId field !
The same with CCv5 - I created connection with chParentId and now can't get the new pId field by default "all fields" settings"
I have to finger it with new name...
Second q:
Is there any "cache" of the DB structure in chrono components which holds old structures ?
I wonder if anyone met these "dinosaurs" at large ?
Regards
Henryk
I noticed strange behaviour of the components - CCv5 and CFv5
It looks like it does not read updates of table structure.
Recently I started to implement new CFv5 form joining two tables together.
Unfotumately v5 of CF does not have explicit JOIN and you have to guess how built-in works.
I had structure which could be joined like:
SELECT * FROM parent
JOIN child on child.chParentId = parent.pId
So joining fields were named differently and I didn't discover how to set it up.
First q:
Is this posssible to set the relation and get joined tables in such a way in CFv5 ?
OK, I moved on and renamed the "chParentId" field for "pId"
So now my query looks like:
SELECT * FROM parent
JOIN child on child.pId = parent.pId
It was easy to set the JOIN.
Now JOIN started to work - I could see it in debugger but... I couldnt get the newly named field displayed with child.* expression and the query
still trying to get old chParentId field !
The same with CCv5 - I created connection with chParentId and now can't get the new pId field by default "all fields" settings"
I have to finger it with new name...
Second q:
Is there any "cache" of the DB structure in chrono components which holds old structures ?
I wonder if anyone met these "dinosaurs" at large ?
Regards
Henryk