Re: [Sqlpp-devel] spacing problem in generated query

[Jonathan de H. <deh...@au...>]

Waht is you platform ? Windows, Unix, Linux ?

That's strange, I usually don"t get this...

At 13:13 30/10/2003 -0600, you wrote:

>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.

I'll have a look at that.

>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...

-----------------------------------------------------------------------------------
Jonathan de Halleux, Research Assistant
Center for Systems Engineering and Applied Mechanics (CESAME)
Universite catholique de Louvain
Batiment Euler , Av. Georges Lemaitre, 4 Tel : +32-10-47 2595
B-1348 Louvain-la-Neuve Belgium
E-mail : deh...@au...
-----------------------------------------------------------------------------------