Ingres

Links

4 links submitted so far. Submit your own links.

News

Edit RSS feeds.

OpenROAD Developer's Forum :: Word ActiveX (again!) - External Class Events

Posted about 4 hours ago

Author: pete1970
Subject: Word ActiveX (again!) - External Class Events
Posted: Tue Jul 08, 2008 1:48 am (GMT -8)
Topic Replies: 3

I'm working in OR4.1 SP3, as External Class Events in OR2006 are not working correctly, so whilst ... [More] I wait for a fix ...

I want to know what document is closing, so I trap the external class event as follows:

ON EXTCLASSEVENT 'DocumentBeforeClose' (doc_closing = WinWord!Document)=

BEGIN

CurFrame.Trace ( text = 'closing:' VARCHAR(doc_closing.Name) );

END;

Now this works in the sense, in that it reports the document name closing, however it seems the declaration in the parameter list of 'WinWord!Document' actually initiates a new document to be opened/created ... not quite what I was expecting

is this a bug, and is there away around it? I've tried having the parameter as type ExtClass but that was of no use. [Less]

OpenROAD Developer's Forum :: RE: Word ActiveX (again!) - External Class Events

Posted about 4 hours ago

Author: Bodo
Posted: Tue Jul 08, 2008 2:20 am (GMT -8)
Topic Replies: 3

Have you tried declaring the "doc_closing" parameter with DEFAULT NULL?

OpenROAD Developer's Forum :: RE: Word ActiveX (again!) - External Class Events

Posted about 4 hours ago

Author: Pete1970
Posted: Tue Jul 08, 2008 2:31 am (GMT -8)
Topic Replies: 3

Bodo wrote: Have you tried declaring the "doc_closing" parameter with DEFAULT NULL?

whilst it does stop a new blank document ... [More] opening, due to doc_closing now being NULL, this parameter really should have the closing document in it. I noticed my trace message was actually reporting the name of the newly opened blank document and not the one that was closing down ... the closing document reference is obviously not coming back?

here is the Microsoft definition: http://msdn.microsoft.com/en-us/library/aa263708(office.10).aspx [Less]

OpenROAD Developer's Forum :: RE: Word ActiveX (again!) - External Class Events

Posted about 4 hours ago

Author: Bodo
Posted: Tue Jul 08, 2008 7:49 am (GMT -8)
Topic Replies: 3

The definition of the COM event shows 2 parameters, but you only specified one of them.

In addition, the parameter names do not match - it has to be ... [More] "doc" rather than "doc_closing".

Try:

ON EXTCLASSEVENT 'DocumentBeforeClose' (doc = WinWord!Document DEFAULT NULL, cancel = INTEGER NOT NULL)=

... [Less]

DBA Forum :: SQL Update and search conditions

Posted 1 day ago

Author: koyott
Subject: SQL Update and search conditions
Posted: Mon Jul 07, 2008 9:00 am (GMT -8)
Topic Replies: 3

Help Please! :!:

Is there in Ingres any search condition that I can use in update statement for ... [More] determine row number?

For example, "Update table set column = expression

where row_number = n"

What can I use in place of "row_number", may be any Ingres function?

If I have a table which can contain duplicate rows, and I want to update column in that table in row (tuple) which number I know, but with any search conditions it will update two or more rows, but I want only one

with known number!

what shall I do?

I tried to use tids - "update ... where tid = n", but as I understood, tids are dynamic and they are not really numbers of table rows. [Less]

Read all Ingres articles…