Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Help with GATHER and AutoInc fields?
Need some guidance here... I am trying to copy the data in one record to a new record in the same table, then change the JobNo field to some new Job umber that I already have and validated as unique.
The problem is that the table has an AutoInc field named "ipkey", and VFP does not want to let me do a GATHER for obvious reasons.
So, I understand why it has this limitation because of autoinc, I just want to know how one works around it.
Presently, to get around it, I am doing a REPLACE command on every field except ipkey, but I was hoping to use the SCATTER NAME / GATHER NAME method to avoid having to list out every field, and so I would have code that is independent of the field names.
Here's what I wanted to use:
Select 0
Use Jobs order jobno
... navigate to the desired record ..
SCATTER NAME loCurrentJob
Append Blank
Gather NAME loCurrentJob
replace JobNo with lcNewJobNo && a passed in value, already validated
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