Access conversion to SQL
- From: "tclancey" <tull@xxxxxxxxxxxxxxxx>
- Date: Mon, 2 Apr 2007 17:42:25 +0100
Hi all.
I have an application that currently connects to an Access database, now the
customers are asking for a MySql and MsSql server back end database.
MySql handles True and False values through the bit field without any
problems, MsSql doesn't. I can't even use the words True or False in an Sql
statement.
This means I have to write two loads of code for every transaction where
there is a true/false value involved, a complete pain.
It also gives me the problem of setting controls true/false value by
checking a table field:
chkAdmin.Checked = GetField("select admin from users where
username='Bert';", "admin")
(Get field is a routine that loads a data record and returns the field as
the second parameter)
As SQL never returns a true or false value in this way I have to write extra
code for every check, or checked list, etc.
Is there a way around this?
Cheers,
Tull.
.
- Follow-Ups:
- Re: Access conversion to SQL
- From: david
- Re: Access conversion to SQL
- Prev by Date: Re: france
- Next by Date: I never wanted to participate;how can I remove myself--so I NO LONGER RECEIVE ANY E-MAILS FROM SAME?????from:lorenechristy@comcast.net????
- Previous by thread: Re: france
- Next by thread: Re: Access conversion to SQL
- Index(es):
Relevant Pages
|
