Hi,

In my application, there is a provision for user to add new fields onto master screens.
These new fields are stored in a table. Each time a field is added , the table is altered to include that field as the last column onto the table.

Currently, there are 619 columns on that table..which means 619 user defined fields are defined in application.

When i take a report from these fields along with some other tables which are joined by Left Join, the SQl text is coming with some weird
characters when selected from CTRL+F7.

Attaching the SQL in text.

Why is the query coming in this form.

Though the result is correct, it is consuming a lot of memory and it is not getting freed.

Early response is highly appreciated.

Regards
Ahamed Saajid

Saajid

<< When i take a report from these fields along with some other tables which
are joined by Left Join, the SQl text is coming with some weird characters
when selected from CTRL+F7.

Attaching the SQL in text.

Why is the query coming in this form. >>

How is the query being generated ?  The query text, as represented in that
attachment, shouldn't execute at all.

--
Tim Young
Elevate Software
www.elevatesoft.com