| View previous topic :: View next topic |
| Author |
Message |
Terry
Guest
|
 Posted: Wed Feb 21, 2007 1:26 am Post subject: yes/no field vs. bit field |
 |
|
I have been developing an app using a microsoft access db as a test
vehicle. ( the data can be local ). The 'real' database is a microsoft
sql db.. I would like to be able to run the app using the access db for
testing, then switch to using the sql db for production. I am having a
problem with the yes/no field vs. the bit field. in some sql statements
I need to test if a logical is true. Access only works if the test is
'where lassigned = true ' . sql db does not like 'true'. If I use a
where clause 'where linactive = true', error 'invalid column name 'true'
'is the result. only works if test is 'where lassigned = 1 '. Is
there a way to make this compatible? Or are my days of local testing
coming to an end?
Thanks for any suggestions. |
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Wed Feb 21, 2007 2:45 am Post subject: Re: yes/no field vs. bit field |
|
|
Download a copy of MSDE or SQL Server Express (depending on which
version of SQL server you will use in production) and use that for
testing. Then you know you will not have compatibility issues.
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
Wayne Niddery [TeamB]
Guest
|
| Posted: Wed Feb 21, 2007 9:31 pm Post subject: Re: yes/no field vs. bit field |
|
|
Terry wrote:
| Quote: | I have been developing an app using a microsoft access db as a test
vehicle. ( the data can be local ). The 'real' database is a
microsoft sql db.. I would like to be able to run the app using the
access db for testing, then switch to using the sql db for
production. I am having a problem with the yes/no field vs. the bit
field.
|
Access is probably the worse possible choice for this, it has it's own very
unique dialect of SQL, it is not at all like the dialect in MS SQL, which is
a lot more standard. There is an MS SQL Express edition that can be used for
development and/or "local" use.
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Light is faster than sound, which is why some folks appear bright
before they speak." |
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
