Getting Started with dBASE - emptytable error

Author

emptytable error

Michel

2006-10-25, 7:23 am

Hello,

I use a temporary table for a report, and I need to empty it before creating the report.
So, I wrote the following code :

form.testdatamodule1.michel1.emptytable("devisprt")

and when running I always receive the following error message : "In use by another" without understanding why !

thanks for help
Michel

Todd Kreuter [dBVIPS]

2006-10-25, 7:23 am

"Michel" <mgomet@brutele.be> wrote in message
news:K3D5ti45GHA.1012@news-server...
>
> form.testdatamodule1.michel1.emptytable("devisprt")
>
> and when running I always receive the following error message : "In use by
another" without understanding why !

The table would be open when you instantiate the report and you need to
empty it before it opens. I suggest you use the query's canOpen event:

function Query1_canOpen
this.database.emptyTable("Devisprt")
return true

Todd Kreuter [dBVIPS]

Michel

2006-10-25, 7:23 am

It seems it doesn't works.

my initial code to empty table was :
.......
form.testdatamodule1.michel1.emptytable("devisprt")

//procedure to add data in temporary table
set procedure to prepimp.cc additive
.....
close procedure prepimp.cc

//and now instantiate report
set procedure to essai1.rep additive
r = new essai1Report()
r.render()
return
................
Michel

>
> The table would be open when you instantiate the report and you need to
> empty it before it opens. I suggest you use the query's canOpen event:
>
> function Query1_canOpen
> this.database.emptyTable("Devisprt")
> return true
>
> Todd Kreuter [dBVIPS]
>
>

Sponsored Links