CREATEOFFLINE( ) Function

  • Article

Takes an existing view offline.

CREATEOFFLINE(ViewName [, cPath])

Return Values

Logical

Parameters

  • ViewName
    Specifies the name of the existing view to take offline. The database containing the existing view must be open before you can take the existing view offline.
  • cPath
    Specifies the directory in which the offline view is placed and the name of the offline view.

Remarks

CREATEOFFLINE( ) returns a logical true (.T.) if the existing view is successfully taken offline; otherwise false (.F.) is returned.

An offline view is opened with USE. When an offline view is open, you can append records or make changes to records in the offline view. However, you cannot use the CREATE TRIGGER, INSERT, PACK or ZAP commands in an offline view. After making changes to the offline view, you can update the data on the server with your changes by opening the offline view with USE and including the ONLINE clause.

You cannot refresh the contents of an offline view with data from the server until the offline view has been opened with USE and the ONLINE clause.

Use DROPOFFLINE( ) to take the offline view back online.

See Also

DROPOFFLINE( ) | USE | CREATE TRIGGER | INSERT | PACK | ZAP