[dba-SQLServer] SHAPE question

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


-----Original Message-----
From: Steve Erbach [mailto:erbachs at gmail.com] 
Sent: Thursday, April 07, 2005 5:13 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] SHAPE question


Charlotte,

Well, I got it to work. But I don't know what I did. Wait! Yes I do. I
added "Provider=MSDataShape" to the connection string.

Thanks for your hints. How often do you use SHAPE?

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
>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com