I am using DetailsView with AccessDataSource control to insert record based on user's input. VWD generates INSERT command like this
Insert Into [table] (fld1, fld2, fld3) VALUES (?, ?, ?)
Everything works fine except in the case where one of the values is not user input but a constant provided by the program. Say, it is stored in variable varXYZ. When I change command to say
Insert Into [table] (fld1, fld2, fld3) VALUES (varXYZ, ?, ?)
I am getting an error.
I would really appreciate help with this...

What is the error? Are you sure that the constant is a valid value? If it is a string are you wrapping it in singles quotes?

J

In my case fld1 is Int32. So I tried both
Insert Into [table] (fld1, fld2, fld3) VALUES (130, ?, ?)
and
Insert Into [table] (fld1, fld2, fld3) VALUES ('130', ?, ?)
In both cases I get an error like 'Input string is not in the correct format'.
In reality I do not even know that the value I need to insert is 130, all I know is that it is stored in Session("account_id"). How do I modify Insert command, or can I?

Thanks

This is kinda similar to what I was wondering. I have a Form View that has a couple of text boxes and that allow me to add my web site news. the thing I want to do is set the current dat to a variable and save that in the database as well as the data that I entered in the text boxes. The original post is a few months old so it doesn't look like there was ever an answer given ..

I know in classic asp you made your inserts like such

set rsSaveData = conn.execute("Insert into table set Field1 = '"&Request("FormField1")&"', Field2 = '"&Request("FormField2")&"', DateField = '"&ValueFromVariable&"'")

basiacally I want to acomplish the same thing in .Net

Thanks

anyone have any ideas??

Dean Forant

Programmer
Delta Mechanical Seals
44 Probber Lane
Fall River, MA. 02720
(508)324-4032 Ext 118