Hi,
I'm using formdetails to add/update data.
On one page, it is working fine, on another I keep getting the error 1036 (ORA-01036: illegal variable name/number) when I try to update a record.
I've taken the update statement down to as basic a statement as possible in order to identify the problem and have used sqlmonitor to see what is being passed to Oracle.
Below is what I get in the trace.
I just don't see what the problem can be.
sam_account_name is varchar(30)
--------------------------
---------
Timestamp: 09:18:53.816
UPDATE t_users SET sam_account_name = :sam_account_name WHERE sam_account_name = :sam_account_name
sam_account_name = 'm'
Execution time: 0 ms
Runtime error occurred: 1036 (ORA-01036: illegal variable name/number)
--------------------------
---------
this is the asp definition
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="Compare
AllValues"
ConnectionString="<%$ ConnectionStrings:Tempus %>" DeleteCommand="DELETE FROM t_users WHERE user_id = :original_user_id "
InsertCommand="INSERT INTO t_users (user_id, sam_account_name, username, department_id, company_id, role_id) VALUES (seq_t_users.nextval, :sam_account_name, :username, :department_id, :company_id, :role_id)"
OldValuesParameterFormatSt
ring="orig
inal_{0}" SelectCommand="SELECT * FROM t_users"
UpdateCommand="UPDATE t_users SET sam_account_name = :sam_account_name WHERE sam_account_name = :sam_account_name "
ProviderName="<%$ ConnectionStrings:Tempus.P
roviderNam
e %>">
<DeleteParameters>
<asp:Parameter Name="original_user_id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="sam_account_name" />
<asp:Parameter Name="username" />
<asp:Parameter Name="department_id" />
<asp:Parameter Name="company_id" />
<asp:Parameter Name="role_id" />
<asp:Parameter Name="original_user_id" Type="Int32" />
<asp:ProfileParameter Name="userID" PropertyName="userID" Type="Decimal" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="sam_account_name" Type="Empty" />
<asp:Parameter Name="username" Type="Empty" />
<asp:Parameter Name="department_id" Type="Empty" />
<asp:Parameter Name="company_id" Type="Empty" />
<asp:Parameter Name="role_id" Type="Empty" />
<asp:ProfileParameter Name="userID" PropertyName="userID" Type="Decimal" />
</InsertParameters>
</asp:SqlDataSource>
thx
Graham