2. ASPRunnerPro General questions
  3. dal UPDATE error
This topic is locked

dal UPDATE error

 		7/4/2009 5:57:04 PM
ASPRunnerPro General questions
C
 crisstyd author

I have a form that updates another tables fields when submitted. Tables are joined.
Using the following code..... it does update the field in the second table, but does not add the form/record to the current table.
dal.training.AA=dict("AA")

dal.training.LAST_WORK=dict("LAST_WORK")

dal.training.Update()
BeforeAdd = True
I get error 424 - object required
Any suggestions as to why it will update the field in the other table but not insert the record in the current table?
Sergey Kornilov admin 7/4/2009

Make sure Training table is included into the project. DAL is only generated for tables that belong to the project.
If this doesn't help post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.
C
 		crisstyd author 7/5/2009

Make sure Training table is included into the project. DAL is only generated for tables that belong to the project.

If this doesn't help post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.


Sergey,
Both tables are in the project. It with either allow you to add the form/ or update the training table (but gives and error at the same time)... but it will not do both.
Are there any other items I need to add to the "dal" code to make it work?
J
 		Jane 7/6/2009

Hi,
please post your application to Demo Account (use 'Demo Account' button on the last screen in program). Then open a ticket at http://support.xlinesoft.com sending your Demo Account URL for investigation.