Community
Showing results for 
Search instead for 
Do you mean 
Reply

Field triggers and database Lock

Copper Contributor
Posts: 25
Country: United States

Field triggers and database Lock

We just imported one database into another - and now I get a Field Trigger Failed error.

 

The error advises using DEFINE FIELDS to correct the problem, but when I go into DEFINE FIELDS, it acts as though I am trying to LOCK THE DATABASE.

 

Can anyone shed any light on why - maybe I corrupted the database?

 

Thanks

 

Bob

 

 

Platinum Elite Contributor
Posts: 6,652
Country: USA

Re: Field triggers and database Lock

Because in Define Fields you change the actual database structure, the database must be locked and all other users logged out.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 25
Country: United States

Re: Field triggers and database Lock

thanks Roy

Copper Contributor
Posts: 25
Country: United States

Re: Field triggers and database Lock

You are correct - I went in and the database was locked when all the other users were out -- but I couldn't see any reason at all why the error message.

Where do I see what the field triggers are?

 

The error message comes up specifically when you enter a phone number and then try and press TAB to go to the next field.

 

Thanks for the help.

 

Bob