# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=45 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 46 --- ## [Help us make FactoryPMI better!](https://forum.inductiveautomation.com/t/help-us-make-factorypmi-better/589)
**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Replies:** 5\ **Last updated:** [March 11, 2008, 4:27pm UTC](https://forum.inductiveautomation.com/t/help-us-make-factorypmi-better/589 "2008-03-11T16:27:05Z")
Hello everyone. We are testing out a brand new serialization routine for FactoryPMI 3.2 that is over twice as fast (this is the time to save a window and the time to open it back up) as the existing one. Unfortunately,… --- ## [Keyboard Shortcuts](https://forum.inductiveautomation.com/t/keyboard-shortcuts/602)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [March 11, 2008, 4:24pm UTC](https://forum.inductiveautomation.com/t/keyboard-shortcuts/602 "2008-03-11T16:24:45Z")
It would be nice to have a keyboard shortcut for dynamic properties. Is there already an undocumented one? Also, the ctrl-U doesn't seem to bring up the customizer. --- ## [Action Item Configuration window](https://forum.inductiveautomation.com/t/action-item-configuration-window/576)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 2\ **Last updated:** [March 9, 2008, 6:20pm UTC](https://forum.inductiveautomation.com/t/action-item-configuration-window/576 "2008-03-09T18:20:39Z")
It would be nice if the Action Item Configuration window could remember its last size/position, or maybe offer a maximize button. I'm often in there constructing huge long queries and it's rather a pain because the defau… --- ## [Scan class - leased tags](https://forum.inductiveautomation.com/t/scan-class-leased-tags/599)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 1\ **Last updated:** [March 7, 2008, 10:27pm UTC](https://forum.inductiveautomation.com/t/scan-class-leased-tags/599 "2008-03-07T22:27:43Z")
1) Can I configure a scan class in leased mode to have a low speed which results in never scanning? 2) If so, is there any way to check that it is working correctly? I can't open a client to check, so how would I kn… --- ## [Value display](https://forum.inductiveautomation.com/t/value-display/598)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [March 7, 2008, 9:11pm UTC](https://forum.inductiveautomation.com/t/value-display/598 "2008-03-07T21:11:47Z")
When I set a tag to a numeric display, the value shown has a decimal point. Is there a way to get rid of the decimal point so it only shows a whole number, or is it showing the decimal because it reads it from the PLC. --- ## [Adding non-opc tags to FSQL table](https://forum.inductiveautomation.com/t/adding-non-opc-tags-to-fsql-table/597)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [March 6, 2008, 11:44pm UTC](https://forum.inductiveautomation.com/t/adding-non-opc-tags-to-fsql-table/597 "2008-03-06T23:44:23Z")
I have a set of machine values that are writing to a table. I need to add 3 fields to this table: OrderNumber, OrderLineNumber and RollSequence. This data is available via querying another table. Management wants to be a… --- ## [Error writing to DB](https://forum.inductiveautomation.com/t/error-writing-to-db/596)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [March 5, 2008, 9:41pm UTC](https://forum.inductiveautomation.com/t/error-writing-to-db/596 "2008-03-05T21:41:15Z")
I am trying to evaluate the software and have a problem with the following error when creating/running a logging table. Here is the error: Error executing update query: The name 'False' is not permitted in this conte… --- ## [Is there an event that's triggered on opening a window](https://forum.inductiveautomation.com/t/is-there-an-event-thats-triggered-on-opening-a-window/595)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [March 5, 2008, 6:01pm UTC](https://forum.inductiveautomation.com/t/is-there-an-event-thats-triggered-on-opening-a-window/595 "2008-03-05T18:01:34Z")
We would like to run a DB script that does some updates to the database tables before we load them into our application. Is there an "on load" type event we coud use? --- ## [Popup Calendar not acknowledging mouse click](https://forum.inductiveautomation.com/t/popup-calendar-not-acknowledging-mouse-click/593)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 6\ **Last updated:** [March 5, 2008, 5:22pm UTC](https://forum.inductiveautomation.com/t/popup-calendar-not-acknowledging-mouse-click/593 "2008-03-05T17:22:53Z")
I have two popup calendars on my window. I have a check box that has selected set to true on the mouse click action of one of the calendars. This functions correctly if I click on the calendar date, but does not fire i… --- ## [Drag and Drop](https://forum.inductiveautomation.com/t/drag-and-drop/594)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [March 5, 2008, 5:04pm UTC](https://forum.inductiveautomation.com/t/drag-and-drop/594 "2008-03-05T17:04:52Z")
Don't know how involved it would be to add this, but some kind of drag and drop functionality would be great. It is hard to explain in an email, but maybe we'll call and describe what we're thinking of. D Lewis --- ## [Want NULL returned from SQL query if no values were found](https://forum.inductiveautomation.com/t/want-null-returned-from-sql-query-if-no-values-were-found/592)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [March 5, 2008, 3:06pm UTC](https://forum.inductiveautomation.com/t/want-null-returned-from-sql-query-if-no-values-were-found/592 "2008-03-05T15:06:12Z")
We are using the SQL query: Select tank from lookuptanks where projectedTank = '{Root Container.TankSelected}' The problem is that sometimes there is no value in TankSelected, so there is nothing returned from SQL. We… --- ## [Quality overlays](https://forum.inductiveautomation.com/t/quality-overlays/590)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 7\ **Last updated:** [March 5, 2008, 12:36am UTC](https://forum.inductiveautomation.com/t/quality-overlays/590 "2008-03-05T00:36:08Z")
I'm a little confused (not an unusual state) re quality overlays. Here's what I want to do. I have a word containing bits of status data. All the bits are parsed out into SQLTags. However, I don't want to display th… --- ## [Clear check boxes on window open](https://forum.inductiveautomation.com/t/clear-check-boxes-on-window-open/591)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [March 4, 2008, 10:36pm UTC](https://forum.inductiveautomation.com/t/clear-check-boxes-on-window-open/591 "2008-03-04T22:36:40Z")
We would like to clear all check boxes everytime we open a new window. We have other components bound to them. We were trying to clear them before closing the window so they would be clear on the next open, but we get a… --- ## [Pushbuttons](https://forum.inductiveautomation.com/t/pushbuttons/586)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 7\ **Last updated:** [March 3, 2008, 9:30pm UTC](https://forum.inductiveautomation.com/t/pushbuttons/586 "2008-03-03T21:30:47Z")
Are there any push bottons that are momentary. I need a button that I can use to momentarily set a bit in a PLC with out having to add logic to get the PLC to reset the bit. ie. start/stop a motor with a start button a… --- ## [Dates in Jython](https://forum.inductiveautomation.com/t/dates-in-jython/584)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [March 1, 2008, 3:20am UTC](https://forum.inductiveautomation.com/t/dates-in-jython/584 "2008-03-01T03:20:09Z")
We want to subtract two dates in our Jython script and find out how many days have passed. Also, we would like to convert a date to a string that we can pass back to SQL to update the tables. We are assigining a varia… --- ## [Let's talk about 21CFR11](https://forum.inductiveautomation.com/t/lets-talk-about-21cfr11/57)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 9\ **Last updated:** [February 29, 2008, 7:57pm UTC](https://forum.inductiveautomation.com/t/lets-talk-about-21cfr11/57 "2008-02-29T19:57:39Z")
I posted the following to the control.com forums. Let's keep it going here. control.com/1026220631/index\_html I'm trying to find out all I can about 21CFR11. I'm working on implementing a system with FactorySQL and Fac… --- ## [Table Column Assignment](https://forum.inductiveautomation.com/t/table-column-assignment/582)
**Author:** [@mwfcelg](https://forum.inductiveautomation.com/u/mwfcelg)\ **Replies:** 2\ **Last updated:** [February 29, 2008, 6:00pm UTC](https://forum.inductiveautomation.com/t/table-column-assignment/582 "2008-02-29T18:00:01Z")
Hi, I need to log OPC items to an existing table in a SQL database. When I select the "Options, Edit Column Assignments", the only mapping that I can do is to a date field with the timestamp property of the items. I… --- ## [Open Windows Dynamically When Starting App](https://forum.inductiveautomation.com/t/open-windows-dynamically-when-starting-app/575)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 9\ **Last updated:** [February 29, 2008, 5:27pm UTC](https://forum.inductiveautomation.com/t/open-windows-dynamically-when-starting-app/575 "2008-02-29T17:27:03Z")
Is there a way to dynamically specify what window(s) to open when the application starts? For example, I would like to be able to append a parameter, i.e., the window to open, to the launching URL and the parameter be… --- ## [How to use Menu editor?](https://forum.inductiveautomation.com/t/how-to-use-menu-editor/583)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 1\ **Last updated:** [February 29, 2008, 5:17pm UTC](https://forum.inductiveautomation.com/t/how-to-use-menu-editor/583 "2008-02-29T17:17:46Z")
I want to add something to the menu bar, but when I open the Menu editor, everything is grayed out and I can’t do anything. What do I do? --- ## [Level indicator issue](https://forum.inductiveautomation.com/t/level-indicator-issue/525)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 8\ **Last updated:** [February 28, 2008, 7:29pm UTC](https://forum.inductiveautomation.com/t/level-indicator-issue/525 "2008-02-28T19:29:07Z")
On the Level Indicator component, if you bind the Capacity to a tag that changes frequently, eventually the component will stop responding and will no longer update the display. I discovered this because I'm not using … --- ## [Dates compare directly between components and SQL tables?](https://forum.inductiveautomation.com/t/dates-compare-directly-between-components-and-sql-tables/581)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 6\ **Last updated:** [February 28, 2008, 7:22pm UTC](https://forum.inductiveautomation.com/t/dates-compare-directly-between-components-and-sql-tables/581 "2008-02-28T19:22:04Z")
I have a calendar component and want to compare a date returned from it to one in a database table. I tried checking if \<= to current date, but that does not seem to work. --- ## [Optimization](https://forum.inductiveautomation.com/t/optimization/577)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 9\ **Last updated:** [February 28, 2008, 1:22am UTC](https://forum.inductiveautomation.com/t/optimization/577 "2008-02-28T01:22:06Z")
How efficient is the runScript() expression language function? I have two different ways of running some Jython code every 100 ms on a very slow embedded system, so it could be important. Also it's not just one tag, it's… --- ## [Easy Chart](https://forum.inductiveautomation.com/t/easy-chart/578)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 1\ **Last updated:** [February 27, 2008, 9:55pm UTC](https://forum.inductiveautomation.com/t/easy-chart/578 "2008-02-27T21:55:35Z")
Do the tags being trended need to be stored in a DB or can you use a SQL tag? I couldnt find any help topics on this tool in the help menu. --- ## [OPC servers need to be refreshed after a while](https://forum.inductiveautomation.com/t/opc-servers-need-to-be-refreshed-after-a-while/572)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 3\ **Last updated:** [February 27, 2008, 5:09pm UTC](https://forum.inductiveautomation.com/t/opc-servers-need-to-be-refreshed-after-a-while/572 "2008-02-27T17:09:06Z")
My problem is that I can't browse for items after adding a few tags to a group without refreshing OPC servers. Here is what I do to create the problem, it works every time, and on several different PCs: Browse to a fo… --- ## [Resetting Event Meters](https://forum.inductiveautomation.com/t/resetting-event-meters/552)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 3\ **Last updated:** [February 27, 2008, 1:57am UTC](https://forum.inductiveautomation.com/t/resetting-event-meters/552 "2008-02-27T01:57:34Z")
I am using an event meter in FSQL to keep count of a certain event. I have an SQL update query reset the value to 0 at shift change, but the value in the field I'm resetting does not get to 0, it stays where it was. Ho… --- ## [FSQL and Linux](https://forum.inductiveautomation.com/t/fsql-and-linux/573)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 1\ **Last updated:** [February 26, 2008, 11:03pm UTC](https://forum.inductiveautomation.com/t/fsql-and-linux/573 "2008-02-26T23:03:36Z")
I see that FPMI has a Linux build. Does FSQL? How about FPMI reporting plugin? --- ## [Can You Determine In What Manner FPMI Was Launched?](https://forum.inductiveautomation.com/t/can-you-determine-in-what-manner-fpmi-was-launched/561)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 3\ **Last updated:** [February 26, 2008, 6:34pm UTC](https://forum.inductiveautomation.com/t/can-you-determine-in-what-manner-fpmi-was-launched/561 "2008-02-26T18:34:21Z")
Is there a way to determine in what manner an FactoryPMI application has been launched? Specifically, I want to determine if the application is running as an applet or not. --- ## [Inactivity and logout](https://forum.inductiveautomation.com/t/inactivity-and-logout/368)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 7\ **Last updated:** [February 26, 2008, 6:32pm UTC](https://forum.inductiveautomation.com/t/inactivity-and-logout/368 "2008-02-26T18:32:31Z")
Hi Guys. I am using the following code to check for inactivity and if it exceeds lets say 10 seconds, to logout the user. Once the threshold is reached, the user is logged out and presented with a login screen. If I clos… --- ## [Report Date](https://forum.inductiveautomation.com/t/report-date/569)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 13\ **Last updated:** [February 26, 2008, 4:34pm UTC](https://forum.inductiveautomation.com/t/report-date/569 "2008-02-26T16:34:22Z")
I want to run a report, within a certain date (Date Range) and also with a condition (Radio Button). The query is something like: select this,that,other from table where date \>= start and date \<= end here's the condi… --- ## [Creating a new window](https://forum.inductiveautomation.com/t/creating-a-new-window/571)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [February 26, 2008, 4:23pm UTC](https://forum.inductiveautomation.com/t/creating-a-new-window/571 "2008-02-26T16:23:21Z")
On one of the projects I am working on, I need to create a new window. I keep getting an error message when I go to create a new window. It is this: org.xml.sax.SAXParseException: XML document structures must start a… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=44) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=46)