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.

ADT and DD and insteadOfInsert trigger

2 posts in Xbase++ Last posting was on 2008-11-18 16:22:37.0Z
UliTs Posted on 2008-11-10 15:14:18.0Z
Date: Mon, 10 Nov 2008 16:14:18 +0100
From: UliTs <ProScope@t-online.de>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: advantage.Xbase++
Subject: ADT and DD and insteadOfInsert trigger
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 84.187.196.239
Message-ID: <49184e3e@solutions.advantagedatabase.com>
X-Trace: 10 Nov 2008 08:07:42 -0700, 84.187.196.239
Lines: 23
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.187.196.239
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1007
Article PK: 1140851

Hello,

I want to build a trigger for Event Type "Insert".
I want to change the value of one Field called "Id".
Normally I buld a special Number and put it into "Id".

In my xBase-application I use an SQL-Statement like

INSERT INTO RootTable SELECT * FROM TmpTable;

But it is very slow (2500 Records: 20 seconds).
And for more than 65534 there will be an ADS-error.

I wrote a Test-trigger:

UPDATE __New SET Id=321;
INSERT INTO RootTable SLECT * FROM __new;

With this Test-Trigger it is also slow!

What is the reason?

Uli


Ricardo Rodr?guez Posted on 2008-11-18 16:22:37.0Z
Reply-To: "Ricardo Rodr?guez" <riesrovicasa@adinet.com.uy>
From: "Ricardo Rodr?guez" <riesrovicasa@adinet.com.uy>
Newsgroups: advantage.Xbase++
References: <49184e3e@solutions.advantagedatabase.com>
Subject: ADS en Red local
Date: Tue, 18 Nov 2008 14:22:37 -0200
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.0
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
NNTP-Posting-Host: 190.134.6.20
Message-ID: <4922ea63@solutions.advantagedatabase.com>
X-Trace: 18 Nov 2008 09:16:35 -0700, 190.134.6.20
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!190.134.6.20
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1008
Article PK: 1140850

Hola amigos del foro, agradezco si me aclaran un poco la instalaci?n de ADS
en RED.
Explico lo que tengo y lo que he intentado hacer.

En la m?quina servidor esta habilitado el puerto 4000 para lan port y en el
firewall tambi?n le abr? ese puerto

En la m?quina del cliente hice el siguiente archivo ads.ini y lo guarde en
system32 de windows

[SETTINGS]
ADS_SERVER_TYPE = 2
DEFAULT_PROTOCOL = 2


[MYSERVER]
LAN_IP=192.168.1.5
LAN_PORT=4000


Nota: Esto me coloc? el ARC al intentar hacer una conexi?n a la carpeta del
servidor donde tengo las bases de datos

[ESCDS_info]
Username=adssys
ServerType=remote
CommunicationType=default
LockingMode=proprietary
CharType=ansi
SecurityMode=ignorerights
DBFTableType=cdx
BlankPassword=yes
TableMasks=*.adt;*.dbf
[databases]
ESCDS=\\192.168.1.5\C\ESC_DS\DBF;c

En la carpeta c:\esc_ds\dbf que es donde tengo las bases tambien tengo la
dll de comuniones AXCWS32.DLL.

Como ver?n la ip del servidor es 192.168.1.5 y la carpeta compartida en este
caso es el disco C: e intento acceder a c:\esc_ds\dbf

Tengo el error 6420 que es cuando no encuentra el servicio corriendo en la
pc que est? como servidor. Tambi?n aclaro que en las m?quinas que pasa esto
son siempre con xp profesiona, he probado con 2003 y tengo conexi?n. Por lo
que he le?do no necesariamente tiene que ser un sistema servidor.

Con ARC intent? hacer una conexi?n del tipo REMOTA

Bueno espero haber sido claro en mis explicaciones y agradezco mucho su
ayuda

Ricardo