Click here to Skip to main content
13,355,335 members (69,956 online)

store SQL query in database when I use parameter

Revision 4
can anyone help me how I can store SQL query (statement as log) in database when I use parameter to execute a query?...

My prefer language =

for example :
sql = "insert into model (name, age, date_of_confinement,type_of_sickness, type_of_IVfluid, number_of_bottles, drop_rate)" & _
                   " values (@name, @age, @dateOfConfinement, @sicknessType, @fluidType, @bottleAmount, @dropRate)"

I want to store SQL with entered values, but it stores the same as above code

Thanks in advance
Posted 1-Oct-12 23:55pm by sali22.
Tags: , ,
  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.180111.1 | Last Updated 5 Nov 2009
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid