Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 3 - Insert into ????
Message
De
08/09/1998 22:44:18
Larry Long
ProgRes (Programming Resources)
Georgie, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00133920
Message ID:
00134310
Vues:
24
>Does anybody know how to check to see if an insert into from memvar actually worked?
>
>I have a system that seems to not be storing the all of the records properly.
>
>i.3. ifthere were 10 to insert, it might only insert 6...
> i.e. 1-4 in 5,6 out7 in 8,out, 9 in 10 out...
>
>
>I create a cursor to store the jobs to print. I scan through this cursor and place the records into the main table using insert into...
>
>Right after this, I print a report, based on the cursor.... (all of the records are there as they all show up in the report.) However, some of them don't get added to my table.
>
>
>Any ideas,
>
>Mike
You might try checking the reccount() after each insert, perhaps something like..

select yourtable
=flock()
store reccount() to m.records

insert into yourtable from memvar

*force reading of current table header
=rlock()
unlock

if reccount()<=m.records
wait window 'Insert was not successfull'
endif
L.A.Long
ProgRes
lalong1@charter.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform