Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
.dbcs
Message
From
27/12/2000 15:25:24
 
 
To
27/12/2000 15:12:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: .dbcs
Miscellaneous
Thread ID:
00457068
Message ID:
00457144
Views:
18
>In my diags program, I USE rsrc.dbc IN 0 SHARE, and I get a message that the file is not part of a database and I am allowed to locate it. However, upon location, it still won't open. The path is working properly and this works fine when running the app within the devel. environment. I just assumed that perhaps you cannot USE a .dbc during runtime.

Does the message say that "rsrc.dbc" is not part of a database? Or is it some other file?
I would be suspicious of trying to locate the database for a DBC file. That doesn't sound right. I would only expect to see that error for a DBF.
I don't have an answer to it, but it would bother me.

>I thought this would be a slick way to identify my tables in lieu of creating a data dictionary table.

Why not use ADBObjects()?

If you need the fields as well, what I often do is
Open Database mydatabase Share
Select d1.objectname As table_name, d2.objectname As field_name ;
  From DBC() d1 ;
  Join DBC() d2 ;
  On d1.objectid = d2.parentid ;
  Where d1.objecttype = "Table" ;
  And d2.objecttype = "Field" ;
  Order By d1.objectname ;
  Into Cursor cuTableFields
Use In mydatabase
I'm guessing you might get the same error as before, but it may be worth a shot.
HTH
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform