Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to use triggers with 32 bit xharbour

5 posts in Trigger Last posting was on 2003-12-14 20:59:09.0Z
GNR Posted on 2003-12-07 16:29:36.0Z
Date: Sun, 07 Dec 2003 21:59:36 +0530
From: GNR <gnr@hyderabadwater.gov.in>
Reply-To: gnr@hyderabadwater.gov.in
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: How to use triggers with 32 bit xharbour
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 220.226.26.251
Message-ID: <3fd35686@solutions.advantagedatabase.com>
X-Trace: 7 Dec 2003 09:34:14 -0700, 220.226.26.251
Lines: 12
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!220.226.26.251
Xref: solutions.advantagedatabase.com Advantage.Trigger:11
Article PK: 1136081

I am using HARBOUR + FWH with ACE32.DLL/
My usage is similar to clipper usage, not through SQL.
I could not use Triggers successfully.
My Doubts are :
1. Can triggers be used on free tables or is it a must that the tables
should be in a database dictionary.
2. If I define triggers in a table forming part of database dictionary,
how can i open the tables? Can I open the tables like in clipper? (eg.
USE MYTABLE) and still get the triggers function?
3. Is SQL the only way to use triggers ?
GNR


Joachim Duerr (ADS Support) Posted on 2003-12-08 09:31:39.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: How to use triggers with 32 bit xharbour
Newsgroups: Advantage.Trigger
References: <3fd35686@solutions.advantagedatabase.com>
Organization: Extended Systems GmbH
User-Agent: XanaNews/1.15.8.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <3fd444fb@solutions.advantagedatabase.com>
Date: 8 Dec 2003 02:31:39 -0700
X-Trace: 8 Dec 2003 02:31:39 -0700, 195.2.185.25
Lines: 33
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Trigger:12
Article PK: 1136082


GNR wrote in <3fd35686@solutions.advantagedatabase.com> :

> I am using HARBOUR + FWH with ACE32.DLL/
> My usage is similar to clipper usage, not through SQL.
> I could not use Triggers successfully.
> My Doubts are :
> 1. Can triggers be used on free tables or is it a must that the
> tables should be in a database dictionary.

triggers can only be used with dictionaries.

> 2. If I define triggers
> in a table forming part of database dictionary, how can i open the
> tables? Can I open the tables like in clipper? (eg. USE MYTABLE) and
> still get the triggers function?

in all Win32 or Linux based ADS applications (using the ace32.dll or
acelib.so), you can open the table as usual. BUT: You need a dictionary
connection. I don't know Harbour, but in VO you have to use the API in
order to connect to a dictionary and use the dictionary connection
handle for all further actions.

> 3. Is SQL the only way to use
> triggers ?

no.

--
Joachim Duerr
EMEA Lead ADS Support, Extended Systems GmbH, Germany
advantage[AT]extendsys.de
- posted with Xananews 1.15.8.2 -
!!! ADS 7 now available !!!


Sandeep Rao R Posted on 2003-12-09 18:39:23.0Z
From: "Sandeep Rao R" <sandeeprao@vsnl.net>
Newsgroups: Advantage.Trigger
References: <3fd35686@solutions.advantagedatabase.com> <3fd444fb@solutions.advantagedatabase.com>
Subject: Re: How to use triggers with 32 bit xharbour
Date: Wed, 10 Dec 2003 00:09:23 +0530
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 220.226.11.30
Message-ID: <3fd61716@solutions.advantagedatabase.com>
X-Trace: 9 Dec 2003 11:40:22 -0700, 220.226.11.30
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!220.226.11.30
Xref: solutions.advantagedatabase.com Advantage.Trigger:13
Article PK: 1136084

Hi,

> in all Win32 or Linux based ADS applications (using the ace32.dll or
> acelib.so), you can open the table as usual. BUT: You need a dictionary
> connection. I don't know Harbour,

Yes possible with xHarbour. AdsConnect60 followed with dbusearead works
perfectly fine for opening dictionary connection.

Sandeep


GNR Posted on 2003-12-10 03:49:38.0Z
Date: Wed, 10 Dec 2003 09:19:38 +0530
From: GNR <gnr@hyderabadwater.gov.in>
Reply-To: gnr@hyderabadwater.gov.in
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: How to use triggers with 32 bit xharbour
References: <3fd35686@solutions.advantagedatabase.com> <3fd444fb@solutions.advantagedatabase.com> <3fd61716@solutions.advantagedatabase.com>
In-Reply-To: <3fd61716@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 220.226.26.197
Message-ID: <3fd698d3@solutions.advantagedatabase.com>
X-Trace: 9 Dec 2003 20:53:55 -0700, 220.226.26.197
Lines: 25
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!220.226.26.197
Xref: solutions.advantagedatabase.com Advantage.Trigger:14
Article PK: 1136083

dear sandeep
after opening the dictionary connection with adsconnect60, can we open
the individual tables attached to the dictionary with the usual commands
like "USE CUSTOMERS" / DBUSEAREA(...) and still get the triggers
working? Or should we use only the API calls to open the tables and
retrieve/write the field values through API only (very tedious)?

GNR

Sandeep Rao R wrote:
> Hi,
>
>
>>in all Win32 or Linux based ADS applications (using the ace32.dll or
>>acelib.so), you can open the table as usual. BUT: You need a dictionary
>>connection. I don't know Harbour,
>
>
> Yes possible with xHarbour. AdsConnect60 followed with dbusearead works
> perfectly fine for opening dictionary connection.
>
> Sandeep
>
>


Sandeep Rao R Posted on 2003-12-14 20:59:09.0Z
From: "Sandeep Rao R" <sandeeprao@vsnl.net>
Newsgroups: Advantage.Trigger
References: <3fd35686@solutions.advantagedatabase.com> <3fd444fb@solutions.advantagedatabase.com> <3fd61716@solutions.advantagedatabase.com> <3fd698d3@solutions.advantagedatabase.com>
Subject: Re: How to use triggers with 32 bit xharbour
Date: Mon, 15 Dec 2003 02:29:09 +0530
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 220.226.11.157
Message-ID: <3fdccf6b@solutions.advantagedatabase.com>
X-Trace: 14 Dec 2003 14:00:27 -0700, 220.226.11.157
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!220.226.11.157
Xref: solutions.advantagedatabase.com Advantage.Trigger:18
Article PK: 1136088

GNR,

> after opening the dictionary connection with adsconnect60, can we open
> the individual tables attached to the dictionary with the usual commands
> like "USE CUSTOMERS" / DBUSEAREA(...)

Yes!

> and still get the triggers working?

Never tried triggers.

Sandeep