Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 266 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Web Service - Header/Lines SubFormLink issue when equals chr
ScottJones
Member Posts: 44
Our client has used manufacturer part numbers containing equals signs this seems to be causing issues on Page joins
I am using a Page to expose [“Sales Invoice Line”] linked to [Serial Number Ledger Entry”] using the property SubFormLink Item No.=FIELD(No.),Document No.=FIELD(Document No.),Entry Type=CONST(Sale)
This works fine when we run the Page from the object designer and as we page up and down the [“Sales Invoice Line”] records, the (Part Page) SubForm lists the items serial number associated to the line. When we run this using an ASP.NET page linked to the web services we get the following error.
The filter ‘PIX-515-VPN0-3DES=‘ is invalid. You entered an invalid expression in the filter on the Item No. field in the Serial Number Ledger Entry table.
It looks as though the Web Service ‘service’ is using some form of filtering and interpreting the special characters =?<> when it builds the SQL join? I have tried applying the filter in code to the subform but this has not worked because initially it retrieves all records which kills the web service.
Is this by design? Have others experienced this? Can anyone think of a work around apart from exposing Header / Lines as separate web services and thus increasing server round trips? Just installed NAV2009R2 but still no joy
I am using a Page to expose [“Sales Invoice Line”] linked to [Serial Number Ledger Entry”] using the property SubFormLink Item No.=FIELD(No.),Document No.=FIELD(Document No.),Entry Type=CONST(Sale)
This works fine when we run the Page from the object designer and as we page up and down the [“Sales Invoice Line”] records, the (Part Page) SubForm lists the items serial number associated to the line. When we run this using an ASP.NET page linked to the web services we get the following error.
The filter ‘PIX-515-VPN0-3DES=‘ is invalid. You entered an invalid expression in the filter on the Item No. field in the Serial Number Ledger Entry table.
It looks as though the Web Service ‘service’ is using some form of filtering and interpreting the special characters =?<> when it builds the SQL join? I have tried applying the filter in code to the subform but this has not worked because initially it retrieves all records which kills the web service.
Is this by design? Have others experienced this? Can anyone think of a work around apart from exposing Header / Lines as separate web services and thus increasing server round trips? Just installed NAV2009R2 but still no joy
0
Comments
We are also developing a system that from within Navision tables/forms allows multiple middle tier services to be configured. These can then be enable/disabled from within Navision to allow some form of load balancing across mutlipe middle tier server services and allow us to migrate a running solution from one server to another to reduce down time. Anyone else had experience with this or developed their own solution?
Regards,
egnaz