frequently asked questions

All your questions in one place.

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"]))

Did you find this article useful?

0 out of 0 found this helpful