I think there are some timing issues with ODBC and triggers and a given
application. The triggers don't fire until the commit, so perhaps this is
the source of the problem. I've had some problems with ODBC and triggers,
but there is usually some way around it. It depends on the way your
application works. For example, when using a trigger to populate a sequence
value, I cannot see the new value until I re-query (I'm using Lotus
Approach). Sorry, I don't use Foxpro, so I can't give you specifics.
Ray Auger <rauger_at_centurysystems.net> wrote in message
news:3846A7D5.47BB9F8F_at_centurysystems.net...
> I am having some problems with Foxpro accessing
> ORACLE 8 properly. Here are the versions of
> software I am running:
>
> - Foxpro version 6 (installed from Visual Studio 6 CD)
> - Oracle 8.0.04 on NT
> - Development PC operating system 95 and NT workstation
> (2 seperate PC's both with same results)
>
> I have a reasonably simple Oracle database (20 or so tables)
> some with cascading update triggers. So through Oracle
> (SQL Plus) I am able to update a primary key value in a
> parent table, and the correct rows in the children table
> get updated properly.
>
> I have also built a quick screen in Powerbuilder via ODBC
> and updated the primary key value in the parent table, and
> again the correct rows in the children tables get updated
> properly.
>
> I then define a 'connection' in Foxpro that points to the
> same ODBC profile I am using above. I create several remote
> views (via the connection I defined) to the parent and child
> tables. I attempt to update a primary key value in the parent
> table (remote view) using both browse screens and Froms.
> This should force the Oracle cascading update trigger to
> be executed' IT DOES NOT !
>
> Instead I get a Foxpro error 'UPDATE ERROR' every time.
>
> I have "UPDATE" SQL checked in the view painter, NOT
> delete/insert.
>
> Has anyone had similiar problems access Oracle, I believe that
> Foxpro is either ignoring the Oracle triggers or somehow ignoring
> them.
>
> Any help would be greatly appreciated.
>
> Dave Pylatuk
> davep_at_centurysystems.net
>
Received on Thu Dec 02 1999 - 11:28:11 CST
