Re: Newbie, True and False

I have started conversion of the code that was originaly written for
Access. All commands, Insert, Update etc work fine with MySql, but not
with MsSql. The only real problem that I can see is the True and False
fields. I really don't want to have to write completely seperate routines
for each database back end.

Laudable - but highly improbable (IMO).

Also, pulling in a field and setting a CheckBox.Checked state to True or
False is easy if the return value is True or False.

I have thought about writing some kind of parser to check for certain
keywords and replace them, but I cannot guarantee that the users are not
going to use the words True, Flase or even 1 or 0.

Any help would be greatfully recevied as I currently have no idea how to
get around this!

Neither do I as I don't use Access. I suggest you post to an
Access-specific NG since that is the crux of the issue here. As I said
earlier, there is no boolean datatype in sql server. Since moving an Access
system to sql server appears to be a common activity, I expect that this
topic has been covered in an Access NG.


.

Relevant Pages

  • Re: Newbie, True and False
    ... All commands, Insert, Update etc work fine with MySql, but not with MsSql. ... First time working on an SQL database. ... will need to relearn when using sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: Newbie, True and False
    ... All commands, Insert, Update etc work fine with MySql, but not ... with MsSql. ... The only real problem that I can see is the True and False ... there is no boolean datatype in sql server. ...
    (microsoft.public.sqlserver.clients)
  • Re: From MySql To MSSQL And a Synchronize structure tool
    ... I don't exactly know what you mean by saying "huge" but you are limited with 4GB database size in Express Edition of SQL Server 2005. ... I need a tool to migrate my huge database from MySql to MSSQL Express. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL server vs mySQL ???
    ... SQL Server has the broadest range of tools and support utilities of any database system on the planet--by far. ... MS SQL versus MySQL? ... As of 5.0, MySQL finally supports stored procedures, so they are very similar there (you can genericize your data access a bit due to sprocs in both). ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Transfer LARGE DB from MySQL to SQL Server 2K5 problems
    ... newsgroups are managed (and making that a selling point for MSDN ... forums, which, needless to say, drives me away from the MS web sites, and is ... I am going through the MySQL ODBC v3.51 driver, ... streaming across the wire to my SQL Server box. ...
    (microsoft.public.sqlserver.dts)
Loading