#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    64
    Rep Power
    11

    Does VC++ .net supports SQL - DECODE?


    Does VC++ .net supports the SQL-Code DECODE? I always get this error: DECODE is an undefiened function

    Code:
    Testcommand("Select Customer,[Home], DECODE(Home,'NY','NewYork') From User");
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    64
    Rep Power
    11
    Because my database is an Access-database I can use this code:
    (I wanted to replace NULL with SPACE'')
    Code:
    String* Testcommand;
    Testcommand="Select Customer, IIf(ISNULL(Home),'',Home) From User";

IMN logo majestic logo threadwatch logo seochat tools logo