05-10-2010, 18:38
Asagidaki Ekleme ve Silme sorgularini VB de nasil yazarim
INSERT INTO TblMaliKart ( Print, Islem, HesapKodu, HesapAciklama, Borc, Alacak, Bakiye, HesapNo, AHesapNo, DHesapNo, CHNo, InKaNo, TakipNo )
SELECT Print, Islem, HesapKodu, HesapAciklama, Borc, Alacak, Bakiye, HesapNo, AHesapNo, DHesapNo, CHNo, InKaNo, TakipNo
FROM 01Kart0000
WHERE (((HesapNo) Like [Forms]![SysFilitre]![HesapNo]) AND ((AHesapNo) Like [Forms]![SysFilitre]![KirilimNo]));
DELETE *
FROM TblMaliKart;
INSERT INTO TblMaliKart ( Print, Islem, HesapKodu, HesapAciklama, Borc, Alacak, Bakiye, HesapNo, AHesapNo, DHesapNo, CHNo, InKaNo, TakipNo )
SELECT Print, Islem, HesapKodu, HesapAciklama, Borc, Alacak, Bakiye, HesapNo, AHesapNo, DHesapNo, CHNo, InKaNo, TakipNo
FROM 01Kart0000
WHERE (((HesapNo) Like [Forms]![SysFilitre]![HesapNo]) AND ((AHesapNo) Like [Forms]![SysFilitre]![KirilimNo]));
DELETE *
FROM TblMaliKart;

