>An updateable view would be great, except that my SQL statement is too long. Do you have an example of which properties I need to set to create a read-write cursor?
>
>Thanks.
It's not property issue. The safe way to create read-write cursor is to use CREATE CURSOR command. Then you SEEK the first record in table which satisfy your criteria and DO WHILE scanning your table(s) and firing INSERT INTO ... VALUES() until record will not satisfy the criteria. You should understand that doing this way you will get independent cursor, i.e. when user will change data in grid s/he will not update tables automatically, and you will have to write special Save routine to provide it.
Edward Pikman
Independent Consultant