Insert Stored Procedure taking values from vb Help
-
I have Created a Procedure , i need to intergrate it with vb6, i know that one. i want to insert these fields into Property table and some of them i want to set them here in the Procedure, help to do that and assigning the value of textbox's in vb6 to the variable in a this Procedure. e.g num_key= txtnumkey. Here is my procedure but i did not finish it because of that part. Create Procedure prcinserting @Num_key varchar(10),@Extension int,@Cell_ID int, @Actual_Extent float,@Lis_key varchar(50), @Func_key varchar(8) ,@Active bit,@Add_date datetime,@Add_User_ID int,@Spatial_ADD_Date datetime ,@Rateable bit,Non_Discreet_Valid bit with recompile insert into Propery(Num_key,Extension,Cell_ID,Actual_Extent,Lis_key,Func_key,Active,Add_date,Add_User_ID,Spatial_ADD_Date,Rateable,Non_Discreet_Valid,) values ()
Vuyiswa