Arsip: [Ask]User login ID and password

more 10 years ago
vahnkrist
procedure TForm1.Button1Click(Sender: TObject);
var a,b : String;
begin
with dm.qData do
begin
close;
Sql.Clear;
a := Sql.Add('Select userid from Identitas');
b := Sql.Add('Select pass from Identitas');
open;
if (a = Edit1.text) and (b = Edit2.Text)
then
Label3.Caption := 'OK' ;// buat tes doang kalo konek dan sama seperti di tabeldbase brarti "OK"
end;
end;
sori mau nanya lagi kk2...adakah yang salah dengan koding di atas ^
a := IntToStr(Sql.Add('Select userid from Identitas'));
b := IntToStr(Sql.Add('Select pass from Identitas'));
kalo a ama b yang di koding pertama diganti kek diatas ini ^ , bisa ngerun tapi
Dynamic SQL eror
SQL error code = -104
Token unknown - line 2,char-1
Select.
merasa ada yang aneh...ada saran atau pemecahan kk2???
more 10 years ago
cartrun
coba gini z gan.
procedure TForm1.Button1Click(Sender: TObject);
var a,b : String;
begin
with dm.qData do
begin
SQL.Clear;
SQL.Text:= 'Select * From Identitas Where userid = ' + QuotedStr(Edit1.Text);
Close;
Open;
end;
if dm.qData.RecordCount = 0 then
begin
ShowMessage('User tidak terdaftar');
Edit1.SetFocus;
end
else
if (dm.qData.RecordCount >= 1) and (dm.qData.FieldbyName('pass').AsString <> Edit2.Text) then
begin
ShowMessage('Password salah');
Edit2.SetFocus;
end
else
begin
Hide;
Form.Show;
end;
end;

more 10 years ago
cartrun
@vahnkrist: thanks kak.... diganti "=" tapi yg <> nya.... :D :Dsep dah klau udh jalan. silahkn ganti" juga gpp. kn logika itu berbeda" yg pnting tujuannya sama. good luck.!
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
- Mohon Pencerahan.............
by yuan_carlos in Hal umum tentang Pascal Indonesia more 16 years ago - Parsing variabel dalam prosedur onclick
by emrizq in Tip n Trik Pemrograman more 13 years ago - Indahnya Quick Report :: Sample Program
by Tbawor in Free dan Gratis more 16 years ago - [release] PooLander!
by ZeAL in Games more 17 years ago - update memo
by nurez in Hal umum tentang Pascal Indonesia more 15 years ago - ada yang punya decopiler buat delphi??
by alvonz in OOT more 13 years ago - ngeblock aplikasi laen
by doniking in Network, Files, I/O & System more 15 years ago - Icon berubah saat di klik
by felly in Kritik & Saran more 14 years ago - statement tidak mau memilah insert dan edit
by bandit88 in Enginering more 14 years ago - Gimana cara koneksi Sql server pake BDE
by dody in Paradox more 14 years ago