Einzelnen Beitrag anzeigen

unitedlb

Registriert seit: 30. Sep 2003
73 Beiträge
 
Delphi 6 Professional
 
#3

Re: INSERT INTO in Tabelle mit Beziehungen über SQL?

  Alt 14. Jul 2005, 19:02
Delphi-Quellcode:
 sqlfield := 'Act-Journal-ID,SN,Company,Name,Adresse,PLZ,Telefon,Bemerkung';

                sqldata := cases[r].journalid+','+
                           quotedstr(cases[r].sn)+','+
                           quotedstr(cases[r].company)+','+
                           quotedstr(cases[r].name)+','+
                           quotedstr(cases[r].adresse)+','+
                           quotedstr(cases[r].plz)+','+
                           quotedstr(cases[r].ort)+','+
                           quotedstr(cases[r].telefon)+','+
                           quotedstr(cases[r].bemerkung);

                with form1.ADOQuery1.SQL do begin
                        Clear;
                        add('INSERT INTO Aufträge ('+sqlfield+') VALUES('+sqldata+')');
                        end;
                form1.ADOQuery1.ExecSQL;
  Mit Zitat antworten Zitat