Paul Blew

Not when it's written in javascript

Correct me if I'm wrong, but isn't a tree control an activex control?

Hi Vol

I don't know whether it's possible to retrieve SQL_DBNAME using &$@~SQL_DBNAME, but if it isn't the following Oracle SQL may help.

SELECT sys_context('USERENV','DB_NAME') FROM DUAL;

Other parameters for sys_context are listed at: http://www.techonthe...sys_context.php

Hope this helps.

Paul

Kelvin,

If you're in the GUI world, how about writing an ActiveX control to show the clock? It could either display the client clock using Windows APIs or possibly show the server's clock by firing an event every second which could be answered by a PRO-IV logic which sets the time shown by the control according to the current value of @TIME.

Hope this helps.

Paul

Hi Ajaym,

Here's a template for a SQL Server trigger. The SET NOCOUNT lines are essential - without them the PRO-IV session will lock up the second time the trigger fires due to a bug in ODBC.

[codebox]
IF EXISTS (SELECT name FROM sysobjects WHERE name = '<TRIGGER_NAME>' AND type = 'TR')
DROP TRIGGER [<TRIGGER_NAME>]
GO

CREATE TRIGGER [<TRIGGER_NAME>] ON [dbo].[<TABLE_NAME>]
FOR INSERT, UPDATE, DELETE AS
DECLARE
@NEW_VAR1 VARCHAR(10),
@OLD_VAR2 VARCHAR(10)
BEGIN
SET NOCOUNT ON

SELECT @NEW_VAR1 = [<COLUMN_NAME>]
FROM [inserted]

SELECT @OLD_VAR1 = [<COLUMN_NAME>]
FROM [deleted]

-- your trigger processing goes here

SET NOCOUNT OFF
END
GO
[/codebox]


Hope this helps

Paul

Siddharth,

From the first line of the first page of the Java JNI Docs:

Java Native Interface (JNI) is a standard programming interface for writing Java native methods and embedding the Java virtual machine into native applications.

I'm sure you could build an interface that you could access from PRO-IVs LINK command.

I think you're going to need a C guru though.

Regards,
Paul