Hello -

I have stumbled across a problem that is driving me crazy!

I have just created forms form my app and put some test data into them to make sure everything was fine...., and things aren't.

When I delete a record from a form I am getting an error message that says:

SET DATA TO - "application name"
Error - 1534
Database - "application" is not open
method - _ri_delete_voice_contacts && voices contacts is a table
Line - 29

_________________________________________________________________

this happens for all my tables, not just this one.

I have my referential integrity set to "restrict" on the delete tab. If I remove that and place in "ignore", I don't get this error message and everything is fine.

However, I am quite confident I want to keep the "restrict" in place. I should be able to delete a record on a form and not get this error message.

I went to the help file and read about error 1534. It stats that:

a database "alias" is not open. You have attempted to SET DATABASE TO a database that isn't open yet.

You will have to forgive me, I am rather new to the development world, and this may seem very simple. But, when open up my application and start working on it, isn't it open? Just to make sure, I went to the command window and typed in:

OPEN DATABASE "myapp"

and that didn't resolve the problem.

One more thing. I noticed in the help file that it said Visual FoxPro will not recognize a path name properly if a disk or directory name contains an exclamation point.

I noticed when I go and delete a record from a form, on the very bottom of my page(lower left hand corner), it shows the current table I am on, followed by the database it is attached to, and it has an exclamation point....which I didn't put there!

it reads:
mytable(mydatabase!mytable.record) 1/1 Record unlocked


Sorry for the length of this message. If anyone has an idea of what i can do, I would appreciate it very much

thanks
Jason