Questions and Answers

Questions and Answers

This section answers some questions about the Vine database.

How Can I Get Available Object Types and/or Object Names?

You should select the needed columns from VY_OBJECT_TABLE_VIEW. For detailed information about that view and its fields see the Database Structure Views section of the Overview Vine Server Database chapter.

Example: The following SELECT will list the names of all object types and corresponding tables from the object set available to the user.

SELECT object_name, table_name from vineyarddb.vy_object_table_view
WHERE object_status='O';

OBJECT_NAMETABLE_NAME

--------------------------------

PersonVY_PERSON

ProjectVY_PROJECT

EventVY_EVENT

DocumentVY_DOCUMENT

CollectionVY_COLLECTION

ResourceVY_RESOURCE

Web linkVY_URL

MapVY_MAP

Sales ProjectVY_SALESPROJECT

CompanyVY_COMPANY

How Can I Get the Name of an Object's Parameter?

The object tables normally only store parameter IDs, for instance in the VY_PROJECT table there is the PROJECTPHASE field that stores the ID of the corresponding parameter from the VY_PROJECTPHASE table.

To get the name of an object's parameter you should use a special function from the VYUtilAPI package - GetParameterName.

For an example of using this function, see its description in the VYUtilAPI Package section.

I Updated an Object, but Changes are Not Seen in the Client?

The most probable reason is that the object's CHANGEDATE field is not updated or it is updated to a wrong value.

For instance if you have directly changed a Vine object in the server database and have forgotten to update CHANGEDATE, then your Vine Windows client will simply overwrite your changes at the next sync.