Hi,
Suppose I start a time consuming operation (say indexing some 50 BIG tables) and I want to interrupt/cancel in between.
How can we do that? Can we have a button to interrupt and stop a running function?
Regards,
S. Rathinagiri.
Can I cancel?
Moderator: Rathinagiri
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Can I cancel?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
- Roberto Lopez
- HMG Founder
- Posts: 4004
- Joined: Wed Jul 30, 2008 6:43 pm
Re: Can I cancel?
It depends on function.rathinagiri wrote:Hi,
Suppose I start a time consuming operation (say indexing some 50 BIG tables) and I want to interrupt/cancel in between.
How can we do that? Can we have a button to interrupt and stop a running function?
Regards,
S. Rathinagiri.
If you are talking about you own function (ie: indexing tables) you could use DO EVENTS between calls to DBCREATEINDEX() function.
If you mean interrupt DBCREATEINDEX() function itself, I'm not sure. Perhaps...
Code: Select all
DBCREATEINDEX(<cIndexName>, <cKeyExpr>,
[<bKeyExpr>], [<lUnique>]) --> NIL
...
<bKeyExpr> is a code block that expresses the index key expression in executable form
Anyway, I've never used <bKeyExpr> parameter, so, I don't know if it is possible
Regards,
Roberto
Regards/Saludos,
Roberto
(Veritas Filia Temporis)
Roberto
(Veritas Filia Temporis)
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Can I cancel?
Oh! Thanks for the tip Roberto.
I wanted to break my own function many times.![Smile :)](./images/smilies/icon_e_smile.gif)
![Smile :)](./images/smilies/icon_e_smile.gif)
I wanted to break my own function many times.
![Smile :)](./images/smilies/icon_e_smile.gif)
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.