General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How do I use an Autoindex field in a view - VFP8
I have a child table that has as its primary key and autoinc field.
I have a one-to-many field for linking to the parent.
I want to use the child table's key as the key field to update the child table on.
i.e. Update the view via sql update replacing key fields and modified ones.
I use the view.
I then append a blank record.
I then issue a tableupdate(.t.,.t.) (forcing for testing purposes)
I look at the underlying child table from which the view was built and i see the changes
Now here's the problem.
I leave foxpro and return to it. I then go to the child table, browse it, and the records are no longer in it.
What's going on?
How do I fix this?
What have I forgot to do?
TIA,
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only