Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Terry:
My show on Saturday night went well, and I met some celebs.
"> Not bad, but my policy is to use only my own stuff."
"Yes I know that but who's to know? The more gags the merrier."
I would know.
The Brighton Comedy Festival sounds like a good idea. I have to see if I can get time off from my day job (software engineer), though.
BTW, I am having a similar problem to the one that started this post. I have set a relation between two tables (one to many), but the relation doesn't seem to work until I browse the parent table. However, since I need the data to appear on pages in a pageframe, I don't want to browse the table. Any ideas? My code is:
SELECT Child
SET ORDER TO ChildIndex
SET RELATION TO KeyField2 INTO GrandChild, KeyField3 INTO GrandChild2
SELECT Parent
SET RELATION TO KeyField INTO Child
SET SKIP TO Child
SET ORDER TO ParentIndex
SEEK ThisForm.KeyValue IN Parent
I have other relations going on that I didn't list, but they don't involve the relation between Parent and Child, which is where I'm having the problem.
Jerry
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