trigger failed in foxpro 6

[kit manivong]

I have related some tbls in a db. In VFP I have tested deleting a parent record and it consequently deleted its child records correctly. However, this db works with ASP and when I do it using the SQL delete command in an ASP page it says 'trigger failed'.

I am missing something here?

thx,
kit

[swdev2]

What are you using for your data hook in asp ? odbc, or ole-db ?
if ole-db [the right one , btw] make sure your I_USR account is set properly
to access those vfp data files.

hth - regards [Bill]

--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

Post by kit manivong
I have related some tbls in a db. In VFP I have tested deleting a parent

record and it consequently deleted its child records correctly. However,
this db works with ASP and when I do it using the SQL delete command in an
ASP page it says 'trigger failed'.

Post by kit manivong
I am missing something here?
thx,
kit

[Lee Mitchell]

Hi Kit:

Are you using the VFP ODBC driver or the OLE DB Provider? You can get the
OLE DB Provider from this link:

http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx


I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 Public Beta Now Available!! --*
Download the VFP9 beta here: http://msdn.microsoft.com/vfoxpro/

*-- VFP8 HAS ARRIVED!! --*
Read about all the new features of VFP8 here:
http://www.universalthread.com/VisualFoxPro/News/VFP8Release.asp
Purchase VFP8 here:
http://shop.microsoft.com/Referral/Productinfo.asp?siteID=11518

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

Post by kit manivong
I have related some tbls in a db. In VFP I have tested deleting a parent

record and it

Post by kit manivong
consequently deleted its child records correctly. However, this db works

with ASP and when I do

Post by kit manivong
it using the SQL delete command in an ASP page it says 'trigger failed'.
I am missing something here?
thx,
kit

[kit manivong]

Hi all,

Thanks for that.

I tried all these things but to no avail.

I am using the SQL delete command to delete a record in a parent table. It works using the VFP dev. application but not with ASP. The SQL delete works on a child table.

So is there something wrong with the delete trigger function created by RI tool?? The db and IIS is on the same machine.

thx,
Kit

[swdev2]

hiya - its a rights problem.
check out whats a going on for the I_USR account .
regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

Post by kit manivong
Hi all,
Thanks for that.
I tried all these things but to no avail.
I am using the SQL delete command to delete a record in a parent table. It

works using the VFP dev. application but not with ASP. The SQL delete works
on a child table.

Post by kit manivong
So is there something wrong with the delete trigger function created by

RI tool?? The db and IIS is on the same machine.

Post by kit manivong
thx,
Kit

[kit manivong]

Great thanks got it working!

Kit

[swdev2]

Heya Kit - mondo COOL !!!!
regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL

Post by kit manivong
Great thanks got it working!
Kit

[chopsdogg]

can you give me an idea what the problem was here and how you fixed it?

[chopsdogg]

Can you give me a clue what your issue was here and how you got this
working?