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

    Join Date
    Mar 2007
    Posts
    169
    Rep Power
    37

    MYSQL 5 connection


    I have a simple query

    with query1 do
    begin
    close;
    SQL.clear;
    SQL.add(' select coname from thecompany where code = 1
    open;
    ShowMessage(FieldByName('CoName').AsString);
    close;
    end;

    If i run this its telling me Coname not found. I definitely have that field in the database.I recently tried to upgrade from MYSQL4 to MYSQL5.4 but i just cant cause i get an eroor like this. I even could not get the mysql 5.4 installed.I just cannot understand how it could be so difficult to do. It must be easy.If someone can give me some pointers please let me know.

    Thanks

    Comments on this post

    • Arty Ziff agrees
  2. #2
  3. Sarcky
    Devshed Supreme Being (6500+ posts)

    Join Date
    Oct 2006
    Location
    Pennsylvania, USA
    Posts
    10,866
    Rep Power
    6351
    This is definitely the wrong forum, you're in the regular expression forum.

    -Dan
    HEY! YOU! Read the New User Guide and Forum Rules

    "They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -Benjamin Franklin

    "The greatest tragedy of this changing society is that people who never knew what it was like before will simply assume that this is the way things are supposed to be." -2600 Magazine, Fall 2002

    Think we're being rude? Maybe you asked a bad question or you're a Help Vampire. Trying to argue intelligently? Please read this.

IMN logo majestic logo threadwatch logo seochat tools logo