>>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.
I think another way is to use ADBOBJECTS(myarray,"view") and then ASCAN().
Edward Pikman
Independent Consultant