[dba-SQLServer] SHAPE question

Steve Erbach erbachs at gmail.com
Thu Apr 7 16:43:30 CDT 2005


Charlotte,

How do you test SHAPE statements? Query Analyzer can't handle them. Do
you plunk the SHAPE statement into a bit of ADO code to open your
connection and feed the SHAPE statement to it and get a Recordset
back? It just seems so clunky when compared to Query Analyzer.

This SHAPE statement looks like it forms a hierarchy like this:

1 Project
1.1 Addenda
1.2 Companies
1.2.1 Detail (phone numbers)

I'm curious about the comma that appears after the first APPEND
statement and before the second SHAPE command. I don't have ANY
documentation on how to string SHAPEs and APPENDs and RELATEs
together, do you?

You mentioned using Aliases. You're talking about aliases for table
names, yes? Like this:

FROM Projects1 P INNER JOIN Counties C ... etc.

Right?

Steve Erbach

On Apr 7, 2005 12:01 PM, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> SHAPE applies to ADO recordsets.  I suspect part of your problem may be
> in this line:
> 
> RELATE ProjectID TO ProjectID
> 
> When I use SHAPE, I always alias each expression so I can specify the
> sources for the join fields.
> 
> Charlotte Foust
>



More information about the dba-SQLServer mailing list