Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Refresh Key fields after insert with CA
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Auto Refresh Key fields after insert with CA
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01100805
Message ID:
01100805
Views:
72
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.
Next
Reply
Map
View

Click here to load this message in the networking platform