Hi,
How do I make a construct in LLBL that generates the same as this example SQL:
INSERT INTO document (idt1)
SELECT idt2
FROM template
WHERE templateid = 1
I would like to do this without fetching any data, as I am working with SQL Server 2000 image data type, which would be idt1 and idt2 above. Also, I would like to have the newly created id from document returned to me (automatically created identity column) to insert into a third table for reference.
EDIT: Forgot to state that I am using an adapter scenario, and using v2 of LLBL.
I am looking forward to hearing from you...
