Bad SQL after formattig (on Version 4)

I typed in the following SQL:

Code:

SELECT * FROM SD_FIELDSALIAS WHERE
( nvl(FIELD_ID,'-1'), nvl(FIELD_NAME,'-1'), nvl(TABLE_NAME,'-1')) in
(SELECT nvl(FIELD_ID,'-1'), nvl(FIELD_NAME,'-1'), nvl(TABLE_NAME,'-1') FROM (
SELECT SERVICE_SOURCE_TYPE,SERVICE_SOURCE,TABLE_NAME,FIELD_NAME,ALIAS,COLUMN_ALIAS,FIELD_ID,FIELDTYPE,CONTROL_TYPE,FORMAT_STYLE,CONTENT_SOURCE,FAILURE_ACTION,ACCESS_KEY,MAX_LENGTH,DEFAULT_VALUE,AUDIT_LOOKUP_SOURCE,COLUMN_WIDTH,DESCRIPTION,FIELD_VALUE_LIST,VALUE_COLUMN_NAME,VALIDATE_ON_SERVER
FROM SD_FIELDSALIAS
MINUS
SELECT SERVICE_SOURCE_TYPE,SERVICE_SOURCE,TABLE_NAME,FIELD_NAME,ALIAS,COLUMN_ALIAS,FIELD_ID,FIELDTYPE,CONTROL_TYPE,FORMAT_STYLE,CONTENT_SOURCE,FAILURE_ACTION,ACCESS_KEY,MAX_LENGTH,DEFAULT_VALUE,AUDIT_LOOKUP_SOURCE,COLUMN_WIDTH,DESCRIPTION,FIELD_VALUE_LIST,VALUE_COLUMN_NAME,VALIDATE_ON_SERVER
FROM hub_ma2.SD_FIELDSALIAS ))

After using format (CTRL +F11) I gat bad SQL:

Code:

/************************************************************
* Code formatted by SoftTree SQL Assistant © v4.0.20
* Time: 10/5/2008 8:03:30 PM
************************************************************/

SELECT
*
FROM
SD_FIELDSALIAS
WHERE
(
   NVL(FIELD_ID ,'-1')
   ,NVL(FIELD_NAME ,'-1')
   ,NVL(TABLE_NAME ,'-1')
) IN (SELECT
   NVL(FIELD_ID ,'-1')
   ,NVL(FIELD_NAME ,'-1')
   ,NVL(TABLE_NAME ,'-1')
   FROM
   (
      SELECT
         SERVICE_SOURCE_TYPE
         ,SERVICE_SOURCE
         ,TABLE_NAME
         ,FIELD_NAME
         ,ALIAS
         ,COLUMN_ALIAS
         ,FIELD_ID
         ,FIELDTYPE
         ,CONTROL_TYPE
         ,FORMAT_STYLE
         ,CONTENT_SOURCE
         ,FAILURE_ACTION
         ,ACCESS_KEY
         ,MAX_LENGT
         H
   ,DEFAULT_VALUE
         ,AUDIT_LOOKUP_SOURCE
         ,COLUMN_WIDTH
         ,DESCRIPTION
         ,FIELD_VALUE_LIST
         ,VALUE_COLUMN_NAME
         ,VALIDATE_ON_SERVER
      FROM
         SD_FIELDSALIAS
      MINUS
      SELECT
         SERVICE_SOURCE_TYPE
         ,SERVICE_SOURCE
         ,TABLE_NAME
         ,FIELD_NAME
         ,ALIAS
         ,COLUMN_ALIAS
         ,FIELD_ID
         ,FIELDTYPE
         ,CONTROL_TYPE
         ,FORMAT_STYLE
         ,CONTENT_SOURCE
         ,FAILURE_ACTION
         ,ACCESS_KEY
         ,MAX_LENGT
         H
         ,DEFAULT_VALUE
         ,AUDIT_LOOKUP_SOURCE
         ,COLUMN_WIDTH
         ,DESCRIPTION
         ,FIELD_VALUE_LIST
         ,VALUE_COLUMN_NAME
         ,VALIDATE_ON_SERVER
      FROM
         hub_ma2.SD_FIELDSALIAS
   ))

you can see formatter cut the field MAX_LENGTH into 'MAX_LENGT' and 'H'

I'm unable to reproduce this issue. I tried DB Tools and tried Notepad. Which editor are you using?

I am using an internal appliction (Written in VB6) the SQL Assistent is working on Rich text edit. (RichTextWndClass)

This could be caused by your application trying to do something, non-printable ASCII characters in the code or something else outside of SQL Assistant. To verify, enable Notepad target, copy the same SQL code and format there. If you don't get identical result, then your application is doing something that is affecting the code formatting.

By the way, are you aware of SQL Assistant API?

Where can I read on SQL Assistant API. (could not find in the 3.5 PDF)

Please check out http://www.softtreetech.com/sqlassist/api.htm

Looks Cool!

where can I find some documentation / source for this?

Hi, the documentation and sources are provided to licensees only.

I have a license. Where can I obtain the API documentation and source?

Did you mean that you have a user license for SQL Assistant, or you have licensed the API?

I have SQL Assist. I don't see a separate product listed on the http://www.softtreetech.com/isql.htm page. I'd like to learn more about the product but it seems rather difficult to find a trial, documentation, or description. What's up?

Please follow the API link on this server http://www.softtree.com/sqlassist/index.shtml. This will lead you to the description and download of a demo project created in VB6 using ODBC and SQL Server as a backend. If you are interested in adding it to a NET type project and need C# or similar sample, please contact our sales guys sales@*NOSPAM*softtreetech.com and ask for further assistance with this matter. Remove *NOSMAP* suffix after pasing the email.

Perfect. Thanks!