General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>>If I set up a write trigger to prevent someone from changing data in my app, can it be bypassed?
>>>>
>>>>I envision having the trigger look for some global var before it will work. If the table is opened indepedently
>>>>of the dbc will the trigger still work?
>>>
>>>Once a table is associated with a database, when you open the table, you open the database. The triggers will fire.
>>>
>>>FWIW, you can check this out by opening a table and then checking the return value of DBUsed("MyDatabase"). The database is open; however, it is not the current database. To make it current, you need to SET DATABASE TO MyDatabase.
>>
>>Nevermind... I never knew the difference between INSERT and INSERT SQL.
>>
>>However... I think a user can modify the table and remove the trigger right?
>
>Only if they can get exclusive use of it.
That would be very easy with a copy of VFP wouldn't it? Assuming no one else had it open?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only