I have an issue with a view that worked and now suddenly it does not.
It should display name and cust_num from the table custaddr, but it doesn't pull any data.
I have even substituted a actual carton number for the variable Carton1
The view runs without error and displays the correct header, just no data.
The only exception is if I substitute the '" & Carton1 & "' with 4000545398 which is the last carton number entered to the FIRST cust_num that is alpha (not numeric).
All columns selected in the view are nvarchar of equal lengths.
co_num in Shipper_sii and co are nvarchar (7)
cust_num in custaddr and co are nvarchar (10)
name in custaddr is nvarchar (50)
Anyone have any ideas?
VB.NET:
SELECT c2.name, c2.cust_num from custaddr as c2 INNER JOIN co as c1 ON (c2.cust_num = c1.cust_num) INNER JOIN shipper_sii as s1 on (c1.co_num = s1.co_num) WHERE c2.cust_seq = 0 AND lot = '" & Carton1 & "'
It should display name and cust_num from the table custaddr, but it doesn't pull any data.
I have even substituted a actual carton number for the variable Carton1
The view runs without error and displays the correct header, just no data.
The only exception is if I substitute the '" & Carton1 & "' with 4000545398 which is the last carton number entered to the FIRST cust_num that is alpha (not numeric).
All columns selected in the view are nvarchar of equal lengths.
co_num in Shipper_sii and co are nvarchar (7)
cust_num in custaddr and co are nvarchar (10)
name in custaddr is nvarchar (50)
Anyone have any ideas?