|
|
 | | From: | Robert Bravery | | Subject: | DQ and MSSQL tables | | Date: | Wed, 19 Jan 2005 15:49:48 +0200 |
|
|
 | HI all,
When dropping a table from a mssql2000 server, dq assigns it a horrible
name, like ._b01, instead of .mytablename. This is unworkable in DQ, as I
have at times over 10 table, some over 40 table, to distinguish one from the
other becomes rather difficult, ie _b01....._b40. Who know what that means.
It then take a considerable amount of time to edit the DMD in the editor, I
might as well have coded it myself then.
Thanks
Robert
|
|
| | From: | Robert Bravery | | Subject: | Re: DQ and MSSQL tables | | Date: | Fri, 21 Jan 2005 19:33:27 +0200 |
|
|
| HI,
Any 1 have any answers here
Robert
"Robert Bravery" wrote in message
news:7Cy1c0i$EHA.1132@news-server...
> HI all,
>
> When dropping a table from a mssql2000 server, dq assigns it a horrible
> name, like ._b01, instead of .mytablename. This is unworkable in DQ, as I
> have at times over 10 table, some over 40 table, to distinguish one from
the
> other becomes rather difficult, ie _b01....._b40. Who know what that
means.
> It then take a considerable amount of time to edit the DMD in the editor,
I
> might as well have coded it myself then.
>
> Thanks
> Robert
>
>
|
|
| | From: | Marty Kay | | Subject: | Re: DQ and MSSQL tables | | Date: | Fri, 21 Jan 2005 13:41:38 -0500 |
|
|
| Robert,
> When dropping a table from a mssql2000 server, dq assigns it a horrible
> name, like ._b01, instead of .mytablename. This is unworkable in DQ, as I
> have at times over 10 table, some over 40 table, to distinguish one from
the
> other becomes rather difficult, ie _b01....._b40. Who know what that
means.
> It then take a considerable amount of time to edit the DMD in the editor,
I
> might as well have coded it myself then.
What were the original table names?
dQuery contains code to work around some table name issues that would
otherwise
cause problems. Perhaps you have some table names that are triggering
unintended behaviour?
- Marty Kay (dBI) -
|
|
| | From: | Robert Bravery | | Subject: | Re: DQ and MSSQL tables | | Date: | Sat, 22 Jan 2005 09:14:33 +0200 |
|
|
| HI,
Table names are nothing special. Happens with all MSSQL tables. E>G> Broker,
company, Insurer, address, Policy, etc etc etc.
Robert
|
|
|
