SOLVED
Dynamic input error when using a dash
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
jbirdme
5 - Atom
10-13-2016
11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am using the dynamic input tool. It is working fine when the patient ID has no dashes. When it has a dash, I am getting the following error:
Error: Dynamic Input (20): Error: Microsoft OLE DB Provider for SQL Server: Incorrect syntax near '-'.\42000 = 102 in Query: EXEC jmg_FindTheLatestAccount G3-B20151103130257056
When I put this string G3-B20151103130257056 directly into the stored procedure, it works fine. Somehow, it seems that Alteryx is changing it.
Any suggestions?
Solved! Go to Solution.
Labels:
1 REPLY 1
JohnJPS
15 - Aurora
10-13-2016
11:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It may be interpreting the dash as a minus sign. Can you wrap it in quotes as part of passing it to the stored procedure?
