Savitha S
August 16th, 2001, 02:36 AM
I need some help on calling a user defined function written in vb,in sql through ADO.
I have written a function call removezipcode() in vb.
I need to call this in a batch update statement.
eg.
adoconnect.execute "update table1 set column1=removezipcode(column1)"
It is not recognizing the removezipcode() function.
I have written a function call removezipcode() in vb.
I need to call this in a batch update statement.
eg.
adoconnect.execute "update table1 set column1=removezipcode(column1)"
It is not recognizing the removezipcode() function.