2. ASPRunnerPro General questions
  3. Issue with DAL update
This topic is locked

Issue with DAL update

 		11/13/2010 1:29:16 AM
ASPRunnerPro General questions
W
 waynes888 author

Found a strange issue with DAL update trying to do an update on table for 2 fields of different types, the one field is an integer, while the other is a text field. If I try update them together, neither updates. If I update either one, it works for that one. Even if I seperated them into 2 different updates if still failed to update. Can't figure out why and spend 2 hours trying to get it to work and eventually gave up and created a custom query that worked without issue.
This is the query

emailSend = 2

smResult = "Success"

set dal_table=dal.Table("emails")

dal_table.Param("id") = keys("id")

dal_table.email_type_id_FK = emailSend 'interger

dal_table.send_result = smResult 'text

dal_table.Update()


In this case both fields to update & there was no error message
If I did:



set dal_table=dal.Table("emails")

dal_table.Param("id") = keys("id")

dal_table.email_type_id_FK = emailSend

dal_table.Update()
set dal_table1=dal.Table("emails")

dal_table1.Param("id") = keys("id")

dal_table1.send_result = smResult

dal_table1.Update()


Same result, neither updated & no error message. If I removed either of the update, the remaining update worked!
Is this an issue? If haven't tried with like fields - was frustrating enough trying to get this to work!
Sergey Kornilov admin 11/13/2010

I would suggest to try the recomnded way to update fields first i.e. to use dal_table1.Values("send_result") = smResult instead of dal_table1.send_result = smResult.
If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.
W
 		waynes888 author 11/14/2010



I would suggest to try the recomnded way to update fields first i.e. to use dal_table1.Values("send_result") = smResult instead of dal_table1.send_result = smResult.
If this doesn't help post your application to Demo Account and open a ticket at http://support.xlinesoft.com sending your Demo Account URL. 'Demo Account' button can be found on the last screen in the program.


Yes, I tried that method as well & it didn't work. Will upload to the demo account soon - just building up a list of issues so they can all be resolved at once.