Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto Refresh Key fields after insert with CA
Message
From
02/03/2006 10:02:56
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01100805
Message ID:
01100875
Views:
11
Hi!

Try this in your CA's Init.
This.InsertCmdRefreshCmd = "select " + This.InsertCmdRefreshKeyFieldList + " from " + This.Tables + " where " + This.InsertCmdRefreshKeyFieldList + " = GetAutoIncValue() "
Sarosh

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform