Studio 2005 & DataDirect & ASP.net FormView

K

kirvine

New Member
I am trying create an ASP.net page using a formview connected to a Progress backend database through the DataDirect ODBC Driver. All of this is 10.1B. Everything works great with the SELECT statement but I am unable to form an UPDATE statement that DataDirect likes. I have bound my fields to the DB as indicated in the help in VS 2005 but the DataDirect driver does not like the "@" symbol in the "SET name=@name" parameter reference. Am I missing something or is this a problem with the DataDirect driver.
 
Never mind... we figured it out. The sql statement must consist of parameters that are represented by a "?" (i.e. UPDATE PUB.ApplicationUser SET fld1name = ?, fld2name = ? WHERE (keyfldname = keyfldname)).

One then adds parameters to the Update query parameter list corresponding to the field names.

<UpdateParameters>
<asp:ParameterName="fld1name"/>
<asp:ParameterName="fld2name"/>
</UpdateParameters>

Please remember that the field themselves must be bound to the individual control on the formview to establish that relationship at that level.
 
You must log in or register to reply here.
Back
Top