Mark Alexander
- Total activity 12
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 1
- Subscriptions 3
Comments
Recent activity by Mark Alexander-
Hi Martin, I found it now. I was querying on the wrong attribute (DocNum instead of DocEntry), and it was returning nothing for the view. Now I'm getting all the rows, with the planned time. Thanks...
-
Hi Martin, If I query the view (BEASV_WORKORDER_ROUTING), I get nothing for the work order in question (33780). If I query table BEAS_FTAPL I get the 3 rows for each operation, but none of the valu...
-
Hi Martin, Thanks for replying. I see planned time and reserved time, which are taken from BEAS_FTAPL and BEAS_RESOURCEN respectively. I can't find the planned time in BEAS_FTAPL and the BEAS_RESOU...
-
Hi Daniel, Thanks for the response, I put the missing text into the query and it worked great. I didn't put them in originally as I thought they were comments (Similar to C++ code), and didn't real...
-
Hi Daniel, thanks for the response. I did as you suggested but I still get an error. Here's my new SQL statement below: DECLARE @ItemCode NVARCHAR(100)SET @ItemCode = '[%0]' SELECT t1.ItemCode, t2....