Salesforce

DbDel (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

DbDel (Magic xpa 4.x)

Deletes a Magic xpa data source that appears in the Data repository, and returns a logical true or false indicating success or failure of the operation. Removes all records from a data source that is residing as a parameter. Subsequent opening of this data source reloads the records from its database.

Syntax:

DbDel(number,file name)

Parameters:

number – A number that represents the data source's sequence number in the Data repository.

file name – This parameter is used as an alternative to number. If not needed, enter '' (two single quotation marks). If needed, enter an Alpha string that represents the data source specification. The string may contain a path. If the path is not indicated, Magic xpa assumes the current directory.

Returns:

Boolean (True, False)

Examples:

DbDel(1,") or DbDel('1'DSOURCE,") attempts to delete the first data source of the Data repository and returns TRUE if the operation is successful.

DbDel (1,'FSTFIL.DAT') attempts to delete the first data source of the Data repository, using the OS name 'FSTFIL' in the current directory.

Database specific:

For IMDG (Space) databases, this function will not delete the table. It will only delete the tables' records.

Note:

Using the DSOURCE literal will ensure that the correct data source will be deleted even if the data source's position in the Data repository has changed. The data source sequence number and path behave exactly as defined in the Data repository.

The DbDel function, when given a data source (table) that is resident as a parameter, will remove all records from the resident table. Subsequent opening of this data source will reload them from the database.

To delete a local data source, see ClientDbDel.

Exceptions:

This function is not supported for Web Service databases.

See also:

DbRecs, DbExist, DbSize

The Online and Rich Client Samples projects (program EN06 and REN06)

Reference
Attachment 
Attachment