Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>>I get a syntax error when attempting to set the filter for the child table in a grid on a 1 many form.
>>
>>thisform.dataenvironment.cursor2.filter = task.startdate = ld_date
>>
>>Does anyone see what could be wrong with the above line?
>
>Evan, first put your filter in quotes
>
>thisform.dataenvironment.cursor2.filter = "task.startdate = ld_date"
>
>Second, be sure that ld_date will be visible whereever you use the filter. (If you set it in a method, it may go out of focus.)
>
>Finally, try using the grid properties (LinkMaster, ChildOrder, etc.) to show the correct records instead of a filter.
>
Barbara,
Okay... 1 worked, 2 worked but I am puzzled about 3.
Linkmaster is akin to the old "set relation", and Childorder is similar to "set order" so I don't get how this will help me. (Which is perhaps not all that suprizing). :-)
Normally I would have used a parameterized view to quickly and simply restrict the records displayed in the child table but I am trying out Visual Promatrix which doesn't support views well. This is why I have tried using a filter. I have avoided filters up until this point.
If you have time, could you explain the method you mentioned above?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement