>Is there a way to know if the current select() is a table or a view and if there is uncommitted changes in it?
>
>thanks
>eric.

If a view or cursor, DBF() will return a temp file name with a .TMP extension and the path will the return value of GetEnv("TEMP"). If not a free table:

llRetVal = (indbc(alias(), "table") or indbc(alias(), "view"))

If llRetval is TRUE, then the alias is a table or view. You can also use Cursorgetprop("buffering") to see if the table is buffered [a view is always buffered]. Then, if a view or the table is buffered, you can use GetNextModified() function to see if there are any uncommitted changes.