insert record into form table

[citrusstyle]

livelink 9.7.1 with forms 9.7.1, web forms 9.7.2, adn 3.2.0


i have a form template with 2 adn table key lookups. these attributes perform lookups against a table within the livelink schema.

'vendor name' and 'vendor number' correspond with each other. they are each columns contained within the same table.


when selecting 'vendor name' from the lookup, it populates 'vendor name' AND 'vendor number'
....and vice versa,
when selecting vendor number from the lookup, it populates 'vendor number' AND 'vendor name'


question:
i'd like build in the option to ADD a value to the table if it does not exist in the lookup. if 'vendor name' or 'vendor number' don't exist, give the user the option to enter both and store in the table for future use.


what approach would you take? i was thinking about using web forms to perform an INSERT. is this possible?

thanks for your help!

 

[appnair]

yes so long as you create your statement correctly by which I mean do not send from the client a fully formed sentence like this
insert into my table values(2,3,4).Look in builder how inserts are done from a user gui.If you could have created this table using the form sql option Livelink would have given you that option.You would just have some ajax/javascript to call the OT reqhandler and come back to that screen.Create your own req handler and read up on how to avaoid sql injection and use bind vars whenever possible

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair