📚 SAP Business One SDK Help

UserQueries Object Members
See Also  Overview 

Public Methods

Public Method AddAdds a user query to the User Queries library.
Public Method GetAsXMLReturns the object from XML data, which is stored as string in a buffer.
Public Method GetByKeyRetrieves and sets the values of the object's properties by the object's absolute key from the Company database.
Public Method RemoveDeletes the current record.
Public Method SaveToFileSave the object to a file as XML data.
Public Method SaveXMLSaves the object data to XML formatted data.
Public Method UpdateUpdates the object data in the company database.

Public Properties

Public Property BrowserReturns the DataBrowser object.
Public Property EnableMenuEntrySpecify whether to display the query from the menu.

Field name: MenuItem.

Public Property InternalKeyReturns the user query code as assigned by the system when adding a new user query.

Field name: IntrnalKey.

Public Property MenuCaptionThe caption of the menu.

Field name: MenuCapt.

Length: 254 characters.

Public Property MenuPositionSpecify the position of the query in the menu.

Field name: MenuPos.

Public Property MenuUniqueIDSpecify the unique ID of the menu.

Field name: MenuUid.

Length: 32 characters.

Public Property ParentMenuIDThe ID of the parent menu, starts from 0. You can select the parent menu item from the menu navigaton tree structure.

Field name: FatherMenu.

Public Property ProcedureAliasproperty ProcedureAlias
Public Property ProcedureNameproperty ProcedureName
Public Property QuerySets or returns the query content, for example, a SELECT statement for SQL databases.

Field name: QString.

Length: 64,000 characters.

Public Property QueryCategorySets or returns the code of the query category (foreign key to QueryCategories).

Mandatory property.

Field name: QCategory.

Public Property QueryDescriptionSets or returns the query name. The value must be unique within the same category.

Mandatory property.

Field name: QName.

Length: 100 characters.

Public Property QueryTypeThe type of the query.

Field name: QType.

Public Property UserFieldsReturns the UserFields object.

See Also