Hi ich benutze Delphi 5 und eine Paradox-Datenbank mit der BDE-5.2 Nur sobald ich den SQL befehl durchführe schmiert mein Programm ab. Kann mir bitte jemand weiterhelfen.
QIncrementSearch.SQL.Add('Update Adressen set Wildcard=1 where '+
'((CAST(Upper(Name1) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Name2) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Name3) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Strasse) as char(40)) like '''+mytext+''')or'+
'(CAST(PLZ as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Ort) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Suchbegriff) as char(40)) like '''+mytext+''')or'+
'(CAST(Nummer as char(40)) like '''+mytext+''')or'+
'(Memo1 like '''+myText2+''')or'+
'(CAST(Upper(Ansprechpartner) as char(40)) like '''+mytext+'''))');
QIncrementSearch.SQL.Add('Update Adressen set Wildcard=1 where '+
'((CAST(Upper(Name1) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Name2) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Name3) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Strasse) as char(40)) like '''+mytext+''')or'+
'(CAST(PLZ as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Ort) as char(40)) like '''+mytext+''')or'+
'(CAST(Upper(Suchbegriff) as char(40)) like '''+mytext+''')or'+
'(CAST(Nummer as char(40)) like '''+mytext+''')or'+
'(Memo1 like '''+myText2+''')or'+
'(CAST(Upper(Ansprechpartner) as char(40)) like '''+mytext+'''))');
Comment