error 1099 "Procedure cancelled"

[Paco75]

Hi,

I got this error message but it is not documented anywhere! I looked in the msdn error messages list and it's not part of that list!

any idea what this error is?

thanks

 

[Dan Freeman]

What were you doing at the time?

 

[Mike Lewis]

How was the error message generated?

It's not a native VFP error, but it might be generated by either an ODBC or COM call?

Can you show us the code which generated the error?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Paco75]

This seems to happen when someone is trying to access a table that is opened in exclusive... i was expecting to receive a 1705 error message but i get 1099 instead.

 

[markros]

You can get this error from a trigger.

PluralSight Learning Library

 

[Paco75]

I dont use triggers in this program

 

[markros]

Do you use tables that are part of database container? I've seen this error before, but don't remember every particular scenario.

PluralSight Learning Library

 

[Paco75]

its an old program and it use free tables. Im trying to adapt it to trap 1705 errors (someone is locking table) to allow them to wait and retry instead.

 

[Paco75]

Ok i found the problem... it was my error handling trying to resume something inside a try/catch... the try/catch was cancelling the procedure so i could not return on the line to try again the USE command.

still strange that this error is not documented in vfp.

anyway thanks for helping!

 

[markros]

Good point. Now I remembered that this is where I've seen this error to happen!

PluralSight Learning Library

 

[galaxynik]

I had this error recently - I was trying to refer to a top level form from a top level menu I used _vfp.activeform..... and it threw the error - in the end I used _screen.activeform... (vfp9 sp2) which I thought was deprecated now .. ho hum

 

[Mike Lewis]

_screen.activeform... which I thought was deprecated now

Not that I know of.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy