ENTRY POINTUnder review

F340FLCP

User Function F340FLCP()

Adds an ANSI/SQL expression to the FINA340 title filter.

F340FLCPFINA340

01 · OVERVIEW

Overview

The historical page documents a character return containing a complementary ANSI/SQL expression. The P12.2210 caller concatenates the result to cQry, followed by a space. This differs from F340FCPTOP, whose result replaces the query. The excerpt omits the complete SQL context and aliases. (Refs. 1–2)

02 · SYNTAX

Syntax

User Function F340FLCP()

Return value

Character: SQL filter complement. Do not return the entire query or an AdvPL alias filter expression.

03 · PRACTICAL EXAMPLE

Editorial example based on documentation

#Include "Protheus.ch"

User Function F340FLCP()
    // Editorial baseline with no extra condition; documented SQL contract (ref. 1).
    // Does not invent an alias or return a complete query.
Return ""

Expected result

Teaching proposal with behavior described in comments. Verify the context before compiling in a test environment. Under review: example not compiled or run in Protheus. Verify aliases, locks, transaction position and compatibility in the target release and patch.

04 · PRACTICAL EXAMPLE

Observed call and context

// P12.2210 caller excerpt (EURAI, ref. 2); not an entry point implementation.
// FINA340.PRX - FA340QRYTI() -> CQRY += EXECBLOCK("F340FLCP",.F.,.F.) + " "

Expected result

The record shows arguments and immediate return use where present. It omits the full caller body and does not establish commit timing.

BEST PRACTICES

The empty-text example is only a baseline without an extra criterion for the observed call. Before adding AND or fields, inspect the complete query, aliases and branch criteria.
A call without a fourth argument does not document a PARAMIXB layout. Preserve caller identifiers and do not invent fields or positions.
Test plan: compare standard and customized flows, exercise success, rejection and repetition, and inspect balances, movements and accounting as applicable.
Under review: example not compiled or run in Protheus. Verify aliases, locks, transaction position and compatibility in the target release and patch.