SQLREQ: After any field modification

This entry point is used to give users the ability to edit the search sql request. It is called from Customer Search screen in APRES_MODIF after any field (with the exception of the grid) modification.

Context and operating method

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Additional information

The SQL_CLOB variable is originally defined as the following:

SQL_CLOB = select BPRNUM_0,cast(BPCFLG_0 as varchar(1)),BPRNAM_0,BPRNAM_1,BPDNAM_0,BPDNAM_1, BPAADD_0,BPAADDLIG_0,BPAADDLIG_1,BPAADDLIG_2,CTY_0,SAT_0,POSCOD_0,TEL_0,WEB_0, CNTNUM_0,CNTFNA_0,CNTLNA_0,CCNTEL_0,CNTMOB_0,CNTEMA_0,CCNWEB_0 from VCUSSEA where 1=1

Below is an example on how to modify the SQL_CLOB variable:

Append SQL_CLOB, " and (BPRNUM_0 like upper(‘BPR001’))"

Available variables and masks

The [M:CSE] class is available when in Customer search screen (Common data >> BPs)

Variable or mask

Definition

Mask [M:CSE]

Customer search

Variable SQL_CLOB(5) clbfile

 		　

Open tables

Table

Significant content

Table Title

ADOSSIER

No

Folder table

TABCOUNTRY

No

Countries

BPDLVCUST

No

Ship-to customer

BPCUSTOMER

No

Customers

BPARTNER

No

Business partner

SEACAT: After any field modification

This entry point is used to give users the ability to include added search category fields. It is called from Customer Search screen in APRES_MODIF after any field (with the exception of the grid) modification.

Context and operating method

Transaction

There is no transaction in progress.

Log file

There is no open log file.

Additional information

SEACAT function which is called in APRES_MODIF and the added entry point code.

Funprog SEACAT

Local Char CAT

CAT += [M]BPRNUM

CAT += [M]BPRNAM

CAT += [M]TEL

CAT += [M]WEB

CAT += [M]ADDLIG

CAT += [M]CTY

CAT += [M]SAT

CAT += [M]POSCOD

CAT += [M]CNTNAM

CAT += [M]CNTTEL

CAT += [M]CNTMOB

CAT += [M]CNTWEB

GPOINT="SEACAT" : Gosub ENTREE From EXEFNC

End CAT

Available variables and masks

The [M:CSE] class is available when in Customer search screen (Common data >> BPs)

Variable or mask

Definition

Mask [M:CSE]

Customer search

Variable CAT char

 

Open tables

Table

Significant content

Table Title

ADOSSIER

No

Folder table

TABCOUNTRY

No

Countries

BPDLVCUST

No

Ship-to customer

BPCUSTOMER

No

Customers

BPARTNER

No

Business partner