I have a problem with transferring Access to SQL that I kinda pushed back onto the back burner but I can no longer procrastinate on the issue.
When my boss switch our Access database over to SQL our system was not working correctly because one of the queries (or something) showed a -1, 0 where SQL used 0, 1 as a true and false indicator.
The problem is, how do I change hundreds of queries that use -1, 0 over to the new system. I can’t really use find and replace or run a loop to change all the -1, 0 because there will be times where I really wanted a -1 or 0 in the code. Further more, if there is some code to change this properly, how would I make it run through all of our queries?
Any insight you can provide would be super great!
B
When my boss switch our Access database over to SQL our system was not working correctly because one of the queries (or something) showed a -1, 0 where SQL used 0, 1 as a true and false indicator.
The problem is, how do I change hundreds of queries that use -1, 0 over to the new system. I can’t really use find and replace or run a loop to change all the -1, 0 because there will be times where I really wanted a -1 or 0 in the code. Further more, if there is some code to change this properly, how would I make it run through all of our queries?
Any insight you can provide would be super great!
B