Article View: pl.comp.lang.delphi.bazy-danych
Article #70252Re: pole zawieraj±cedatê
From: Jarosław Zielewski
Date: Sat, 30 Jun 2007 14:10
Date: Sat, 30 Jun 2007 14:10
27 lines
2078 bytes
2078 bytes
Witam serdecznie
najlepiej to zastosować parametry
i wtedy:
Query1.Close;
Query1.SQL.Clear;
Query1.SQL.Add('insert into test(id,nazwisko,data)
values(:id,:nazwisko,:data)');
Query1.ParamByName('id').AsInteger:=4;
Query1.ParamByName('nazwisko').AsString:='abcdef';
Query1.ParamByName('data').AsDateTime:=StrToDate('2007-07-12');
Query1.ExecSQL;
to jest jedna z wielu mozliwosci.
Pozdrawiam
Jarosław Zielewski jaroslawzielewski@systemy-mobilne.pl
www.systemy-mobilne.pl
0606 721 386
(033) 49-78-971
GG 1145439
--
Archiwum grupy: http://niusy.onet.pl/pl.comp.lang.delphi.bazy-danych
Technical Details
Message-ID:
<96211870.20070630161004@systemy-mobilne.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!newsgate.onet.pl!newsgate.plReferences:
<0b55.000000b2.46866017@newsgate.onet.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.rmf.pl!agh.edu.pl!news.agh.edu.pl!news.onet.pl!newsgate.onet.pl!newsgate.pl From: Jarosław Zielewski <jaroslawzielewski@systemy-mobilne.pl> Newsgroups: pl.comp.lang.delphi.bazy-danych Subject: Re: pole zawieraj±cedatê Date: 30 Jun 2007 16:10:31 +0200 Organization: F.U.H NetSoft Lines: 28 Message-ID: <96211870.20070630161004@systemy-mobilne.pl> References: <0b55.000000b2.46866017@newsgate.onet.pl> Reply-To: Jarosław Zielewski <jaroslawzielewski@systemy-mobilne.pl> NNTP-Posting-Host: newsgate.onet.pl Mime-Version: 1.0 X-Trace: newsgate.test.onet.pl 1183212631 13279 213.180.130.18 (30 Jun 2007 14:10:31 GMT) X-Complaints-To: abuse@onet.pl NNTP-Posting-Date: 30 Jun 2007 14:10:31 GMT X-Mailer: The Bat! (v3.99) X-Received: (root@newsgate.test.onet.pl) by newsgate.test.onet.pl id <S118005AbXF3OKV>; Sat, 30 Jun 2007 16:10:21 +0200 X-Received: from wenus.az.pl ([62.146.68.7]:2027 "EHLO wenus.az.pl") by newsgate.test.onet.pl with ESMTP id <S118241AbXF3OKE>; Sat, 30 Jun 2007 16:10:04 +0200 X-Received: from xdsl-4026.bielsko.dialog.net.pl ([84.40.216.186] helo=JZIELEWSKI) by wenus.az.pl with esmtpa (Exim 4.67) (envelope-from <jaroslawzielewski@systemy-mobilne.pl>) id 1I4deA-0003CO-GX for pl-comp-lang-delphi-bazy-danych@newsgate.pl; Sat, 30 Jun 2007 16:09:58 +0200 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit