This topic is locked

Reset Query Issue

8/18/2009 4:35:40 PM
ASPRunnerPro General questions
M
mfred author

While designing an application in ASPRunner 6.1, I realized that I needed to add a field to a table. So I closed out of ASPRunner, added the field to the Access table. Then I reopened the ASPRunner 6.1 file. I expected to be able to reset the query in the query designer to show the new field, as is done in 6.0. But the reset does not work. I tried to enter the field manually in the SQL tab but the field is not recognized. When I click out of the table, I get an error message that says "Cannot retreive columns information. Please modify SQL query and try again. Then the message has a long string of information that says "SQL Error State: 07002, Native Error Code: FFFF43E, ODBC Error: [Microsoft][OBDC Microsoft Access Driver] Too few parameters. Expected 1. When I query the same table in 6.0, Everything works fine. So it appears to be a reset issue specific to 6.1.

Sergey Kornilov admin 8/18/2009

Try to synchronize your database first. For this purpose right click on your database on 'Datasource tables' screen and choose 'Synchronize'.

M
mfred author 8/19/2009

Thanks, that worked.