Language Reference Guide : System Classes : LongVcharObject Class : FetchFromDB Method
 
Share this page          
FetchFromDB Method
The FetchFromDB method retrieves a long varchar data from the specified database table into the Value attribute of the LongVcharObject.
This method has the following syntax:
integer = LongVcharObject.FetchFromDB(query = querystring)
This method has the following parameter:
query
(Required) Specifies an SQL update statement where the "into" clause and target variable are not specified (for example, select text_col from long_text where chapter = 'Chapter 1')
If the specified field is not a child of the matrix field, this method returns FALSE.
OpenROAD retrieves the LongVcharObject database object indicated by the current value of the DBHandle attribute.
This method returns ER_OK if it is successful or another non-zero database error code if it is not. Descriptions of system constant values and their numeric equivalents are listed in Error Codes.