[dba-SQLServer] SHAPE question

I first discovered SHAPE command when I protoyped an app using VB6's
Application Wizard.  It used Shape for the Master/Child forms with ADO
Data Control and grids.
Maybe running the App Wizard aginst Northwind mdb, or SQL Pubs, would
let you see the SHAPE command in action.

Hth
Steve


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Steve
Erbach
Sent: Tuesday, April 12, 2005 11:01 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SHAPE question


Charlotte,

Well, you are a voice of reason and probity. That's good enough for me.

Interesting. Between hours when I'm working on other projects, I've
begun my own sample SHAPE application using ASP and ADO. Having now read
quite a bit about SHAPE from the docs I found, it looks like the guy
that wrote the SHAPE statement in the code I've been adapting did
something a bit screwy. I'm going to try constructing the statement a
different way and see if I get the same or a different result set.

Steve Erbach


On 4/12/05, Charlotte Foust <cfoust at infostatsystems.com> wrote:
> LOL  Yeah, right, I gave you so many hints! <VBG>  You were having a 
> conversation with yourself since I wasn't in this board at all over 
> the weekend and had no time to look yesterday, so don't give me any 
> credit!
> 
> I used SHAPE quite a bit with Access 2000 to populate hierarchical 
> flexgrids, but I haven't used it since because in my current job we 
> used only DAO with Access and I was prohibited from using ADO at all 
> ... Until I wound up programming in VB.Net using ADO.Net! <g>
> 
> There were some articles on using SHAPE with VB6 and Access 2k and I 
> built a sample based on one of them, but it isn't on this machine and 
> it uses a hflexgrid control.  If you're interested, I can probably dig

> it out, but it is strictly Access, no SQL Server involved.
> 
> In some ways SHAPE is like creating an XML file but without the tags. 
> What you're really doing is creating nested recordsets and joining 
> them together, which is where the aliases come in.
> 
> Charlotte Foust
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com