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

more 13 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 13 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 13 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 13 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
- Project Group dalam Lazarus
- FastPlaz Database Explorer
- Release: FastPlaz Super Mom v0.12.22
- PascalClass #3: Web Development with Free Pascal
- Makna Pascal di Pascal Indonesia
- Kulgram : Instalasi Lazarus di Perangkat Berbasis ARM
- PascalClass #1: Analisa Database dan Machine Learning
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
- Mengenal OXYGENE – Pascal For .NET
- PascalTalk #5: UX: Research, Design and Engineer
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 3 months ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 months ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 months ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 1 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 8 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 8 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 8 years ago
Random Topic
- tlg ksih tau cara save page delphi......
by neosite in Lain-lain more 9 years ago - LEBARAN SEBENTAR LAGI
by indobrainsoft in OOT more 13 years ago - Konvesi String ke PAnsiChar
by areksby in MySQL more 14 years ago - minta component
by p_RullyPratama in Hal umum tentang Pascal Indonesia more 12 years ago - Mainmenu & toolbar
by sandy in Hal umum tentang Pascal Indonesia more 10 years ago - translate MoveMemory 'kernel32' VB ke Delphi
by esafm in Tip n Trik Pemrograman more 11 years ago - handshaking
by ihsantea in Enginering more 13 years ago - format 4digit
by dinox in Tip n Trik Pemrograman more 14 years ago - Apakah benar...???
by imunk in OOT more 12 years ago - Firebird Vs Mysqlcc
by kiki-Delphi in FireBird more 12 years ago