Ergebnis der Suchanfrage

• Forum: Datenbanken

  AW: SQL ReplaceString

    Delphi
    by danten, 4. Aug 2014
  ??????????????????????????
  update produkt set URL = replace (URL,'.','');
  =>>
  Executing Query:
  update produkt set URL = replace (URL,'.','');
  Token ',' expected, but 'replace' found at line 1, column 38 - Native error: 30222
  ??????????????????????????
• Forum: Datenbanken

  AW: SQL ReplaceString

    Delphi
    by danten, 4. Aug 2014
  Thanks to small changes work.
  
  Query1.SQL.Clear;
  Query1.SQL.Add('Update set = "REPLACE (, ""."", """")"');
  Query1.SQL.Add('Update set = "REPLACE (, ""/"", ""-"")"');
  Query1.ExecSQL;
  ......
  
  Thanks Daniel
• Forum: Datenbanken

  SQL ReplaceString

    Delphi
    by danten, 3. Aug 2014
  Hi all.
  How to write a SQL query to change the text in a table recursively?
  Here is the code for an operation with a database table:
  try
  tab_1.First;
  while not tab_1.Eof do
  begin
  with tab_1 do
  begin
  Edit;