Extract info from .dbc Property field 1

[Prospector]

Dear Members:

A .dbc table may be "used" and opened using a .dbc extension.

A Modify Structure command shows a Table Designer window for the .dbc with a structure of the various fields. One of the fields is called "property" and is a binary memo field.

In the Command Window, enter: cd Home()+"filespec"

Then in the Window, enter: report form 60dbcpro.frx in screen.

The display shows a table of valid properties stored in the .dbc Property field.

My question is whether there is a method to access the values of the individual properties.

Onward,

Prospector

 

[fluteplr]

At the risk of being obvious (and wrong) are you sure these properties are not available by using the standard dbgetprop command?

 

[DSummZZZ]

You mean something besides MODIFY DATABASE?

Dave S.

 

[fluteplr]

yes.

look up dbgetprop in the help file as in .


Returns a property for the current database or for fields, named connections, tables, or views in the current database.

DBGETPROP(cName, cType, cProperty)
Return Values
Character, Numeric, or Logical

Parameters
cName
Specifies the name of the current open database or the field, named connection, table, or view in the current open database for which DBGETPROP( ) returns information.
To return information about a field in a table or a view, preface the name of the field with the name of the table or view containing the field. For example, to return information about the custid field in the customer table, specify the following for cName:

customer.custid
cType
Specifies whether cName is the current database, or a field, named connection, table, or view in the current database. The following table lists the values you can specify for cType: cType Description
CONNECTION cName is a named connection in the current database.
DATABASE cName is the current database.
FIELD cName is a field in the current database.
TABLE cName is a table in the current database.
VIEW cName is a view in the current database.

etc.

 

[DSummZZZ]

Actually, we posted at the same time. I was asking Prospector if that was what was being asked. I have used dbgetprop before, but it sounded like Prospector hadn't accessed the properties via the db designer. I dunno.

Dave S.