PDA

View Full Version : Q: Triggers P.SQL and Connectivity



Visual Systems AB \(Martin Arvidsson\)
5-Dec-2005, 09:32 AM
Hi!

I created a couple of triggers in P.SQL, when executed directly in Control
Center, it works just fine. but when altering data from DataFlex over the
Con. Kit. It seems like the triggers are not executed?!?

Any one came a cross this fenonema?

Regards
Martin

Bernhard Mandl
5-Dec-2005, 10:49 AM
Triggers and transaktional access (aka Btrieve access) are mutually
exclusive.

If you define an update trigger, updates via the Btrieve interface (= P.SQL
CK) are no longer possible
If you define an insert trigger, inserts via the Btrieve interface (= P.SQL
CK) are no longer possible
If you define a delete trigger, deletes via the Btrieve interface (= P.SQL
CK) are no longer possible

"Visual Systems AB (Martin Arvidsson)" <martin.arvidsson@vsab.net> schrieb
im Newsbeitrag news:kKP42ia%23FHA.5768@dacmail.dataaccess.com...
> Hi!
>
> I created a couple of triggers in P.SQL, when executed directly in Control
> Center, it works just fine. but when altering data from DataFlex over the
> Con. Kit. It seems like the triggers are not executed?!?
>
> Any one came a cross this fenonema?
>
> Regards
> Martin
>

Visual Systems AB \(Martin Arvidsson\)
6-Dec-2005, 10:22 AM
This stinks.

Is it possible to use ODBC access to a pervasive database and gain use of
all the functions, triggers etc?

Regards
Martin

"Bernhard Mandl" <b.mandl@_NOSPAM_a1.net> skrev i meddelandet
news:V9nrLMb%23FHA.3388@dacmail.dataaccess.com...
> Triggers and transaktional access (aka Btrieve access) are mutually
> exclusive.
>
> If you define an update trigger, updates via the Btrieve interface (=
> P.SQL CK) are no longer possible
> If you define an insert trigger, inserts via the Btrieve interface (=
> P.SQL CK) are no longer possible
> If you define a delete trigger, deletes via the Btrieve interface (= P.SQL
> CK) are no longer possible
>
> "Visual Systems AB (Martin Arvidsson)" <martin.arvidsson@vsab.net> schrieb
> im Newsbeitrag news:kKP42ia%23FHA.5768@dacmail.dataaccess.com...
>> Hi!
>>
>> I created a couple of triggers in P.SQL, when executed directly in
>> Control Center, it works just fine. but when altering data from DataFlex
>> over the Con. Kit. It seems like the triggers are not executed?!?
>>
>> Any one came a cross this fenonema?
>>
>> Regards
>> Martin
>>
>
>

Ben Weijers
6-Dec-2005, 02:04 PM
Yes, if you use ODBC you can use triggers. Connecting via ODBC to
Pervasive.SQL will be slower then using the Pervasive.SQL CK.

Regards,

Ben Weijers
Data Access Worldwide

Bernhard Mandl
7-Dec-2005, 07:36 AM
If you use ODBC then you loose the benefits of P.SQL

The real advantage of P.SQL in combination with DataFlex is that the btrieve
access model of P.SQL is exactly the same as the access model of the native
dataflex .dat files.

This means DF with the P.SQL CK is a perfect match with unbeatable
performance.

The SQL interface of P.SQL sucks (believe me!)

If you want to use SQL access choose a real SQL database as backend.

Regards,
Bernhard

"Visual Systems AB (Martin Arvidsson)" <martin.arvidsson@vsab.net> schrieb
im Newsbeitrag news:w1TaQjn%23FHA.5136@dacmail.dataaccess.com...
> This stinks.
>
> Is it possible to use ODBC access to a pervasive database and gain use of
> all the functions, triggers etc?
>
> Regards
> Martin
>
> "Bernhard Mandl" <b.mandl@_NOSPAM_a1.net> skrev i meddelandet
> news:V9nrLMb%23FHA.3388@dacmail.dataaccess.com...
>> Triggers and transaktional access (aka Btrieve access) are mutually
>> exclusive.
>>
>> If you define an update trigger, updates via the Btrieve interface (=
>> P.SQL CK) are no longer possible
>> If you define an insert trigger, inserts via the Btrieve interface (=
>> P.SQL CK) are no longer possible
>> If you define a delete trigger, deletes via the Btrieve interface (=
>> P.SQL CK) are no longer possible
>>
>> "Visual Systems AB (Martin Arvidsson)" <martin.arvidsson@vsab.net>
>> schrieb im Newsbeitrag news:kKP42ia%23FHA.5768@dacmail.dataaccess.com...
>>> Hi!
>>>
>>> I created a couple of triggers in P.SQL, when executed directly in
>>> Control Center, it works just fine. but when altering data from DataFlex
>>> over the Con. Kit. It seems like the triggers are not executed?!?
>>>
>>> Any one came a cross this fenonema?
>>>
>>> Regards
>>> Martin
>>>
>>
>>
>
>