Pada tanggal 1/15/2003, Herman kirim e-mail
ke Delphindo
Saya coba buat aplikasi master detail dengan query, tapi kok
muncul error spt ini :
"Index or primary key cannot contain a NULL", berarti primary
key tidak boleh kosong, tapi saya liat di detail databasenya
tidak kosong, tapi kok muncul error spt. itu.
source code di detailnya
procedure TDataModule2.ADOQuery1NewRecord(DataSet: TDataSet);
begin
ADOQuery1TANGGAL.Value:=Date;
end;
procedure TDataModule2.ADOQuery2NewRecord(DataSet: TDataSet);
begin
ADOQuery2QTY.Value:=1;
end;
procedure TDataModule2.ADOQuery2CalcFields(DataSet: TDataSet);
begin
ADOQuery2TOTAL.Value:=ADOQuery2HARGA.Value*ADOQuery2QTY.Value;
end;
procedure TDataModule2.ADOQuery2KDBRGChange(Sender: TField);
var
rsJual : TADOQuery;
begin
rsJual:=TADOQuery.Create(Self);
with rsJual do
begin
Connection:=ADOConnection1;
SQl.Clear;
SQL.Text:='SELECT NMBRG, HARGA FROM tbBARANG '+
'WHERE KDBRG=:KDBRG;';
Parameters.ParamByName('KDBRG').Value:=ADOQuery2KDBRG.Value;
Open;
ADOQuery2NMBRG.Value:=rsJual.Fields[0].AsString;
ADOQuery2HARGA.Value:=rsJual.Fields[1].AsCurrency;
end;
end;
Nb: kalo saya aksesnya lewat bde, tidak terjadi error
---------------------
Herman Setiawan Jaya
=-=-=-=-=-=-=-=-=-=-=
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Flexible Keyboard is the ideal accessory for PDA users that are on the move.
http://us.click.yahoo.com/dCBVZC/WnCFAA/xGHJAA/i7folB/TM
---------------------------------------------------------------------~->
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
