# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=39 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 40 --- ## [Click to Graph](https://forum.inductiveautomation.com/t/click-to-graph/811)
**Author:** [@jenicabecklund](https://forum.inductiveautomation.com/u/jenicabecklund)\ **Replies:** 1\ **Last updated:** [September 12, 2008, 9:23pm UTC](https://forum.inductiveautomation.com/t/click-to-graph/811 "2008-09-12T21:23:30Z")
I am brand new to FactoryPMI and wanted to setup the Click to Graph, after following instructions I tried to test it by right clicking the multistate indicator and I get this error: Traceback (innermost last): File … --- ## [Reporting Save Function](https://forum.inductiveautomation.com/t/reporting-save-function/809)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 1\ **Last updated:** [September 11, 2008, 7:01pm UTC](https://forum.inductiveautomation.com/t/reporting-save-function/809 "2008-09-11T19:01:41Z")
There are some applications where users may not have access to mouse clicks (the right click in particular) and are using a touchscreen. For their ease I have added a button to the screen to allow them to print a report … --- ## [Saving changes ouside of design mode](https://forum.inductiveautomation.com/t/saving-changes-ouside-of-design-mode/807)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [September 10, 2008, 11:36pm UTC](https://forum.inductiveautomation.com/t/saving-changes-ouside-of-design-mode/807 "2008-09-10T23:36:47Z")
Is there a way to have a button save changes to a Numeric Text Field when they are not in design mode? --- ## [SQL Express and FSQL](https://forum.inductiveautomation.com/t/sql-express-and-fsql/797)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 11\ **Last updated:** [September 3, 2008, 11:08pm UTC](https://forum.inductiveautomation.com/t/sql-express-and-fsql/797 "2008-09-03T23:08:53Z")
I have installed FSQL and SQL Express (Windows XP SP2), but when I want to make a connection in FSQL, send me the next error: "SQL Server does not allow remote connections (provider: TCP Provider, error 0)" The TCP/… --- ## [Display a value in a confirm box](https://forum.inductiveautomation.com/t/display-a-value-in-a-confirm-box/803)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [September 2, 2008, 11:09pm UTC](https://forum.inductiveautomation.com/t/display-a-value-in-a-confirm-box/803 "2008-09-02T23:09:08Z")
How would I get keyValue1 to display in the Confirm Box? keyValue1 = event.source.parent.rowselector if fpmi.gui.confirm('OK to Update Row of Data?', 'Confirm'): --- ## [Setting the startup window](https://forum.inductiveautomation.com/t/setting-the-startup-window/802)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [September 2, 2008, 8:12pm UTC](https://forum.inductiveautomation.com/t/setting-the-startup-window/802 "2008-09-02T20:12:25Z")
I have a header and a welcome screen set to open on startup. When the project is started the header has the focus. I am using the wiki help goodie to provide a help system when 'F1' is pressed. How can I set the focus to… --- ## [Cannot connect to OPC server for browse](https://forum.inductiveautomation.com/t/cannot-connect-to-opc-server-for-browse/799)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 2\ **Last updated:** [September 2, 2008, 2:48pm UTC](https://forum.inductiveautomation.com/t/cannot-connect-to-opc-server-for-browse/799 "2008-09-02T14:48:20Z")
I'm trying to use FactorySQL to retrieve data from a local KEPServer-EX OPC server. In the Frontend when I try to expand the OPC server tree to see the items configured in the OPC server I get the error message "Browse … --- ## [Restricting user input](https://forum.inductiveautomation.com/t/restricting-user-input/793)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [August 30, 2008, 5:01pm UTC](https://forum.inductiveautomation.com/t/restricting-user-input/793 "2008-08-30T17:01:21Z")
I am working on a form with a number of input boxes. These are populated from a SQL database when the form is opened and can then be edited by the user before the database is updated with the changes. The data to be e… --- ## [MSSQL Table related question](https://forum.inductiveautomation.com/t/mssql-table-related-question/801)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [August 29, 2008, 5:09pm UTC](https://forum.inductiveautomation.com/t/mssql-table-related-question/801 "2008-08-29T17:09:39Z")
I have noticed that in MySQL you can text wrap cells that contain a lot of information. A good example of this is your demo project and the help screen. I have tried doing this with MSSQL and so far have not had any luck… --- ## [Windows 64-bit](https://forum.inductiveautomation.com/t/windows-64-bit/798)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 8\ **Last updated:** [August 29, 2008, 3:45pm UTC](https://forum.inductiveautomation.com/t/windows-64-bit/798 "2008-08-29T15:45:57Z")
Does FPMI/FSQL/MySQL support Windows XP 64-bit? I am installing new servers, and the option is go to Windows 32-bit or take out 2GB of RAM. Thanks, Matt --- ## [Running external application](https://forum.inductiveautomation.com/t/running-external-application/800)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [August 29, 2008, 3:36pm UTC](https://forum.inductiveautomation.com/t/running-external-application/800 "2008-08-29T15:36:01Z")
I know I have seen it somewhere and had tried it once before but for some reason I am having a heck of time finding it. I was wondering how one would run an external application file? You know something like excel or wri… --- ## [Microsoft Access](https://forum.inductiveautomation.com/t/microsoft-access/442)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 30\ **Last updated:** [August 28, 2008, 7:13pm UTC](https://forum.inductiveautomation.com/t/microsoft-access/442 "2008-08-28T19:13:08Z")
Which connection type would I use to interface PMI with an Access database? --- ## [Factory SQL 4.1.5](https://forum.inductiveautomation.com/t/factory-sql-4-1-5/796)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [August 27, 2008, 4:23pm UTC](https://forum.inductiveautomation.com/t/factory-sql-4-1-5/796 "2008-08-27T16:23:06Z")
Can I still download a Factory SQL version 4.1.5 How? I cannot connect remotely to the machine that is running Factory SQL 4.1.5 with my machines version 4.2.5 --- ## [Easy Chart Goodie](https://forum.inductiveautomation.com/t/easy-chart-goodie/794)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [August 26, 2008, 8:08pm UTC](https://forum.inductiveautomation.com/t/easy-chart-goodie/794 "2008-08-26T20:08:29Z")
I started with the Easy Chart "click to graph" goodie but have made many changes to how the chart is loaded. I am not using the click to graph components. I have a screen with list boxes that select the pens to use. I … --- ## [Automating FactoryPMI backup](https://forum.inductiveautomation.com/t/automating-factorypmi-backup/779)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 5\ **Last updated:** [August 26, 2008, 1:53pm UTC](https://forum.inductiveautomation.com/t/automating-factorypmi-backup/779 "2008-08-26T13:53:07Z")
At the moment backing up a FactoryPMI server is a manual process which has to be carried out after any change to the server or the projects it contains. It would be nice to have an option to backup the server (and/or pr… --- ## [Wrap Text for Tables](https://forum.inductiveautomation.com/t/wrap-text-for-tables/790)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [August 26, 2008, 1:51pm UTC](https://forum.inductiveautomation.com/t/wrap-text-for-tables/790 "2008-08-26T13:51:17Z")
Is it possible to have text wrap for tables. It is a feature from excell that has been very useful. --- ## [Numeric Label](https://forum.inductiveautomation.com/t/numeric-label/791)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 2\ **Last updated:** [August 25, 2008, 8:23pm UTC](https://forum.inductiveautomation.com/t/numeric-label/791 "2008-08-25T20:23:17Z")
Hello, A slight problem here: I have a numeric label bound to an SQLTag. When I try to add a 'units' value such as 'psi' or '°F' it seems to work until the value changes or I save the project. At this point, the 'u… --- ## [Unable to retrieve gateway status](https://forum.inductiveautomation.com/t/unable-to-retrieve-gateway-status/789)
**Author:** [@Maithen](https://forum.inductiveautomation.com/u/Maithen)\ **Replies:** 3\ **Last updated:** [August 24, 2008, 11:34pm UTC](https://forum.inductiveautomation.com/t/unable-to-retrieve-gateway-status/789 "2008-08-24T23:34:11Z")
I just installed FPMI and FSQL on a newly installed Windows XP PC. Java was installed together with the IA unified installer. I keep getting the error: gateway is not running. The FMPI service is not running and when … --- ## [Bug - Using Tiled Panel in Borders](https://forum.inductiveautomation.com/t/bug-using-tiled-panel-in-borders/752)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [August 21, 2008, 10:02pm UTC](https://forum.inductiveautomation.com/t/bug-using-tiled-panel-in-borders/752 "2008-08-21T22:02:00Z")
If you design a numeric box using a Tile Panel in the border options, and then go into preview mode and click the selector into the numeric box, then go back to design mode and click save, you will loose Tile Panel Borde… --- ## [Property Binding](https://forum.inductiveautomation.com/t/property-binding/788)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 4\ **Last updated:** [August 21, 2008, 9:47pm UTC](https://forum.inductiveautomation.com/t/property-binding/788 "2008-08-21T21:47:00Z")
Just a curiosity here: In terms of 'bindable properties', why is the visibility of a component not bindable? I have had many cases where I would like to tie some properties of a component to its visibility and have had t… --- ## [Text Area problems](https://forum.inductiveautomation.com/t/text-area-problems/724)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [August 21, 2008, 7:02pm UTC](https://forum.inductiveautomation.com/t/text-area-problems/724 "2008-08-21T19:02:26Z")
I was using a Text Area control to display a text file - this file has nearly 86,000 characters in it. I loaded the file into the text Area and then clicked on the data in the Text property in the Property Editor. I t… --- ## [Serialization Problem](https://forum.inductiveautomation.com/t/serialization-problem/787)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 4\ **Last updated:** [August 21, 2008, 7:00pm UTC](https://forum.inductiveautomation.com/t/serialization-problem/787 "2008-08-21T19:00:47Z")
I had just learned to deal with this problem, but I saw there were some bugs with the same issue fixed on other versions of PMI, so here goes. I have noticed that there has been an "error during serialization..." during … --- ## [Most Efficient?](https://forum.inductiveautomation.com/t/most-efficient/786)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [August 21, 2008, 3:31pm UTC](https://forum.inductiveautomation.com/t/most-efficient/786 "2008-08-21T15:31:11Z")
I was wondering, i have been trying various things and I would like to know if this is the most efficient way of doing a certain task. The task is I have two SQL tags for each of the containers on a page within PMI. De… --- ## [Database Daily Totals](https://forum.inductiveautomation.com/t/database-daily-totals/785)
**Author:** [@JoshMan](https://forum.inductiveautomation.com/u/JoshMan)\ **Replies:** 4\ **Last updated:** [August 20, 2008, 9:08pm UTC](https://forum.inductiveautomation.com/t/database-daily-totals/785 "2008-08-20T21:08:02Z")
Hey, I am creating a database that keeps track of shipment weights. They are time stamped and archived for one month. How would I go about making another database table, or a function that can find the totals per … --- ## [Java Table Component Column Sorting](https://forum.inductiveautomation.com/t/java-table-component-column-sorting/784)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 2\ **Last updated:** [August 20, 2008, 4:10pm UTC](https://forum.inductiveautomation.com/t/java-table-component-column-sorting/784 "2008-08-20T16:10:16Z")
I was wondering if there was a property of the Table component that displayed which column was sorted: i.e. If column A,B,C was sorted, if any, and if it were ascending or descending. The purpose of this is that we have … --- ## [Re-ordering columns](https://forum.inductiveautomation.com/t/re-ordering-columns/782)
**Author:** [@norml](https://forum.inductiveautomation.com/u/norml)\ **Replies:** 3\ **Last updated:** [August 19, 2008, 5:48pm UTC](https://forum.inductiveautomation.com/t/re-ordering-columns/782 "2008-08-19T17:48:35Z")
Is there a way to re-order the columns in a table. I found nothing in help files and the table customizer doesn't allow it (unless I'm missing something). I even tried doing it in DB Tools but it won't allow me to save… --- ## [\[System\]Client/User/CurrentWindow](https://forum.inductiveautomation.com/t/system-client-user-currentwindow/781)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 5\ **Last updated:** [August 18, 2008, 5:06pm UTC](https://forum.inductiveautomation.com/t/system-client-user-currentwindow/781 "2008-08-18T17:06:01Z")
I imported the Wiki Help pages from the IADemo project. The \[System\]Client/User/CurrentWindow tag does not update when I change windows. Is there some setting I need to change? --- ## [Listbox Selected Value](https://forum.inductiveautomation.com/t/listbox-selected-value/780)
**Author:** [@JoshMan](https://forum.inductiveautomation.com/u/JoshMan)\ **Replies:** 1\ **Last updated:** [August 18, 2008, 4:51pm UTC](https://forum.inductiveautomation.com/t/listbox-selected-value/780 "2008-08-18T16:51:30Z")
I am developing a program to narrow down a selection of countries/cities/areas etc. And am doing this through listboxes. I want to design a new property that uses the selectedIndex to get the selected value or text. A… --- ## [Excel opens exported chart data all in one cell](https://forum.inductiveautomation.com/t/excel-opens-exported-chart-data-all-in-one-cell/778)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 3\ **Last updated:** [August 14, 2008, 6:00pm UTC](https://forum.inductiveautomation.com/t/excel-opens-exported-chart-data-all-in-one-cell/778 "2008-08-14T18:00:05Z")
When I export data to an Excel file from easy chart it does not open properly in Excel. All of the data appears in a single cell. This seems to be some kind of version issue as it will look fine in Excel 2007 but fail in… --- ## [List box questions](https://forum.inductiveautomation.com/t/list-box-questions/777)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [August 14, 2008, 4:09pm UTC](https://forum.inductiveautomation.com/t/list-box-questions/777 "2008-08-14T16:09:58Z")
I have a list box that the supervisors can select a job from. The list box is set to allow upto 10 lines of text although all the selections are only 5 line of text long. What I want to be able to do is if they click in … [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=38) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=40)