Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I am working through someone else SQL code and am getting a syntax error near @ line 106 col 43 (pos 2964). I typed in
I am working through someone else SQL code and am getting a syntax error near "@" line 106 col 43 (pos 2964).
I typed in line numbers to help with referencing.
I believe that I need to re-write the code after the @Prompt but do not understand what the @Prompt is doing.
104 WHERE
105 (
106 Table__1."SL_SPECIAL_PROCESS_FLAG" = @Prompt('Special Process Flag:','N','PR/SL/GR Detail Reporting\SL Data\SL Special Process Flag',Mono,Free,Persistent,,User:0,Optional)
107 AND
108 Table__1."MENGE_EKET" Is Not Null
109 AND
110 Table__1."OPEN_FLAG" = 1
111 )
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started