but when I try to save the vendor contact for the vendor number 00001
instead
insert vendcontact
(addr1,addr2,emailaddr,vendid,vendcontactid,name,type) values( '',
'', '', '00001', '2', '', '')
is generating
insert vendcontact
(addr1,addr2,emailaddr,vendid,vendcontactid,name,type) values( '',
'', '', '_ 00001', '2', '', '')
why is generating '_ 00001' instead only '00001'
I perform another test with custContact and I noticed something
different
the following scripts are generated when I update a field
(CustContact)
update custcontact set addr1=addr1 where custid= '00001' and
contactid= '333' and tstamp <= 0x0000000219be3d0d
update custcontact set name= '22222' where custid= '00001' and
contactid= '333'
but when I want to know what VendContact is doing these are the
scripts generated on update.
update vendcontact set addr1=addr1 where vendid= '00001' and
vendcontactid= '445555' and tstamp <= 0x0000000219be3d81
delete vendcontact where vendid= '00001' and vendcontactid= '445555'
insert vendcontact
(addr1,addr2,emailaddr,vendid,vendcontactid,name,type) values( '',
'', '', '_0001', '12345', '', '')