Arsip: Insert Data ke MySQL

more 16 years ago
coacoac
para master2 delphi..aq tanya gmn agar data 'Pengisian=5000' selalu ditambah dg data yang baru (Data lama + Data Baru), jadi setiap saya klik BitBtnSimpan, datanya selalu bertambah 5000, gtu..listing programq kayak gini, mb da yg hrs dirubah, coz pada saat data sudah kesimpan pada database,dia tdk mau nambah lagi.(Error);
procedure TFormPulsa.BitBtnSimpanClick(Sender: TObject);
var
PernyataanSQL : String;
begin
if RadioButtonLima.Checked then
begin
PernyataanSQL :=
'insert into pulsa set Pengisian = 5000, No_Kendaraan = ' + QuotedStr(EditNo_Kendaraan.Text);
SQLConnectionPulsa.ExecuteDirect(PernyataanSQL);
end;
end;
Normalisasinya :
Tabel : Pulsa
-----------------
No_Kendaraan (primary key)
Pengisian
more 16 years ago
budi_bunga
kayaknya klo insert ito pake into ...
kalo pake set itu update ... set .....

more 16 years ago
faathir
mei bi (mungkin/meureun) gini....
procedure TFormPulsa.BitBtnSimpanClick(Sender: TObject);
var
PernyataanSQL : String;
begin
if RadioButtonLima.Checked then
begin
PernyataanSQL :=
'insert into pulsa (Pengisian, No_kendaraan) values (5000, QuotedStr(EditNo_Kendaraan.Text))';
SQLConnectionPulsa.ExecuteDirect(PernyataanSQL);
end;
end;
mungkin...more ...
- Pages:
- 1
reply |
Report Obsolete
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 3 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 3 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 4 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 11 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 11 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 11 years ago
Random Topic
- Ada yang pernah bikin Program MD5...???
by safarian in Tip n Trik Pemrograman more 16 years ago - Banyak tanya
by Edwin2006 in Hal umum tentang Pascal Indonesia more 17 years ago - auto inc mysql
by adhisyanda in MySQL more 14 years ago - Penggunaan Procedure dan variabel
by rusli_chow in Tip n Trik Pemrograman more 16 years ago - 4 pertanyaan lagi mbah...
by kodok_bancret in Form Enhancement & Graphical Controls more 16 years ago - Format tanggal hasil eksport data tidak sesuai keinginan
by sdayat in Paradox more 11 years ago - syntax query
by m3llo in Tip n Trik Pemrograman more 16 years ago - format dollar di delphi
by maulaku in Hal umum tentang Pascal Indonesia more 16 years ago - Export to Ms.Word
by bboyz in Hal umum tentang Pascal Indonesia more 16 years ago - Menampilkan image captcha di Twebbrowser
by kusqus in Web Programming more 14 years ago