Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

ADO SHAPE Help

AceOfHobbesAceOfHobbes Member Posts: 1
Hi all.

Need some help with an syntax error with the ADO Shape command. I am adding featured to a Legacy VB6 application and I am trying to generate a hierarchy like this
Level 1
Data Set A
Data Set B
Data Set C
Data Set D

I can get it to work for data sets A,B, and C. When I add the shape command for Data set E, I get the very informitive Syntax error.

Code Snippet
[size=3] strSql = "SHAPE {exec dbo.rxl_getTMSVersionTypes ?,?,?,?} as VersionTypes " & _
" APPEND ((SHAPE {exec dbo.rxl_getTMSPolicyVersions ?,?,?,?} as PolicyVersions " & _
" APPEND ({exec dbo.getTMSPolicyTransactions ?, ?} " & _
" relate PCH_VER_ID to PCH_VER_ID " & _
" ) as PolicyTransactions " & _
" APPEND ((SHAPE {exec dbo.getTMSVersionVehicles ?,?} " & _
" APPEND ((SHAPE {exec dbo.getTMSVehicleTransactions ?,?} " & _
" APPEND ({exec dbo.GetTMSCoverages ?} " & _
" relate VEH_ID to COV_VEH_ID, VEH_PCH_TRAN_ID to cov_veh_pch_tran_id) as coverages, " & _
" ({exec dbo.getTMSEndorsements} " & _
" relate veh_id to End_veh_id, veh_pch_tran_id to End_veh_pch_tran_id) as Endorsements) " & _
" relate PCH_TRAN_ID to VEH_PCH_TRAN_ID, veh_id to veh_id)) " & _
" ) " & _
" relate PCH_VER_CD to PCH_VER_CD, VER_EFF_DT to EFF_DT " & _
" ) as VersionSummary"[/size]

Thanks in advance

Sign In or Register to comment.