Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT INTO ...FROM ARRAY malfunctioning
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
INSERT INTO ...FROM ARRAY malfunctioning
Divers
Thread ID:
00559933
Message ID:
00559933
Vues:
58
Folks,
I am running VFP6 and W2K, both with the latest service packs. After installing SP2 on W2K (but I am not sure that is the problem) I noticed that the following code was failing to behave correctly.
  DIMENSION ThisForm.F50record(77)
  COPY TO ARRAY ThisForm.F50record NEXT 1
  INSERT INTO HISTORY\hstf50 FROM ARRAY ThisForm.F50record
Both the F50.dbf and HstF50.dbf are identical. This code has been in place and functioning properly for nearly three years. The symptom is that one field near the end of the row of the HstF50 table is missing data present in that row in the F50 table and, two fields down the row, part of data from the wrong field is in another field. (Note that this code used to be in an "WITH ...ENDWITH" construct, but I have added 'ThisForm' to see what happens.

Any clues?
JLK
Nebraska Dept of Revenue
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform