Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Script to insert is generated with wrong values

3 views
Skip to first unread message

Alfredo Becerril

unread,
Nov 17, 2010, 12:40:09 PM11/17/10
to
I am trying to develop with sdk (vbtools) a screen to mantain vendor
contacts

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', '', '')

0 new messages