ado shape syntax
hello,
I have this shape statement and I am getting syntax error:
Public Const ProfileShapeV3 = "shape {exec shape_select_Profiles_V3 @SessionLogID} append " & _
"({exec shape_select_RefPickListData_Desc_V3 'POA'} new adDecimal(9) As RelateID ) relate RelateID to ProfileID) as rsPOAIssueByInfo, " &_
"({exec shape_select_RefPickListData_Desc_V3 'USDISTPORTS'}) new adDecimal(9) As RelateID relate RelateID to ProfileID) as rsPortEntryInfo"
I need the 2nd and 3rd recordset for other reason. There is not relationship betweent he 1st recordset and last 2 recordsets. Can I do that? If so, what is the correct syntax for that??
|