Information générale
Titre:
Does not save indexes.
Hi,
I encountered one major problem wich tourn me upside-down ( stupid problem ):
1. I have one database named 'general' and 2 tables in it named 'funct' and 'personal' wich have a common field named 'name'
2. field 'name' in 'funct' is primary key
3. table 'personal' is indexed on field 'name'
4. one relation One-to-Many is estabilised on that field and integrity rule of Restrict on Update, Delete, Insert.
5. I have one screen in wich update table 'personal' where field 'name' is completed with values from 'funct'
6. Saves in 'personal' are made with no errors in both append new record and modify record
7. Problem is: when I modify record replacing field 'name' with other value from 'funct' save are made fine BUT indexes are NOT updated. More explicitly when I browse table 'personal' with order set to 'name' record wich was modified earlier apear in old position of value in field 'name' but with new value in it. WHAT IT'S HAPENING??!!
With that problem evrithing goes wrong!
PS This problem didn't apear in Fox2.6; I refuze to belive that version VFP5.0 is made such stupid mistakes.
Thanks
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