Problem on a control Tag

Hi,

I've a problem on a refresh of a control tag.
I've a vbscript which is execute on a table modifier, I ve already a superfield for my companies which is execute before the table modifier. This superfield has a control tag ({TagBddNom{FilterKey1sF_Societe}}) is run well but when I change the FilterKey of my table modifier the vbscript isn't execute a second time.
What can I do to refresh all the time this script?

Regards,

/*VBSCRIPT*/

'oAlchemyControlTags.ConnectionPoolIndexSet 0,False

Dim adoCon
Dim rsFields

set adoCon = oConnection.ConnectionObject(CInt(ProductConIndex))
set rsFields = adoCon.Execute("SELECT E1.code AS AxeCode, E2.numero AS Numero, E3.code AS PlanCode, E3.Caption AS PlanLibelle FROM {TagBddNom{FilterKey1sF_Societe}}.TESPACEANALYTIQUE E1 LEFT OUTER JOIN {TagBddNom{FilterKey1sF_Societe}}.TCONSTITUTIONESPACE E2 ON E2.oidEspaceAnalytique = E1.oid LEFT OUTER JOIN {TagBddNom{FilterKey1sF_Societe}}.TDIMENSIONANALYTIQUE E3 ON E3.oid = E2.oidDimensionAnalytique WHERE E1.code = '{FilterKey1tM_Axe}' ")

Do Until rsFields.EOF
    If not isnull(rsFields.Fields("PlanCode").Value) THEN oAlchemyControlTags.Add "{FilterKey1sF_Societe}Axe{FilterKey1tM_Axe}CodePlan" + Cstr(rsFields.Fields("numero").Value), rsFields.Fields("PlanCode").Value
    If not isnull(rsFields.Fields("PlanLibelle").Value) THEN oAlchemyControlTags.Add "{FilterKey1sF_Societe}Axe{FilterKey1tM_Axe}LibellePlan" + Cstr(rsFields.Fields("numero").Value), rsFields.Fields("PlanLibelle").Value
    rsFields.MoveNext
Loop

GO

replaced message with typo's corrected ( hopefully )

Hi Baptiste
Superfield Control Tag Scripts are run whenever the Superfield is changed. Table Modifier scripts are run whenever the Table modifier is changed.
If you want to have tags that use information from both then the tags will have to be created within the Superfield script. This example is very simplistic but I hope its ok.
For example
Superfield sSuper has values A,B,C
Table Modifier tTM has values X,Y,Z
If you want a Control Tag that is going to be based on both - {Tag_{FilterKey1sSuper}_{FilterKey1tTM}} then all possible variations for a given Superfield will have to be created within the Superfield ControlTag Script.
Select '_{FilterKey1sSuper}_X},'abcdef'
GO
Select '_{FilterKey1sSuper}_Y},'abcdef'
GO
Select '_{FilterKey1sSuper}_Z},'abcdef'
GO

I hope this answers your question.
cheers
Richard

another solution may be to just includel the TableModifer script at the end of your superfield script id the Table Modifier Filter has been set up.