Records editing

[tsm]

When i have a detail table and i want to edit or add or update a set of records what is the best way to do it. Create cursor, create view or another?
For example when a have a grid that the recordsource is SQL statement with 'INTO cursor' this cursor is readonly. How can i update this records ?

 

[foxdev]

I assume your data source is a DBF table, not a remote data source. You probably want to use an updatable local view, although editing directly to the table might be appropriate depending on the circumstances.

Robert Bradley

http://www.foxdev.com/

 

[tsm]

You mean that the local view is like an 'image' of the
table(s) and it has the behaviour of the real table(s) ?
Is it possible to switch between views and lock different records in every view ?

 

[foxdev]

Yes yes and yes.

You'll need to read up on buffering and commands such as TableUpdate and TableRevert before actually trying this. Not complicated, but you'll get frustrated quickly if you don't first understand the concepts.

Robert Bradley

http://www.foxdev.com/

 

[tsm]

Thanks for your help