SQL Update ?

From: Skybuck Flying (nospam_at_hotmail.com)
Date: 03/29/04

  • Next message: AlanGLLoyd: "Re: Attempting to read past end of strings" 
    Date: Mon, 29 Mar 2004 09:08:32 +0200

    What is wrong with this sql update ?

    // does not work ?
     ADOQuery1.SQL.Text := 'UPDATE TablePlayer ' +
            'SET PlayerLoggedIn = :PlayerLoggedIn, ' +
            'PlayerTimeStamp = :PlayerTimeStamp, ' +
            'PlayerPublicIPAddress = :PlayerPublicIPAddress, ' +
            'PlayerPublicUDPPort = :PlayerPublicUDPPort ' +
            'WHERE PlayerName = :PlayerName AND PlayerPassword =
    :PlayerPassword';

    // does work ?!
    (*
     ADOQuery1.SQL.Text := 'UPDATE TablePlayer ' +
            'SET PlayerLoggedIn = :PlayerLoggedIn, ' +
            'PlayerTimeStamp = :PlayerTimeStamp, ' +
            'PlayerPublicIPAddress = :PlayerPublicIPAddress, ' +
            'PlayerPublicUDPPort = :PlayerPublicUDPPort ' +
            'WHERE PlayerName = "' + EditPlayerName2.Text + '" AND
    PlayerPassword = "' + EditPlayerPassword2.Text + '"';
    *)

  • Next message: AlanGLLoyd: "Re: Attempting to read past end of strings"
    • Quantcast