[Sqlpp-devel] spacing problem in generated query

[Randy D. <ra...@ho...>]

This query was generated using the sql server adaptor.

============= Try a Query================
SELECT 
*
FROM AT_AD_COMM_TBL AS Ad Table 
INNER JOIN AT_AD_TBL AS ChgObj
ON ChgObj.CO_ID = Ad Table.CO_IDAND ChgObj.PROD_ID = Ad Table.PROD_IDAND
ChgObj.BUY_ID = Ad Table.BUY_IDAND ChgObj.AD_ID = Ad Table.AD_ID

GO

============= Generate DB Graph ================
graph G {
graph [bgcolor=white]
node [shape=record fillcolor=lightgrey style=filled]
0[label="AT_AD_COMM_TBL AS Ad Table"];
1[label="AT_AD_TBL AS ChgObj"];
0--1 [headlabel="CO_ID,PROD_ID,BUY_ID,AD_ID"];
}

As you can see there are no spaces following the connectors in the on
clause and there is no delimiter around the Names (aliases) with
embedded spaces.

The generated DDL seems to have a large number of line feeds in some
places. 


================Create SQL================
USE AT_DEV

GO



























IF EXISTS (
    SELECT name FROM dbo.sysobjects
    WHERE name = 'FKREF1'
      AND type = 'F'
    )ALTER TABLE AT_MEDIA_SUB_CAT_TBL DROP CONSTRAINT FKREF1

GO

This is not a real problem except that I am outputting the DDL to  an
output window and I have to filter them to get an acceptable "look".



Regards,
Randy Davis
email:ra...@ho...