GetValueSqlExp
This method returns the content of a given field from a given Table if a given value expression is satisfied.
Syntax:
oBiz.GetValueSqlExp(<cFieldToReturn>, cTableToSearch>, <cExpression>)
|
Parameter |
Description |
|
cFieldToReturn |
Specifies the Field whose content is to be returned. |
|
cTableToSearch |
Specifies the table in which the value cFieldToReturn is located. |
|
cExpression |
Specifies the expression criteria. Expression criteria must be enclosed in [brackets]. |
Remark:
This method is similar to GetValueSQL. The main difference is that:
GetValueSQL search is based on only one condition. The content of a given field is based on the content of another field.
GetValueSqlExp search is based on an expression that can contain multiple criteria.
Example:
*/ Instantiate end set the database location.
oBiz = createobject("bizinfo.application")
oBiz.cDatabasePath = "C:\WinBIZ Data"
oBiz.nCompany = 1000
oBiz.nYear = 2017
*/ Display the document number for an invoice created for an address with ID = 1000 on the 01.03.2017. The invoice reference is TEST_REFERENCE
messagebox(oBiz.GetValueSQLExp("do_nodoc", "document", [do_type = 20 and do_adr1 = 1000 and do_date1 = {01.03.2017} and do_ref1 = "TEST_REFERENCE"]))