web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / The ) is missing - err...
Microsoft Dynamics SL (Archived)

The ) is missing - error when using custom button with the Launch command to call ROI in Dynamics 2011.

(0) ShareShare
ReportReport
Posted on by Community Member

I get an error message in a Crystal Report Windows Forms Viewer window saying... The ) is missing... when using a custom button with the Launch command to call ROI in Dynamics 2011. I have gone to the "books" and followed the examples given but have no success. This command used to work in Dynamics SL 7 before upgrading to Dynamics 2011. Can someone give me a tip on what is wrong?

Below is the code behind my custom button...

 

Sub cmdReport_Click()

    Dim CustId As String * 10

    Dim ParmStr$

 

    CustId = GetObjectValue("ccustid")

    ParmStr = "ROI.EXE " + PRMSEP + "08652/RUN" + PRMSEP + "08652/FORMAT" + PRMSEP + "ARTran.Custid = " + SParm(CustId) + "/WHERE" + PRMSEP + "/PSCRN"

    serr2 = Launch(ParmStr, True, True, 0)

    'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/RUN")

    'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/FORMAT")

    'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "ARTran.Custid = " + SParm(CustId) + "/WHERE")

    'Call ApplSetParmValue(PRMSECTION_VBRDT, "", "/PSCRN")

    'serr2 = Launch("ROI.EXE ", True, True, 0)

 

End Sub

 

*This post is locked for comments

I have the same question (0)
  • Barry Flynn Profile Picture
    Barry Flynn 3,090 on at

    Test

  • Verified answer
    Barry Flynn Profile Picture
    Barry Flynn 3,090 on at

    In SL2011, it is necessaey to enclose the TableName.ColumnName in curly braces

    Barry

  • Community Member Profile Picture
    Community Member on at

    Thank you very much, Barry!! Your answer worked for us!

    Just in case someone needs to see the working code, I pasted the two examples below...

     

     

     

     

    Sub cmdReport_Click()

        Dim CustId As String * 10

        Dim ParmStr$

     

        CustId = GetObjectValue("ccustid")

        'ParmStr = "ROI.EXE " + PRMSEP + "08652/RUN" + PRMSEP + "08652/FORMAT" + PRMSEP + "{ARTran.Custid} = " + SParm(CustId) + "/WHERE" + PRMSEP + "/PSCRN"

        'serr2 = Launch(ParmStr, True, True, 0)

        Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/RUN")

        Call ApplSetParmValue(PRMSECTION_VBRDT, "", "08652/FORMAT")

        Call ApplSetParmValue(PRMSECTION_VBRDT, "", "{ARTran.Custid} = " + SParm(CustId) + "/WHERE")

        Call ApplSetParmValue(PRMSECTION_VBRDT, "", "/PSCRN")

        serr2 = Launch("ROI.EXE ", True, True, 0)

     

    End Sub

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans