Arsip: Insert Data ke MySQL

more 15 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 15 years ago
budi_bunga
kayaknya klo insert ito pake into ...
kalo pake set itu update ... set .....

more 15 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 2 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 2 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 2 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 3 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 10 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 10 years ago
Random Topic
- isi data di dbgrid bisa Multiline
by wati in Tip n Trik Pemrograman more 10 years ago - Kelipatan waktu..
by anak_s0leh in Tip n Trik Pemrograman more 14 years ago - Biaya pemakaian
by pilot in Hal umum tentang Pascal Indonesia more 15 years ago - Convert Color
by 3m8ooo in Hal umum tentang Pascal Indonesia more 14 years ago - password tidak berfungsi
by divanda in Hal umum tentang Pascal Indonesia more 15 years ago - capture image dengan web cam
by andry_yang in Hal umum tentang Pascal Indonesia more 13 years ago - Soal TAdoTable... share dikit....
by juan81 in Hal umum tentang Pascal Indonesia more 15 years ago - "Raja Sakti" game online ala Indonesia - 100% Delp
by vendetta in Free dan Gratis more 15 years ago - Nanya File dalam File
by Hadoitz in Tutorial & Community Project more 14 years ago - DLL ?
by budi_bunga in Tip n Trik Pemrograman more 16 years ago