Shaping a Shaped Rs
- From: "AK" <nospam@xxxxxxxxxxx>
- Date: Fri, 18 Jan 2008 08:43:23 -0600
Hello,
I am a little confused about the proper syntax for opening a shaped
recordset that is shaping on an already shaped Rs.
I (think) that I understand that the setup for COMPUTE shaping is as
follows:
"SHAPE {child-command} [[AS] table-alias].......
COMPUTE child-alias
and the {child-command} can be:
#1 a command that is translated by the underlying data provider, (usually
an SQL Statement)
#2 a table name preceded by the word table
#3 another Shape command in (...)
#4 the name of a recordset that has already been shaped
Pertaining to #1
As I understand it a SHAPE command can be like this if one is doing option
#1
SHAPE {SELECT * FROM Orders;}
or if using the SQL statement way (of #1) like this:
SHAPE {" & strSQL & "} AS cmdGroup Compute cmdGroup BY 'Name'"
I see here that we still have the curly braces in both of them BUT in the 2d
one we drop the semi-colon
Pertaining to #2
We can have a SHAPE command like this:
SHAPE TABLE Orders;
In which case we drop the curly braces and retain the semi-colon
Pertaining to #3
I have never used this so I do not know
Pertaining to #4
What do we do with the syntax? My existing shaped recordset is called
m_adorecordset, it has no parent or children and I want to shape it using
the compute command to make a parent that is a child of.
My question is how to formulate that {child-command}
What about {} and ;??
Here is an example of what I was thinking of doing.....
Dim str_ChildRs As String
str_ChildRs = "Shape m_adorecordset as Customer compute Customer by
Name"
m_adoRecordset2.Open str_ChildRs, cn, adOpenForwardOnly, adLockReadOnly
Am I formatting this correct on the str_ChildRs term.
I am unsure about those {} and ; or () or if I need " or & or '
Any help appreciated.
AK
.
- Prev by Date: Re: Inserting and retrieving values
- Next by Date: Newbie
- Previous by thread: Re: How to Data Bind (C# or VB) a ComboBox?
- Next by thread: Newbie
- Index(es):
Relevant Pages
|
|
