Connecting Tech Pros Worldwide Forums | Help | Site Map

Store Procedure - Dynamic Insert

Newbie
 
Join Date: Nov 2006
Location: Madrid, Spain
Posts: 23
#1: Aug 14 '07
Hello:

I've a form with 100 fields and I created 4 tables in my sql server for that form.
Now, I want to create an store procedure to insert in all fields in differents tables. But I dont want to define the statments for each field. I want something like ADO recordset.

Somebody have an complete example for that. Or any tutorial?

I really appreciate it

thank you
NIKO

ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,925
#2: Aug 15 '07

re: Store Procedure - Dynamic Insert


Quote:

Originally Posted by nkoriginal

Hello:

I've a form with 100 fields and I created 4 tables in my sql server for that form.
Now, I want to create an store procedure to insert in all fields in differents tables. But I dont want to define the statments for each field. I want something like ADO recordset.

Somebody have an complete example for that. Or any tutorial?

I really appreciate it

thank you
NIKO

build your query as a string in your form...submit the entire string as an sql-query
Reply