# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=35 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 36 --- ## [Tab sequence](https://forum.inductiveautomation.com/t/tab-sequence/948)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 5\ **Last updated:** [January 16, 2009, 3:45pm UTC](https://forum.inductiveautomation.com/t/tab-sequence/948 "2009-01-16T15:45:20Z")
Is it possible to keep the tab sequence looping in one container instead of going to each item in 1 container and then going to the other container? --- ## [Change numberFormat on table component](https://forum.inductiveautomation.com/t/change-numberformat-on-table-component/949)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [January 16, 2009, 9:31am UTC](https://forum.inductiveautomation.com/t/change-numberformat-on-table-component/949 "2009-01-16T09:31:33Z")
I have a component table that is populated by a dynamic SQL query depending on user selected options. When it contains data of a specific type, I would like to change the numberFormat for that column to 3 decimal places… --- ## [Disabling an individual alarm](https://forum.inductiveautomation.com/t/disabling-an-individual-alarm/945)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 4\ **Last updated:** [January 15, 2009, 9:22pm UTC](https://forum.inductiveautomation.com/t/disabling-an-individual-alarm/945 "2009-01-15T21:22:35Z")
In my application, I would like to give the user the ability to disable certain alarm levels for a given point, let's say through a serious of check boxes. I would like to do this without removing the actual stored se… --- ## [ListBox/Tables being disabled?](https://forum.inductiveautomation.com/t/listbox-tables-being-disabled/944)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [January 15, 2009, 5:23pm UTC](https://forum.inductiveautomation.com/t/listbox-tables-being-disabled/944 "2009-01-15T17:23:06Z")
I'm assuming this is a bug, although I havent heard of anyone having this problem. It seems that setting the Enabled attribute of a table or listbox to false still allows the user to select from the list, and even edit e… --- ## [Communications link failure due to underlying exception:](https://forum.inductiveautomation.com/t/communications-link-failure-due-to-underlying-exception/943)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 3\ **Last updated:** [January 15, 2009, 2:37pm UTC](https://forum.inductiveautomation.com/t/communications-link-failure-due-to-underlying-exception/943 "2009-01-15T14:37:01Z")
I hate to just post a random error here and expect a solution, but this problem is something that I just can't figure out. When I launch my application for the first time each day, I usually get about 5 SQL errors, resul… --- ## [Populating the column attribute table](https://forum.inductiveautomation.com/t/populating-the-column-attribute-table/941)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [January 15, 2009, 1:14am UTC](https://forum.inductiveautomation.com/t/populating-the-column-attribute-table/941 "2009-01-15T01:14:31Z")
How do I populate the table of column attributes for a particular table? --- ## [Create an auto look up box](https://forum.inductiveautomation.com/t/create-an-auto-look-up-box/939)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [January 13, 2009, 11:41pm UTC](https://forum.inductiveautomation.com/t/create-an-auto-look-up-box/939 "2009-01-13T23:41:24Z")
I need to create an auto look up box, the process would be as follows, you would type the first letter of a part number in a text box and a row selector would goto the first line in the table that starts with the value t… --- ## [FactoryPMI designer not connecting to gateway](https://forum.inductiveautomation.com/t/factorypmi-designer-not-connecting-to-gateway/937)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [January 13, 2009, 6:29pm UTC](https://forum.inductiveautomation.com/t/factorypmi-designer-not-connecting-to-gateway/937 "2009-01-13T18:29:14Z")
I just rebooted my virtual machine running the FactoryPMI software. From within that virtual machine, I cannot connect to gateway with the designer. However, the Gateway status monitor is working, along with the web inte… --- ## [Paint Component](https://forum.inductiveautomation.com/t/paint-component/935)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [January 12, 2009, 10:33pm UTC](https://forum.inductiveautomation.com/t/paint-component/935 "2009-01-12T22:33:18Z")
The paint component is doing something I didn't expect. Here's what I've done: I have a screen with two paint components. They are the exact same size, and are overlayed on top of each other. In one component, I draw a… --- ## [Chart Dataset with None does not Autoscale](https://forum.inductiveautomation.com/t/chart-dataset-with-none-does-not-autoscale/934)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [January 12, 2009, 9:57pm UTC](https://forum.inductiveautomation.com/t/chart-dataset-with-none-does-not-autoscale/934 "2009-01-12T21:57:45Z")
I am creating a chart that may have None entries in the dataset. It appears that when the dataset has None the auto scale on the Y axis does not work. The Y axis is just blank and none of the data points are shown. If… --- ## [Dropdown box type ahead feature doesn't like "-"](https://forum.inductiveautomation.com/t/dropdown-box-type-ahead-feature-doesnt-like/929)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 7\ **Last updated:** [January 12, 2009, 9:37pm UTC](https://forum.inductiveautomation.com/t/dropdown-box-type-ahead-feature-doesnt-like/929 "2009-01-12T21:37:47Z")
On a dropdown box, if the user starts to type the entry in the listing, it jumps to that element. It seems though when we have a listing of codes that contain a hyphen in the code, it does not go further than that point… --- ## [Checking quality of SQLTag in Jython](https://forum.inductiveautomation.com/t/checking-quality-of-sqltag-in-jython/652)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [January 12, 2009, 8:53pm UTC](https://forum.inductiveautomation.com/t/checking-quality-of-sqltag-in-jython/652 "2009-01-12T20:53:22Z")
I want to check the value of a SQLTag point before writing to an output. What I planned to do was check the Quality property of the point using the fpmi.tag.getTagValue function to check the value was good, then read th… --- ## [Calling a function from another function](https://forum.inductiveautomation.com/t/calling-a-function-from-another-function/933)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [January 12, 2009, 5:00pm UTC](https://forum.inductiveautomation.com/t/calling-a-function-from-another-function/933 "2009-01-12T17:00:47Z")
I'm having a problem structuring my Jython code. What I'm trying to do is call one function from another function, but I keep getting a NameError. I'm using the following code: def A(): print B() return def B(): … --- ## [Isalpha() not working on queried value](https://forum.inductiveautomation.com/t/isalpha-not-working-on-queried-value/927)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [January 12, 2009, 3:45pm UTC](https://forum.inductiveautomation.com/t/isalpha-not-working-on-queried-value/927 "2009-01-12T15:45:19Z")
I have a runQuery statement that returns a record from a database. When I try using the isalpha function on the result it always evaluates to 0. any ideas? result = fpmi.db.runQuery("SELECT column FROM table WHERE I… --- ## [Problems with data not being populated or being deleted](https://forum.inductiveautomation.com/t/problems-with-data-not-being-populated-or-being-deleted/931)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 10, 2009, 7:18pm UTC](https://forum.inductiveautomation.com/t/problems-with-data-not-being-populated-or-being-deleted/931 "2009-01-10T19:18:53Z")
Here is a question concerning Factory SQL. In our primary data collection system we are using Horner NX PLC's which use Modbus TCP/IP as their connection to OPC. We recently purchased 10 machines which have Mitsubishi PL… --- ## [newValue in dropdown property change](https://forum.inductiveautomation.com/t/newvalue-in-dropdown-property-change/930)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [January 9, 2009, 11:22pm UTC](https://forum.inductiveautomation.com/t/newvalue-in-dropdown-property-change/930 "2009-01-09T23:22:23Z")
I am trying to use the newValue when a dropdown box is changed. When I print the newValue it prints three lines. I believe the three lines are the index, selected value, and selected label. My question is how do I jus… --- ## [Reporting Plug in sorting question](https://forum.inductiveautomation.com/t/reporting-plug-in-sorting-question/928)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [January 8, 2009, 6:26pm UTC](https://forum.inductiveautomation.com/t/reporting-plug-in-sorting-question/928 "2009-01-08T18:26:03Z")
I have been working with the reporting plug in. On a page I have designed I have a drop down box and the report. Here are the two thinks I would like to know if can be done. The data, which is the string portion of th… --- ## [Error exporting selected table lines to Excel](https://forum.inductiveautomation.com/t/error-exporting-selected-table-lines-to-excel/926)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [January 7, 2009, 7:49pm UTC](https://forum.inductiveautomation.com/t/error-exporting-selected-table-lines-to-excel/926 "2009-01-07T19:49:52Z")
I have an fpmi table that the users select rows from and export them to Excel. I sometimes get an error, which I think may be because some of the fields are null and I can't seem to get this to work. Here is what I ha… --- ## [Hiding About box to restrict access to gateway](https://forum.inductiveautomation.com/t/hiding-about-box-to-restrict-access-to-gateway/925)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 1\ **Last updated:** [January 7, 2009, 12:40am UTC](https://forum.inductiveautomation.com/t/hiding-about-box-to-restrict-access-to-gateway/925 "2009-01-07T00:40:41Z")
Hello (again).. I am currently looking for a way to restrict access to the gateway project list (mysite:8005/) without restricting access to the project itself. Now, since the only time a customer would see a link to our… --- ## [getIpAddress() returning internal IP?](https://forum.inductiveautomation.com/t/getipaddress-returning-internal-ip/924)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 2\ **Last updated:** [January 5, 2009, 10:45pm UTC](https://forum.inductiveautomation.com/t/getipaddress-returning-internal-ip/924 "2009-01-05T22:45:17Z")
I am running an application that executes SQL queries based on a user's IP address. However, it seems that getIpAddress() is returning the internal IP of the connected user, not the external IP. For my application to fun… --- ## [Show Charts Third Column Value in ToolTip](https://forum.inductiveautomation.com/t/show-charts-third-column-value-in-tooltip/923)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [January 3, 2009, 1:07am UTC](https://forum.inductiveautomation.com/t/show-charts-third-column-value-in-tooltip/923 "2009-01-03T01:07:53Z")
Is it possible to have a tooltip on a chart show a value from a third column in the dataset? In my case I have the Name on the X axis the value on the Y axis and I would like to show the date of the data point when hove… --- ## [Switching projects prompt won't allow "." in the username](https://forum.inductiveautomation.com/t/switching-projects-prompt-wont-allow-in-the-username/920)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [December 31, 2008, 11:02pm UTC](https://forum.inductiveautomation.com/t/switching-projects-prompt-wont-allow-in-the-username/920 "2008-12-31T23:02:47Z")
I am adding a button on one project to allow some of the users to switch to a different one and that works fine. I notice in my testing, when switching from one project with autologon set up to another more secure one t… --- ## [Manual/Auto-Acknowledging of Alarms](https://forum.inductiveautomation.com/t/manual-auto-acknowledging-of-alarms/918)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 3\ **Last updated:** [December 31, 2008, 8:58pm UTC](https://forum.inductiveautomation.com/t/manual-auto-acknowledging-of-alarms/918 "2008-12-31T20:58:14Z")
I was unsure as to whether or not I should post this in the FactoryPMI or FactorySQL section. I was looking through the IA Demo application and saw that alarms are being Auto-Acknowledged on the Alarm History screen. I… --- ## [Error if exceeds 9999 lines in editable table](https://forum.inductiveautomation.com/t/error-if-exceeds-9999-lines-in-editable-table/916)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [December 31, 2008, 8:11am UTC](https://forum.inductiveautomation.com/t/error-if-exceeds-9999-lines-in-editable-table/916 "2008-12-31T08:11:45Z")
I have a table populated by a query that returns 11762 rows. If I edit a value in the new editable table I get the following error. If I change the query to return the Top 9999 rows, then I don't get this error and I … --- ## [Easy Chart Y axis labels moved to the right](https://forum.inductiveautomation.com/t/easy-chart-y-axis-labels-moved-to-the-right/917)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 1\ **Last updated:** [December 31, 2008, 12:13am UTC](https://forum.inductiveautomation.com/t/easy-chart-y-axis-labels-moved-to-the-right/917 "2008-12-31T00:13:32Z")
I can't seem to force the Y axis labels to display to the right of the easy chart if there's only one axis. It would be easier to read the chart if the values were on the right where the most recent data is displayed. Is… --- ## [Dynamically modifying chart axes during runtime](https://forum.inductiveautomation.com/t/dynamically-modifying-chart-axes-during-runtime/913)
**Author:** [@skenealy](https://forum.inductiveautomation.com/u/skenealy)\ **Replies:** 7\ **Last updated:** [December 30, 2008, 1:49am UTC](https://forum.inductiveautomation.com/t/dynamically-modifying-chart-axes-during-runtime/913 "2008-12-30T01:49:47Z")
I've got a project where we have multiple charts that all should be set to the same scale, but the bounds are determined (and will change) during runtime. I see that axis objects have properties that may be modified in a… --- ## [Editable table null exception when changing cell](https://forum.inductiveautomation.com/t/editable-table-null-exception-when-changing-cell/915)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [December 29, 2008, 9:49pm UTC](https://forum.inductiveautomation.com/t/editable-table-null-exception-when-changing-cell/915 "2008-12-29T21:49:26Z")
I have a table that I made editable. When a cell is changed I use the cell edited event and run an update statement. The problem is when a column is initially NULL and I try changing the value of the that columns cell I… --- ## [Easy Chart Pen Frame Title](https://forum.inductiveautomation.com/t/easy-chart-pen-frame-title/907)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 7\ **Last updated:** [December 29, 2008, 7:55pm UTC](https://forum.inductiveautomation.com/t/easy-chart-pen-frame-title/907 "2008-12-29T19:55:30Z")
I wasn’t sure how to describe the component I’m inquiring about in the subject so I attached an image. Is there any way to link this title to a tag? I had trouble finding where this property is defined. Thanks in advanc… --- ## [Format of Table Column not Changing](https://forum.inductiveautomation.com/t/format-of-table-column-not-changing/903)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 6\ **Last updated:** [December 29, 2008, 6:44pm UTC](https://forum.inductiveautomation.com/t/format-of-table-column-not-changing/903 "2008-12-29T18:44:39Z")
I have a table with two columns that are being populated from a SQL query. The first column is an integer and the second is a concatenated string from various columns of joined tables. The problem is when the fpmi win… --- ## [Grouping Pagination with Report Designer](https://forum.inductiveautomation.com/t/grouping-pagination-with-report-designer/912)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 2\ **Last updated:** [December 29, 2008, 5:45pm UTC](https://forum.inductiveautomation.com/t/grouping-pagination-with-report-designer/912 "2008-12-29T17:45:50Z")
I have made a report that uses a dataset that is populated from a stored procedure. I would like to have the pages break in the report when there is a change in one of the columns. The column contains these values 200,… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=34) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=36)