Jim Lawrence (AccessD)
accessd at shaw.ca
Thu May 1 10:05:03 CDT 2003
Hi Gustav: Here is a MS explaination: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q189657&SD=MSKB Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock Sent: Thursday, May 01, 2003 6:06 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Which SQL engines support SHAPE? Hi Martin and Jim Thanks! To put it in other words, just to be sure: Does this mean that SHAPE is "pseudo SQL" - a syntax of ADO, which transforms the SHAPE sentence into normal SELECT queries which are sent behind the scene to the engine via OLEDB? Thus any SQL engine with an OLEDB driver can be used? /gustav > Send you an article of list. > Martin > ----- Original Message ----- > From: "Jim DeMarco" <Jdemarco at hshhp.org> > To: "accessd" <accessd at databaseadvisors.com> > Sent: Thursday, May 01, 2003 1:13 PM > Subject: RE: [AccessD] Which SQL engines support SHAPE? >> Gustav, >> >> I believe Shape is an ADO object introduced in ADO 2.0. Here's some info >> from help but it looks like it might work with any OLEDB compatible data >> source. >> >> <help snip> >> The Microsoft Data Shaping Service for OLE DB service provider supports >> the construction of hierarchical (shaped) Recordset objects from one or more >> data providers. >> >> Provider Keyword >> >> To invoke the Data Shaping Service for OLE DB, specify the following >> keyword and value in the connection string. >> >> "Provider=MSDataShape" >> >> </help snip> >> >> HTH, >> >> Jim DeMarco >> Director of Product Development >> HealthSource/Hudson Health Plan >> >> >> -----Original Message----- >> From: Gustav Brock [mailto:gustav at cactus.dk] >> Sent: Thursday, May 01, 2003 4:48 AM >> To: accessd at databaseadvisors.com >> Subject: [AccessD] Which SQL engines support SHAPE? >> >> >> Hi all >> >> Is SHAPE (returning sub recordsets within a recordset) in SQL >> proprietary of Microsoft SQL Server? >> >> Or do some other SQL engines support this too? _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com