AndrewMozley
Programmer
I have a table XSORD which has a field ‘Account’ - the customer account number, and have executed the instruction :
In order to retrieve records for a particular customer, say ‘S100’, I can execute a command :
This however returns a cursor which certainly includes records for customer S100, but also records for customers ‘S1004’ and ‘S1009'.
I believe that I can correct this by changing the SQL statement to :
It seems that in this session, SQL is not respecting the SET(“EXACT”) setting. Is that always the case?
Thanks - Andrew
Code:
SET EXACT ON
In order to retrieve records for a particular customer, say ‘S100’, I can execute a command :
Code:
SELECT * FROM XSORD WHERE Account = ‘S100’
This however returns a cursor which certainly includes records for customer S100, but also records for customers ‘S1004’ and ‘S1009'.
I believe that I can correct this by changing the SQL statement to :
Code:
SELECT * FROM XSORD WHERE Account == ‘S100’
It seems that in this session, SQL is not respecting the SET(“EXACT”) setting. Is that always the case?
Thanks - Andrew