Arsip: [ask]menampilkan data dari dua table dalam satu from

more 11 years ago
kepiss
temen-temen saya lagi belajar delphi ne..mohon pertolongan
procedure TFpotongan.EnipChange(Sender: TObject);
var
query: string;
begin
with dm.querypegawai do
with dm.queryjabatan do
begin
close;
sql.Clear;
sql.Add('select * from pegawai,jabatan where pegawai.nip=jabatan.nip=:kd ');
parameters.ParamByName('kd').Value:=(enip.Text);
dm.querypegawai.Open;
if not eof then
enama.Text:=fieldbyname('nama_pegawai').AsString;
ekantor.Text:=fieldbyname('kantor').AsString;
ejabatan.Text:=fieldbyname('jabatan').AsString;
dengan code diatas ane mau nampilin data daritable pegawai dan jabatan dengan memasukan NIP pegawai di Tedit...gak ada errornya tapi kok datanya gak mau muncul ya....semoga ada yang bisa bantu saya..amien..

more 11 years ago
madi
coba dulu ya siapa tahu ada yg salah :D
[sql] with ADOQuery1 do
begin
close;
SQL.Text := 'SELECT A.NAMA_PEGAWAI,B.JABATAN,A.KANTOR FROM PEGAWAI A, JABATAN B '+
' WHERE A.NIP = B.NIP AND A.NIP = '+ QuotedStr(enip.text) + ' AND B.NIP = '+
QuotedStr(enip.text);
open;
end;
enama.Text:=fieldbyname('nama_pegawai').AsString;
ekantor.Text:=fieldbyname('kantor').AsString;
ejabatan.Text:=fieldbyname('jabatan').AsString;[/sql]

more 11 years ago
ihfan_wa2w
koreksi sedikit sql nya, coba begini:
select p.nip,p.nama,j.jabatan from pegawai p,jabatan j where p.nip=j.nip and p.nip=:nip
semoga membantu.
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
- masalah ZEOSDBO-6.6.2, Mysql 5.0.41, dan Delphi 2006
by hendra_sir84 in MySQL more 15 years ago - copy file dengan parameter date modified
by jagur in Tip n Trik Pemrograman more 16 years ago - penambahan data pada grid
by ru_kd in Tip n Trik Pemrograman more 14 years ago - cara dapetin fastreport yg nggak trial
by lekdi in Hal umum tentang Pascal Indonesia more 16 years ago - Print Lebar dg Printer LQ2180 di QuickReport Delphi 7
by archvile in Reporting more 14 years ago - tolong donk algoritma permutasi dan substitusi
by woko in Tip n Trik Pemrograman more 14 years ago - Sidik Jari
by reminder2k1 in Reporting more 15 years ago - Ada yang pernah coba Zeos + SQLite3 + Delphi 2010?
by mambamaestro in Hal umum tentang Pascal Indonesia more 12 years ago - Ubah Printer Default di Quick Report
by yoga_gtg in Tip n Trik Pemrograman more 14 years ago - mengenali karakter dalam gambar
by tita in Hal umum tentang Pascal Indonesia more 14 years ago