Nerissa,

I guess INDBC() was a mistake of mine.

the problem is that indbc() checks if a OBJECT, not a file is in a DBC.

Better use CURSORGETPROP("Database",ALIAS()) as Gregoy Adam pointed out in message#675329.

Imagine you have the following tables

c:\myfolder\xyz.dbf
and
c:\myfolder\dbcfolder\xyz.dbf

and a database
c:\myfolder\dbcfolder\MyDBC.dbc


two tables right? The second one is in database MyDBC, the first not

if you do

open data c:\myfolder\dbcfolder\MyDBC.dbc

use c:\myfolder\xyz.dbf

?indbc(alias(),'TABLE'), 'Alias 1'
?indbc(dbf(),'TABLE'), 'dbf 1'
?CURSORGETPROP("Database",ALIAS()), 'Property 1'
use c:\myfolder\dbcfolder\xyz.dbf
?indbc(alias(),'TABLE'), 'Alias 2'
?indbc(dbf(),'TABLE'), 'dbf 2'
?CURSORGETPROP("Database",ALIAS()), 'Property 2'

you see whats happens.

Agnes

>Thanks a lot Agnes. INDBC() works for the application that I am doing now.
>
>Nerissa