Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View not updating data
Message
 
 
To
10/08/2006 00:04:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01143996
Message ID:
01144481
Views:
22
This message has been marked as the solution to the initial question of the thread.
Steven,

The Primary Key field is the field that can uniquely identify each record. Each table should have such field. It can be either integer (autoincrement) or character (GUID).



>"Are you sure you have a PK field? Is it unique? What is the field name and what index do you have in your table? Which table did you make updatable?"
>
>Naomi, Excuse my ignorance, what is a PK field? The table I make updatable is the PKG table
>
>I have incorporated your code in the afterrowcolchange of the grid as follows.
>No luck yet!
>
>
>if not tableupdate(.t.,.t.,'VUEpkg')
> local array laError[1]
> =aerror(laError)
> lcError = "Error # " + transform(laError[1]) + " " + laError[2]
> =messagebox(m.lcError)
>else && TableUpdate succeed
> flush in pkg
>ENDIF
>
>
>Regards,
>
>Steve
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform