Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: Update Database via SQL

    Delphi
    by DeddyH, 1. Dez 2009
  Use parameters.
• Forum: Datenbanken

  Re: Update Database via SQL

    Delphi
    by DeddyH, 1. Dez 2009
  I am not familiar with Absolute Database, so I cannot say if an autoinc-key can start with 0 there, but you can use this key as condition in the above example:UPDATE <tablename> SET FirstName = 'John', LastName = 'HeyHo', Sallary = 20100 WHERE EmployeeID = 1
• Forum: Datenbanken

  Re: Update Database via SQL

    Delphi
    by DeddyH, 1. Dez 2009
  And updating an existing record looks like this:UPDATE <tablename> SET FirstName = 'John', LastName = 'HeyHo', Sallary = 20100 WHERE <conditions>
  Parameters can be used here as well.