Determining the type of field just clicked or doubleclicked
Allan Biggs
specifically how do I determine that the header column buttonfield has just been doubleclicked, I want to only react to a childboubleclick event if the event was triggered by double clicking an entry field.
Help please :-)
thanks
Allan
This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.
The dupont.com http://dupont.com web address may be used for a limited period of time by the following
divested businesses that are no longer affiliated in any way with DuPont:
Borealis Polymers NV
Jacob Holm & Sonner Holding A/S (Jacob Holm)
Kuraray Co., Ltd
DuPont accepts no liability or responsibility for the content or use of communications
sent or received on behalf of such divested businesses or for the consequences of
any actions taken on the basis of such communications.
Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean
Bodo Bergmann
Hi Allan,
Usually you can find out the type of field that has been clicked by using the CurFrame.TriggerField reference within the according event block.
Use its Classname attribute or the IsA() method to determine its type.
But double-clicking on an EntryField does not trigger a (CHILD)DOUBLECLICK event for it,
as this event is not defined for EntryField (see the Events Table in the Language Reference Manual).
A double-click on an EntryField (which is changeable or landable) would mark the whole text in the field.
HTH.
Bodo.
--
Bodo Bergmann
Senior Software Engineer
Actian | Engineering
Accelerating Big Data 2.0
Connect With Us:
GESELLSCHAFTSANGABEN: Actian Germany GmbH ¦ Geschäftsführung: Marc Monahan ¦ Sitz der Gesellschaft: Langen ¦ Handelsregister: Amtsgericht Offenbach am Main ¦ HRB 42539 ¦ USt-IdNr: DE252449897
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
openroad-user...@googlegroups.com.
To post to this group, send email to
openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/openroad-users/OFBD40DBCE.59D61F9A-ON80257DF7.005CF7AD-80257DF7.005E392D%40CDCLN05.LVS.DUPONT.COM.
For more options, visit https://groups.google.com/d/optout.
Allan Biggs
Sorry bad terminology on my part. What I am finding is that doubleclicking either a row of the table field or the button at the top of the column activates the childoubleclick event on the table field. We cannot change the bias of the button at the top of each column as we use it to sort the table field by individual columns.
Thanks
Allan
--
Sent from my Android phone with mail.com Mail. Please excuse my brevity.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CO1PR06MB314C848C85DF9CD626AB4E193170%40CO1PR06MB314.namprd06.prod.outlook.com.
Allan Biggs
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/trinity-338ab75a-92d5-44e6-bb69-9c1411f420f7-1424890822723%40msvcus006.
Allan Biggs
on childdoubleclick options_tf,
on click Go =
declare
history_call = varchar(1) not null default 'N';
enddeclare
begin
if CurFrame.TriggerField.ISA(class = ButtonField) = TRUE then
Message 'You must double click within the body of the table field';
resume;
endif;
.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/CO1PR06MB314C848C85DF9CD626AB4E193170%40CO1PR06MB314.namprd06.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.
This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.
Peter van Bennekom
This may work as long as you don’t have buttons in your tablefield.
|
|
Peter van Bennekom - Senior Principal Architect office: 610 407 8113 | fax: 610 407 8181 |
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OF4AD979DB.2E987696-ON80257DF8.00292CA7-80257DF8.0029BD0A%40CDCLN05.LVS.DUPONT.COM.
Allan Biggs
Allan
.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/9820E9D4043D2F44BDA5F41B354CFCD23B1DB922%40USALWEXMBX2.infor.com.
For more options, visit https://groups.google.com/d/optout.
Christian Birkl
Hello!
Would it be possible to check if the TriggerField is a descendant of the TableField's TableHeader?
Something like
IF CurFrame.TriggerField.IsDescendantOf(ANCESTOR = FIELD(options_tf).TableHeader) THEN ...
I haven't tried this however.
Regards,
Chris.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFE723B53D.EACE5088-ON80257DF8.0048B70D-80257DF8.0048F6EE%40CDCLN05.LVS.DUPONT.COM.
For more options, visit https://groups.google.com/d/optout.
Christian Birkl
Software Engineering
GAMED Gesellschaft
für Angewandte
Mathematik und EDV mbH
Austria 8053 Graz, Harter Straße 48
Phone: +43 (0) 316 27 86 60 - 18
Telefax: +43 (0) 316 27 86 60 - 10
E-Mail: Christi...@gamed.com
Internet: www.gamed.com
Firmenbuchnummer: FN 50094v
Firmenbuchgericht: Handelsgericht Graz
This message and any attachments are solely for the use of the intended recipients. They may contain privileged and/or confidential information or other information protected from disclosure. If you are not an intended recipient, you are hereby notified that you received this email in error and that any review, dissemination, distribution or copying of this email and any attachment is strictly prohibited. If you have received this email in error, please contact the sender and delete the message and any attachment from your system. Thank you for your cooperation.
Sean Thrower
Allan,
Something like
If curframe.TriggerField.IsDescendantOf(ancestor=tbl.TableHeader) = FALSE then ..
(check the parameter name)
Sean.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFE723B53D.EACE5088-ON80257DF8.0048B70D-80257DF8.0048F6EE%40CDCLN05.LVS.DUPONT.COM.
Allan Biggs
thanks Allan
http://www.DuPont.com/corp/email_disclaimer.html
Christian Birkl
Software Engineering
.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/54EF2088.2010004%40gamed.com.
For more options, visit https://groups.google.com/d/optout.
Martin.B...@hse.gsi.gov.uk
Allan,
The way we do this is by examining the name of the triggerfield. If it ends in “_hdr”, then we call a sorting mechanism. This does rely on a consistent naming of all table header fields, but allows us to have a single piece of code to handle clicking on all tablefield headers:
ON CHILDCLICK =
{
IF CurFrame.TriggerField.FullName LIKE ‘%_hdr’ THEN
p#TableSort.Call();
ENDIF;
}
Regards,
Martin Bloomfield
Application Developer & Database Administrator
IT Solutions Development
Business Services Division
Health and Safety Executive
YORK
Follow HSE on Twitter @H_S_E
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFD34BEA0E.8C78170D-ON80257DF8.004A911D-80257DF8.004AB2AD%40CDCLN05.LVS.DUPONT.COM.
For more options, visit https://groups.google.com/d/optout.
This email was scanned by the Government Secure Intranet anti-virus service supplied by Vodafone in partnership with Symantec. (CCTM Certificate Number 2009/09/0052.) In case of problems, please call your organisations IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
*****************************************************************************************************************
Please note : Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications and may be automatically logged, monitored and / or recorded for lawful purposes by the GSI service provider.
Interested in Occupational Health and Safety information?
Please visit the HSE website at the following address to keep yourself up to date
*****************************************************************************************************************
The original of this email was scanned for viruses by the Government Secure Intranet virus scanning service supplied by Vodafone in partnership with Symantec. (CCTM Certificate Number 2009/09/0052.) This email has been certified virus free.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
Allan Biggs
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/57B7A7598ACE5348B646796AADE237E331E7525A%40VBTLMBX01.hse.int.
Allan Biggs
It got this far with the standard call
the GUI itself did not open.
It does however open up with the -cclassic flag and seems to work correctly.
These are the properties and start in directories we are using.
Classic
"C:\Program Files\Actian\Ingres\or51xl\ingres\bin\orwrap.exe" "C:\Program Files\Actian\Ingres\or51xl\ingres\bin\w4gldev.exe" "runimage" "workbnch.img" "-Tall" "-Lworkbench.log" "-cclassic"
"C:\Program Files\Actian\Ingres\or51xl\ingres\bin\"
Standard
"C:\Program Files\Actian\Ingres\or51xl\ingres\bin\orwrap.exe" "C:\Program Files\Actian\Ingres\or51xl\ingres\bin\w4gldev.exe" "runimage" "workbnch.img" "-Tmin" "-Lworkbench.log"
"C:\Program Files\Actian\Ingres\or51xl\ingres\bin\"
I think openroad-5.11.5104-win-x86-full-c is the installation software that we are using
Clearly the thing to do is reinstall OpenRoad but I am concerned that we may have used an earlier or later build.
How do I discover what the patch number is?
help from the classic view gives this
Does anyone know a fix without re-installing OR? What seems strange is that the two calls use the same code
both w4gldev.exe and workbnch.img were last modified when OR was installed modified date and create dates are the same.
thanks in advance
Allan
This communication is for use by the intended recipient and contains
information that may be Privileged, confidential or copyrighted under
applicable law. If you are not the intended recipient, you are hereby
formally notified that any use, copying or distribution of this e-mail,
in whole or in part, is strictly prohibited. Please notify the sender by
return e-mail and delete this e-mail from your system. Unless explicitly
and conspicuously designated as "E-Contract Intended", this e-mail does
not constitute a contract offer, a contract amendment, or an acceptance
of a contract offer. This e-mail does not constitute a consent to the
use of sender's contact information for direct marketing purposes or for
transfers of data to third parties.
Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean
adr...@octavo2.demon.co.uk
Hi Allan,
> How do I discover what the patch number is?
You can normally see this in the properties for orrun.dll –
Where 14300 is the patch.
As for your other hanging issue - I’ve not seen that before, but I still use classic mode.
Is w4gldev consuming any CPU or just sitting there?
Have you got a file lock on one of the profile files in ingres/files?
Good luck,
Adrian
--
You received this message because you are subscribed to the Google Groups
"OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to openroad-user...@googlegroups.com.
To post to this group, send email to openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OF61FECE81.AC41151B-ON80257E8C.004F2502-80257E8C.0051C3B5%40CDCLN05.LVS.DUPONT.COM.
Martin.B...@hse.gsi.gov.uk
Alan,
The way I usually check to see what version & patch level is installed is via the w4gldev.rel or w4glrun.rel files. These can be found in the II_SYSTEM\ingres folder and are plain text files.
I’m not using 5.1 so can’t comment on your problem opening the workbench.
Martin Bloomfield
Application Developer & Database Administrator
IT Solutions Development
Business Services Division
Health and Safety Executive
YORK
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com]
On Behalf Of Allan Biggs
Sent: 24 July 2015 15:52
To: openroa...@googlegroups.com
Subject: [openroad-users] Issue starting up OpenROAD workbench
I am connected to our work server via VPN (avantail) Sometimes if I leave OpenRoad workbench open with a period of inactivity when I come back to it I get lots of messages complaining that the
connection with the database has been lost. Usually there is no issue I just close down the workbench ignoring the frequent messages and restart it. This happened again today but when I restarted the workbench it didn't give me the usual connection profiles.
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
openroad-user...@googlegroups.com.
To post to this group, send email to
openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OF61FECE81.AC41151B-ON80257E8C.004F2502-80257E8C.0051C3B5%40CDCLN05.LVS.DUPONT.COM.
For more options, visit https://groups.google.com/d/optout.
This email was scanned by the Government Secure Intranet anti-virus service supplied by Vodafone in partnership with Symantec. (CCTM Certificate Number 2009/09/0052.) In case of problems, please call your organisations IT Helpdesk.
Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
Allan Biggs
Hi Allan,
> How do I discover what the patch number is?
You can normally see this in the properties for orrun.dll –
Where 14300 is the patch.
As for your other hanging issue - I’ve not seen that before, but I still use classic mode.
Is w4gldev consuming any CPU or just sitting there?
Have you got a file lock on one of the profile files in ingres/files?
Good luck,
Adrian
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Allan Biggs
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/015d01d0c622%24a2c9db70%24e85d9250%24%40demon.co.uk.
Peter van Bennekom
Hi Adrian,
I think the patch number is 5104. The last part is the build number if I am not mistaken
It should have been better if the file version was 5.1.1.5104
AFAIK Actian never asked for the buildnumber so patch is more important…
Peter
|
|
|
Peter van Bennekom - Senior Principal Architect office: 610 407 8113 | fax: 610 407 8181 |
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of adr...@octavo2.demon.co.uk
Sent: Friday, July 24, 2015 11:09 AM
To: openroa...@googlegroups.com
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/015d01d0c622%24a2c9db70%24e85d9250%24%40demon.co.uk.
Brigitte Duplenne
Hi,
Actually 5104 is the build number and 14300 is the patch number.
Also this patch 14300 was a particular patch as it was Service Pack 1: aka OR SP1
Note that the release, build and patch number are also written at the beginning of the Log file and Trace Window.
Regards,
Brigitte
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/9820E9D4043D2F44BDA5F41B354CFCD2445D3086%40USALWEXMBX2.infor.com.
Reason, Shaun (CSS)
Hi,
Has anyone any information about when OR6.2 for other platforms will be available and will all platforms currently supported by OR5.1 be supported in 6.2?
Thanks,
Shaun.
This email is security checked and subject to the disclaimer on web-page: http://www.capita.co.uk/email-disclaimer.aspx
Chris Clark
We’re currently working on the Unix ports for OR 6.2. At the moment we are targeting early 2016 (subject to QA and partner testing) for 64-bit ports of OR 6.2 on AIX and Linux. The 32-bit ports (Linux, AIX, and Solaris) will follow on after that. HP-UX will not be supported and the OS version requirements will be bumped up a little (same version support as Ingres 10.2).
OpenROAD 6.2 for Windows is GA (Generally Available) and can be downloaded from http://esd.actian.com.
If anyone is interested in 64-bit and we’ve not already talked, please contact me offline.
Regards,
Chris
--
Chris Clark
Manager, Engineering
Actian | Engineering
Accelerating Big Data 2.0
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
openroad-user...@googlegroups.com.
To post to this group, send email to
openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/HE1PR04MB1388133EDD279B09BD135DE7AD750%40HE1PR04MB1388.eurprd04.prod.outlook.com.
Sidney
I hope this email finds you well...seems everyone down here has a cold or the flu...and I am staying away from them
When the 64 bit version is relatively stable I would love to start working with it....so put me on the list please
Sidney
Sidney...@actian.com | Principal Support Engineer | 1800 614 435 | Location: Brisbane [GMT +10]
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/DM2PR0601MB1294252FBBB7BDDAB8C71F5F9F750%40DM2PR0601MB1294.namprd06.prod.outlook.com.
James Higson
Hi Chris,
I see from the OR6.2 release notes that Win10 is not yet supported. When can we expect this? Our client is looking to move to Win10.
I too can’t wait to leave Win8.1 behind like the roadkill that it is.
Regards,
James Higson
Systems Analyst
Ebix Australia Pty Ltd
Direct +61
2 8234 8205 | Melbourne +61
3 9578 9307 | Fax +61
2 8234 8201
Email james....@ebix.com | Web www.fintechnix.com
From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Sidney
Sent: Thursday, 6 August 2015 08:35
To: openroa...@googlegroups.com
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/55C28FA6.4010305%40actian.com.
For more options, visit https://groups.google.com/d/optout.
The information contained in this message may be CONFIDENTIAL and is for the intended addressee only. Any unauthorized use, dissemination of the information, or copying of this message is prohibited. If you are not the intended addressee, please notify the sender immediately and delete this message.
Chris Clark
We’ve tested OpenROAD 6.2 with the pre-release version of Windows 10. We’ve not yet done testing with the final version of Windows 10. The intention is to support Windows 10 so if you do find an issue you should open a support case and let us know.
Regards,
Chris
--
Chris Clark
Manager, Engineering
Actian | Engineering
Accelerating Big Data 2.0
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/ff6b4726a1a140cd941b1d16fe550e32%40ExchMailBox1.delphi.com.
James Higson
Thanks Chris.
So I take it we can forge ahead with testing OR6.2 on Win10 and let Actian know of any issues we find.
Regards,
James Higson
Systems Analyst
Ebix Australia Pty Ltd
Direct +61
2 8234 8205 | Melbourne +61
3 9578 9307 | Fax +61
2 8234 8201
Email james....@ebix.com | Web www.fintechnix.com
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/DM2PR0601MB1294C3557B07E244E06C05F29F740%40DM2PR0601MB1294.namprd06.prod.outlook.com.
For more options, visit https://groups.google.com/d/optout.
Chris Clark
Yes.
As a heads up, we do know Microsoft Edge will not work with the eClient (Edge does not use ActiveX), but ie11 should work. If you are not using the eClient and using regular OpenROAD or Loadnrun then this won’t impact you, we’re not aware of any issues with those.
Chris
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/cff5803c76fc48848452eac56799a466%40ExchMailBox1.delphi.com.
Allan Biggs
this is the type of fixed text at the header of the spreadsheet.
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
I have tried de-referencing with /
.HEADER REPORT
.PRINTLN "/<?xml version=/"1.0/"?/>"
This will store but gives this error when run (there isn't a 'rollback' in the report and the report runs if I remove the line )
INGRES REPORT Copyright 2003 Computer Associates Intl, Inc.
Reading report specifications and preparing query . . .
Retrieving data . . .
E_US1130 illegal character to integer conversion or non-numeric character
in money field.
E_RW1209 Fatal error occurred in header text for 'report'. Line with
error: 'println "/<?xml version=/",1.0/"?/>"'. Processing stops.
E_LQ002B 'rollback' may not be nested within a data retrieval loop.
I would be grateful of any suggestions
I should say that I had forgotten just how flexible and useable Report writer is.
thanks
Bodo Bergmann
Have you tried:
.PRINTLN '<?xml version="1.0"?>'
What does you make thinking that a slash (/) would work as an escape character?
Bodo.
--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to
openroad-user...@googlegroups.com.
To post to this group, send email to
openroa...@googlegroups.com.
Visit this group at http://groups.google.com/group/openroad-users.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/OFED74B0B4.B8A1F364-ON80257E9D.0057710F-80257E9D.0059899F%40CDCLN05.LVS.DUPONT.COM.
Allan Biggs
End of a long day , over thinking