i got a bunch of view on my database designer. i use this code
OPEN DATABASE pinjaman
*=ADBOBJECTS(ga_Connections, “CONNECTION”)
*=ADBOBJECTS(ga_Relations, “RELATION”)
*=ADBOBJECTS(ga_Views, “VIEW”)
=ADBOBJECTS(ga_Tables, “TABLE”)
CLOSE DATABASES
thisform.grid1.recordsource = 0
CREATE CURSOR dbRelat (Parent_Table C(40),Child_Table C(40),Parent_Key C(40),Child_key C(40),Spacer C(1))
TRY
INSERT INTO dbRelat FROM ARRAY ga_Tables
CATCH
MESSAGEBOX(“No Relations in this DataBase!”,48,1000)
ENDTRY
thisform.grid1.recordsource = ‘dbrelat’
i wanna know where my tables are. cause when i browse that view i got warning that cannot find debitur on database.
i wanna know first table are opened first to determine ‘debitur’.dbf