# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=40 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 41 --- ## [Quitting a Python script early](https://forum.inductiveautomation.com/t/quitting-a-python-script-early/775)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 5\ **Last updated:** [August 13, 2008, 8:40pm UTC](https://forum.inductiveautomation.com/t/quitting-a-python-script-early/775 "2008-08-13T20:40:18Z")
I am working on a popup which contains a number of data entry controls. When the user presses the Save button, I want to carry out a number of checks to ensure the data is valid. If any one of these checks fail, I woul… --- ## [Tables - I'm missing something](https://forum.inductiveautomation.com/t/tables-im-missing-something/773)
**Author:** [@norml](https://forum.inductiveautomation.com/u/norml)\ **Replies:** 6\ **Last updated:** [August 13, 2008, 4:56pm UTC](https://forum.inductiveautomation.com/t/tables-im-missing-something/773 "2008-08-13T16:56:35Z")
I am trying to create my first table. Starting with a new table component, I did a DB Browse from the data binding pop-up window and selected my table containing 8 columns. I now have 8 column headers with no rows. No… --- ## [Spinner number format](https://forum.inductiveautomation.com/t/spinner-number-format/774)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [August 13, 2008, 4:22pm UTC](https://forum.inductiveautomation.com/t/spinner-number-format/774 "2008-08-13T16:22:01Z")
Would it be possible to make the number format of the Spinner control editable? I am using it to allow the users to enter a 4-digit year (i.e. 2008) but it defaults to inserting a comma in the number (i.e. 2,008). --- ## [FPMI Multi-Monitor Window Placement](https://forum.inductiveautomation.com/t/fpmi-multi-monitor-window-placement/765)
**Author:** [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Replies:** 4\ **Last updated:** [August 13, 2008, 10:22am UTC](https://forum.inductiveautomation.com/t/fpmi-multi-monitor-window-placement/765 "2008-08-13T10:22:29Z")
I would like to display the FPMI runtime on a 6 screen multi-monitor PC that has been defined in Windows as one contiguous logical monitor. Another application is using screen locations 1-4, and I need FPMI to use screen… --- ## [Delete records older than](https://forum.inductiveautomation.com/t/delete-records-older-than/771)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 3\ **Last updated:** [August 13, 2008, 12:27am UTC](https://forum.inductiveautomation.com/t/delete-records-older-than/771 "2008-08-13T00:27:29Z")
Hi all: when we originally created our tables we didn't bother with the option to delete all records older than xyz. As an experiment to understand how this option works, I created a test table to log some data, and ha… --- ## [Verify if Client is already running](https://forum.inductiveautomation.com/t/verify-if-client-is-already-running/770)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 2\ **Last updated:** [August 12, 2008, 5:40pm UTC](https://forum.inductiveautomation.com/t/verify-if-client-is-already-running/770 "2008-08-12T17:40:59Z")
I am attempting to not allow multiple instances of the client to run at the same time. I have a shortcut on the Windows desktop that users LOVE to press. This then opens multiple versions of the client, thus creating m… --- ## [Unitronics Uniopc server](https://forum.inductiveautomation.com/t/unitronics-uniopc-server/769)
**Author:** [@Electrotechno](https://forum.inductiveautomation.com/u/Electrotechno)\ **Replies:** 2\ **Last updated:** [August 11, 2008, 8:59pm UTC](https://forum.inductiveautomation.com/t/unitronics-uniopc-server/769 "2008-08-11T20:59:30Z")
Hi, were are working on a project with uniopc server from Unitronics. There's something different about that opc server, on some computers it seems to start by itself when FSQL starts, and then everything is ok. But … --- ## [Proceedure to downgrade](https://forum.inductiveautomation.com/t/proceedure-to-downgrade/751)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 7\ **Last updated:** [August 11, 2008, 3:09pm UTC](https://forum.inductiveautomation.com/t/proceedure-to-downgrade/751 "2008-08-11T15:09:06Z")
Due to some issues we had with the latest version 4.2.5 we choose to go back to an earlier version 4.1.5 However when we did so we had some problems. When we uninstalled the newer version then installed the older version… --- ## [Calendar component won't accept already selected date](https://forum.inductiveautomation.com/t/calendar-component-wont-accept-already-selected-date/764)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [August 8, 2008, 10:31pm UTC](https://forum.inductiveautomation.com/t/calendar-component-wont-accept-already-selected-date/764 "2008-08-08T22:31:00Z")
I have a textbox that displays the date from an SQL query. Most of the time, this value is NULL, so the textbox is blank. If the user needs to set this date, then they click on the textbox and a calendar component is m… --- ## [Chart X axis range problem](https://forum.inductiveautomation.com/t/chart-x-axis-range-problem/766)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [August 8, 2008, 8:59pm UTC](https://forum.inductiveautomation.com/t/chart-x-axis-range-problem/766 "2008-08-08T20:59:17Z")
I noticed a strange error when using the Chart object. I was using it in "XY Plot" mode with numeric axes - the X axis was set from 0 to 20, and the Y axis from 0 to 30. I then plotted 2 integer points on the chart. … --- ## [Writing result of SQL query back to database](https://forum.inductiveautomation.com/t/writing-result-of-sql-query-back-to-database/761)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 6\ **Last updated:** [August 8, 2008, 8:21pm UTC](https://forum.inductiveautomation.com/t/writing-result-of-sql-query-back-to-database/761 "2008-08-08T20:21:07Z")
I am reading data from a database which I want to average and make available to other parts of the system. I thought the best way to do this would be to read the data and then write the averages out to a temporary SQL t… --- ## [Creating a graph using 2 tables on different date structure](https://forum.inductiveautomation.com/t/creating-a-graph-using-2-tables-on-different-date-structure/762)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [August 7, 2008, 8:47pm UTC](https://forum.inductiveautomation.com/t/creating-a-graph-using-2-tables-on-different-date-structure/762 "2008-08-07T20:47:29Z")
I have 2 tables, First table is a weekly FORECAST that shows part number, quantity, and date, the date represents Mondays. Second table is a list of daily SALES, it shows the part number, quantity and date, the date… --- ## [Six Sigma Formula](https://forum.inductiveautomation.com/t/six-sigma-formula/753)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 5\ **Last updated:** [August 7, 2008, 8:27pm UTC](https://forum.inductiveautomation.com/t/six-sigma-formula/753 "2008-08-07T20:27:30Z")
Does anyone have the SQL code to perform a Six Sigma Calculation? --- ## [Uploading to 2 different tables using 1 button](https://forum.inductiveautomation.com/t/uploading-to-2-different-tables-using-1-button/763)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [August 7, 2008, 8:19pm UTC](https://forum.inductiveautomation.com/t/uploading-to-2-different-tables-using-1-button/763 "2008-08-07T20:19:43Z")
I'm currently uploading data to a table using the following script, I need to modify the script so it writes the same data to an additional table. I've this myself a few times but I can only get it to write to one or th… --- ## [Use a button for the visual property of a root container](https://forum.inductiveautomation.com/t/use-a-button-for-the-visual-property-of-a-root-container/759)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [August 7, 2008, 6:06am UTC](https://forum.inductiveautomation.com/t/use-a-button-for-the-visual-property-of-a-root-container/759 "2008-08-07T06:06:59Z")
What value would I set, for the visual property of a root container, so I can make it appear and then disappear on a screen using 2 buttons. --- ## [Indicating state of clustering](https://forum.inductiveautomation.com/t/indicating-state-of-clustering/758)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [August 5, 2008, 8:51pm UTC](https://forum.inductiveautomation.com/t/indicating-state-of-clustering/758 "2008-08-05T20:51:38Z")
Is there any way of indicating to a user the state of system clustering i.e. whether a machine has failed, what machine is currently the master etc. ? At the moment a brief dialog appears while the system is changing f… --- ## [Display two columns in a dropdown list](https://forum.inductiveautomation.com/t/display-two-columns-in-a-dropdown-list/757)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [August 5, 2008, 6:09pm UTC](https://forum.inductiveautomation.com/t/display-two-columns-in-a-dropdown-list/757 "2008-08-05T18:09:05Z")
Is there a way to display two columns from a dataset in a dropdown list? My dataset has a three columns. A key value, part number and part name. I would like the display both the part number and name in the dropdown l… --- ## [Text on buttons](https://forum.inductiveautomation.com/t/text-on-buttons/756)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 4\ **Last updated:** [August 4, 2008, 6:55pm UTC](https://forum.inductiveautomation.com/t/text-on-buttons/756 "2008-08-04T18:55:49Z")
Is there a way to get the text on a button to display other than a single line. I have been making my buttons longer to get all of the text to show up. --- ## [When pressing enter have mouse click button](https://forum.inductiveautomation.com/t/when-pressing-enter-have-mouse-click-button/755)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 5\ **Last updated:** [August 1, 2008, 8:46pm UTC](https://forum.inductiveautomation.com/t/when-pressing-enter-have-mouse-click-button/755 "2008-08-01T20:46:44Z")
Hello, I have one input box and one button. Rather then always having to click the button to advance the program I would like to press the enter key. So instead of duplicating the code from the button to the input box… --- ## [Clearing a text area](https://forum.inductiveautomation.com/t/clearing-a-text-area/754)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [July 31, 2008, 7:33pm UTC](https://forum.inductiveautomation.com/t/clearing-a-text-area/754 "2008-07-31T19:33:00Z")
How would I have a button reset a text area to “blank” when the button is clicked? --- ## [toPyDataSet issue](https://forum.inductiveautomation.com/t/topydataset-issue/750)
**Author:** [@JoshMan](https://forum.inductiveautomation.com/u/JoshMan)\ **Replies:** 2\ **Last updated:** [July 30, 2008, 3:44pm UTC](https://forum.inductiveautomation.com/t/topydataset-issue/750 "2008-07-30T15:44:09Z")
Hi, I am building a program to select from a list box a list of countries, and have the ones that you selected be displayed in a "selected" listbox. However my code to transfer the lists is not working. The current … --- ## [SELECT DISTINCT statement error](https://forum.inductiveautomation.com/t/select-distinct-statement-error/747)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 2\ **Last updated:** [July 30, 2008, 12:54pm UTC](https://forum.inductiveautomation.com/t/select-distinct-statement-error/747 "2008-07-30T12:54:24Z")
I have almost completed the large task of converting from MySQL to MSSQL and have a few issues left one of which is the folllowing. I am attempting to fill a dataset in FPMI using the following code: SELECT DISTINCT Sh… --- ## [exportExcel feature to allow naming of worksheets](https://forum.inductiveautomation.com/t/exportexcel-feature-to-allow-naming-of-worksheets/746)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [July 26, 2008, 3:15pm UTC](https://forum.inductiveautomation.com/t/exportexcel-feature-to-allow-naming-of-worksheets/746 "2008-07-26T15:15:15Z")
I recently utilized the exportExcel() function to export 3 datasets. In Excel the worksheets are named 'Dataset 1', 'Dataset 2', 'Dataset 3'. It would be great to be able to define these names when the function is called… --- ## [How to tell when to stop accumulating downtime](https://forum.inductiveautomation.com/t/how-to-tell-when-to-stop-accumulating-downtime/606)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 9\ **Last updated:** [July 25, 2008, 11:45pm UTC](https://forum.inductiveautomation.com/t/how-to-tell-when-to-stop-accumulating-downtime/606 "2008-07-25T23:45:08Z")
I know this is probably a real stupid question, but I have an application that displays line downtime and graphs each piece of equipments down time to allow users to drill down to determine what faults are causing the mo… --- ## [Charting accuracy](https://forum.inductiveautomation.com/t/charting-accuracy/682)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 5\ **Last updated:** [July 23, 2008, 6:45pm UTC](https://forum.inductiveautomation.com/t/charting-accuracy/682 "2008-07-23T18:45:42Z")
I'm interested in finding out how FactoryPMI charts data. As long term users of GE Fanuc's iFIX, we had one big bugbear with its charting - it could draw misleading plots of the data. For example, if the chart area o… --- ## [Smaller slider increment](https://forum.inductiveautomation.com/t/smaller-slider-increment/745)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 1\ **Last updated:** [July 23, 2008, 6:02pm UTC](https://forum.inductiveautomation.com/t/smaller-slider-increment/745 "2008-07-23T18:02:12Z")
Is there a way to get the slider component to move in tenth increments? I am using sliders to vary the Y axis on a classic chart. The problem is that my data ranges from 0 to 4 and the slider seems to move in the smalles… --- ## [SQL Timing Question](https://forum.inductiveautomation.com/t/sql-timing-question/742)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 17\ **Last updated:** [July 23, 2008, 4:13pm UTC](https://forum.inductiveautomation.com/t/sql-timing-question/742 "2008-07-23T16:13:33Z")
On one of my pages I have 38 containers. I have the color for these containers attached to a SQL tag which come from the \_error flag of KepServer. If the \_error is on then the color is say red and if it is off then it mi… --- ## [Add a dash in user name for hybrid security model](https://forum.inductiveautomation.com/t/add-a-dash-in-user-name-for-hybrid-security-model/744)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [July 23, 2008, 3:40pm UTC](https://forum.inductiveautomation.com/t/add-a-dash-in-user-name-for-hybrid-security-model/744 "2008-07-23T15:40:42Z")
I am using the Active Directory Hybrid security model for some projects and I have a couple of users with a dash in their logon names, which I can not add to a \[del\]roll\[/del\] role. I know you support several special ch… --- ## [Delete Query](https://forum.inductiveautomation.com/t/delete-query/743)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [July 22, 2008, 7:16pm UTC](https://forum.inductiveautomation.com/t/delete-query/743 "2008-07-22T19:16:50Z")
I am working on a screen where pen names are managed and want to delete a single row determined at run time. This is what I want to do but need to have parameters for each . fpmi.db.runUpdateQuery("DELETE FROM ctg\_s… --- ## [Logarithmic axis in charts](https://forum.inductiveautomation.com/t/logarithmic-axis-in-charts/677)
**Author:** [@kurt](https://forum.inductiveautomation.com/u/kurt)\ **Replies:** 2\ **Last updated:** [July 22, 2008, 6:31pm UTC](https://forum.inductiveautomation.com/t/logarithmic-axis-in-charts/677 "2008-07-22T18:31:23Z")
For a chart is there a way to get the axis to use a logarithmic scale? Thanks, Kurt [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=39) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=41)