Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto Refresh Key fields after insert with CA
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Auto Refresh Key fields after insert with CA
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01100805
Message ID:
01100805
Vues:
70
Am I missing something?
I have a table with AutoInc field in it setted as Key field in my CA. I waht after I insert record in that Cursor that firld to be refresed automaticly. So I set :
this.InsertCmdRefreshKeyFieldList = [Id] && Name of the field
this.InsertCmdRefreshCmd          = []   && Empty string
                                         && according to HELP - The CA object generates the refresh command automatically.

** Cursor has Table buffering. Now after I insert a record in CA
IF NOT TableUpdate(1, .t., [MyTable])
  ** Error handling here
ENDIF
Also with SQL Profiler I didn't see any command relative to some refresh :-)

BUT the field ID is always empty. Am I missing something (I am sure I am but what)?
TIA
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform