Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a SQL Server view for customer. One customer has CustomerNo of 000000408 and another has 408.
After loading the data from view, both customers have 000000408 as the customer no in QV.
It looks very strange. Has anyone encountered this error? Any workaround to force QV to take the correct customer no.
Thanks.
Both customers in SQL View
Both customers in QV after loading data from the customer view