Arsip: Help.....SQLDataSet..!!!

more 15 years ago
coacoac
Salam Kenal smua..aq masih baru belajar SQL n Delphi....
gini mas, saya pakek listing dibawah ini..tapi
begin
SQLDataSet1.Active := False;
SQLDataSet1.CommandText :=
'Select * From pribadi where ID_Number = ' + EditID_Number.Text;
SQLDataSet1.Active := True;
if SQLDataSet1.RecordCount < 1 Then
begin
.
.
end;
end;
kenapa ya mas...dgn listing diatas, klo saya masukkan nilai yang salah dia bisa baca, tp klo saya masukkan nilai yang ada dlm database dia dak mau katanya gini.
.: (Unknown column UM3011140502' in 'where clause''.) :.
tolong bantuanya ya mas...saya masih baru belajar MySQL n Delphi.
sebelumnya terima kasih..
plizzzzz help meee :?: :?: :?:

more 15 years ago
_lmz
@coacoac: Salam Kenal smua..aq masih baru belajar SQL n Delphi.... gini mas, saya pakek listing dibawah ini..tapi begin SQLDataSet1.Active := False; SQLDataSet1.CommandText := 'Select From pribadi where ID_Number = ' + EditID_Number.Text; SQLDataSet1.Active := True; if SQLDataSet1.RecordCount < 1 Then begin . . end; end; kenapa ya mas...dgn listing diatas, klo saya masukkan nilai yang salah dia bisa baca, tp klo saya masukkan nilai yang ada dlm database dia dak mau katanya gini. .: (Unknown column UM3011140502' in 'where clause''.) :. tolong bantuanya ya mas...saya masih baru belajar MySQL n Delphi. sebelumnya terima kasih.. plizzzzz help meee :?: :?: :?:Soal ujian nasional -- Delphi + MySQL: Apabila field yang hendak dicari isinya UM3011140502 Kalau misalnya anda memasukkan dari mysql command line client, mana yang benar? Select From pribadi where ID_Number = UM3011140502 atau Select * From pribadi where ID_Number = 'UM3011140502' Untuk bonus point, error apa yang muncul di kasus pertama?

more 15 years ago
Kecret
:idea: Hmmmmm jawabannya yg mana ya ?........ :cry:
begin
SQLDataSet1.Active := False;
SQLDataSet1.CommandText := 'Select * From pribadi where ID_Number = ' + QuotedStr(EditID_Number.Text);
SQLDataSet1.Active := True;

more 15 years ago
coacoac
Trim's to mas lmz atas pertanyaan ulangnya n buat mas Kecret atas solusinya..
thank's be for
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
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 10 years ago - ada yang tau cara ada berapa minggu dalam bulan
by alvonz in OOT more 14 years ago - 2 query di satu report
by d4mnf1y32 in MySQL more 11 years ago - mau tanya delphi prism xe sama delphi xe
by alvonz in OOT more 12 years ago - sorting ganti nomor perbulan
by aienhe in Hal umum tentang Pascal Indonesia more 13 years ago - [ask] Mencari letak error list index out of bound
by kepiss in Tip n Trik Pemrograman more 11 years ago - Foto Development team Delphi2010
by abichoy in OOT more 13 years ago - Penulisan Skrip SQL
by delphy in Enginering more 17 years ago - Ada yang punya tutorial rave report ga? or bantu saya quick
by inside in Tutorial & Community Project more 16 years ago - formatdate
by ags606 in Hal umum tentang Pascal Indonesia more 16 years ago