Re: Parametry TUpdateSQL

Article View: pl.comp.lang.delphi.bazy-danych

Article #58

Back to pl.comp.lang.delphi.bazy-danych Previous Next

#58

From: Marcin Sulecki
Date: Thu, 15 Apr 1999 09:33

20 lines
1395 bytes

Przekazywanie parametrow do TUpdateSQL.

1. Laczymy komponent TQuery z TUpdateSQL
wlasciwosc: UpdateObject

2. tworzymy zapytania w  TUpdateSQL
dla wstawiania, modyfikacji i kasowania

3. Wywolujemy w kodzie:
     with DataModule1.UpdateSQL1 do
     begin
       Query[ukInsert].ParamByName('id').AsInteger:=1;
       Query[ukInsert].ParamByName('name').AsString:='Test';
       ExecSql(ukInsert);
     end;
podobnie ukDelete, ukModify

pamietac nalezy o wlaczeniu modulu DB

Powodzenia!

Technical Details

Message-ID: <3715B267.25F765B1@irc.pl>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!agh.edu.pl!polsl.gliwice.pl!news.man.poznan.pl!news.task.gda.pl!not-for-mail

References:

<37006FAA.6B30FB05@irc.pl> <7dqsgm$23j$1@zeus.polsl.gliwice.pl> <3709D3BA.BC164CC5@irc.pl> <01be81d6$6dfaf3e0$037f8080@modem>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!pingwin.icm.edu.pl!agh.edu.pl!polsl.gliwice.pl!news.man.poznan.pl!news.task.gda.pl!not-for-mail
From: Marcin Sulecki <sunio@irc.pl>
Newsgroups: pl.comp.lang.delphi.bazy-danych
Subject: Re: Parametry TUpdateSQL
Date: Thu, 15 Apr 1999 11:33:27 +0200
Organization: CI TASK http://news.task.gda.pl/
Lines: 22
Message-ID: <3715B267.25F765B1@irc.pl>
References: <37006FAA.6B30FB05@irc.pl> <7dqsgm$23j$1@zeus.polsl.gliwice.pl> <3709D3BA.BC164CC5@irc.pl> <01be81d6$6dfaf3e0$037f8080@modem>
NNTP-Posting-Host: marcins.telmax.com.pl
Mime-Version: 1.0
X-Trace: korweta.task.gda.pl 924168676 3905 195.116.10.89 (15 Apr 1999 09:31:16 GMT)
X-Complaints-To: abuse@task.gda.pl
NNTP-Posting-Date: 15 Apr 1999 09:31:16 GMT
X-Mailer: Mozilla 4.5 [pl] (Win98; I)
X-Accept-Language: pl
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Reply to Parent Message