Consultor Eletrônico

Status: Unverified

SYMPTOM(s):

Error 4181 when using 4GL preselect with Oracle DataServer

SYSTEM ERROR: Field list too large <join level> <table name> (4181)

The following 4GL example against sports Database reproduces the error:

def var h-query as handle no-undo.

create query h-query.

h-query:set-buffers(buffer customer:handle).
h-query:query-prepare("preselect each customer "). /*except ()*/
h-query:query-open().

disp h-query:get-first .

disp customer.

h-query:query-close().
delete object h-query.

FACT(s) (Environment):

Windows NT 32 Intel/Windows 2000
Progress 9.1D

CAUSE:

Bug# OE00085997

FIX:

One way to workaround this issue is to use except() as follows :

h-query:query-prepare("preselect each customer except ()").