2. ASPRunnerPro General questions
  3. Truncate table before import
This topic is locked

Truncate table before import

 		2/8/2010 9:55:32 AM
ASPRunnerPro General questions
W
 wisdom2009 author

Hi,

I have ASPRunner6.2 abnd i would like to to truncate access table before import how can i do that using Event?
Thank you
Sergey Kornilov admin 2/8/2010

In ASPRunnerPro 6.2 you can use BeforeImportStarted event for this purpose.
W
 		wisdom2009 author 2/8/2010

I did add on the event the following syntax "TRUNCATE tblText" but it did not work
Sergey Kornilov admin 2/8/2010

dbConnection.Execute "delete from tblText"
W
 		wisdom2009 author 2/9/2010



dbConnection.Execute "delete from tblText"


tried it and did not work
Sergey Kornilov admin 2/9/2010

Well, the code is too simple to be wrong.
You can post your app to Demo Account and contact support team directly sending your application URL.
W
 		wisdom2009 author 2/9/2010



Well, the code is too simple to be wrong.
You can post your app to Demo Account and contact support team directly sending your application URL.


Please find below the app
My link

Thank you
Sergey Kornilov admin 2/9/2010

You need to open your ticket via http://support.xlinesoft.com. Thank you.