# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=21 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 22 --- ## [Table headings don't display extended characters](https://forum.inductiveautomation.com/t/table-headings-dont-display-extended-characters/1400)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [December 7, 2009, 6:16pm UTC](https://forum.inductiveautomation.com/t/table-headings-dont-display-extended-characters/1400 "2009-12-07T18:16:21Z")
If I try to display extended characters such as the Greek alpha (α) or beta (β) in a table header row, they initially display correctly but are replaced by '?' when the window is saved. If I try to set them from code by… --- ## [Remove column headings from table](https://forum.inductiveautomation.com/t/remove-column-headings-from-table/1397)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [December 5, 2009, 2:01pm UTC](https://forum.inductiveautomation.com/t/remove-column-headings-from-table/1397 "2009-12-05T14:01:37Z")
I have a table which needs multiple column headings e.g. a name for each column, then a group name for the first 4 columns, another for the next 3 columns etc. I can't find a way to do this with the standard table. I … --- ## [Prompt for Commit Changes](https://forum.inductiveautomation.com/t/prompt-for-commit-changes/1396)
**Author:** [@Jarrod](https://forum.inductiveautomation.com/u/Jarrod)\ **Replies:** 2\ **Last updated:** [December 4, 2009, 7:44pm UTC](https://forum.inductiveautomation.com/t/prompt-for-commit-changes/1396 "2009-12-04T19:44:30Z")
I have a window that I call with one Passed Parameter. Every time I close the window in Designer or Runtime, A dialog box pops up asking if I would like to commit changes. I only have one Dynamic Property, and the acti… --- ## [Convert a tall table into a long table](https://forum.inductiveautomation.com/t/convert-a-tall-table-into-a-long-table/1394)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 1\ **Last updated:** [December 3, 2009, 4:22pm UTC](https://forum.inductiveautomation.com/t/convert-a-tall-table-into-a-long-table/1394 "2009-12-03T16:22:24Z")
I’m trying to convert a tall table into a long table for use with the Editable Table. Table name is daily\_data, columns are date(pk), parameter\_id(pk), value. I’m looking to pull this data into an editable table whe… --- ## [Special character º in label doesn't copy correctly](https://forum.inductiveautomation.com/t/special-character-in-label-doesnt-copy-correctly/1395)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [December 3, 2009, 4:39am UTC](https://forum.inductiveautomation.com/t/special-character-in-label-doesnt-copy-correctly/1395 "2009-12-03T04:39:37Z")
I have a label on a tank that displays the last temperature. The label text property is bound to this: {Root Container.ctrEast.ctrTank1.LastTemp} + "º" The "º" symbol for degrees is Alt-167. When I copy this tank co… --- ## [Playing a .wav file from the database on FPMI clients](https://forum.inductiveautomation.com/t/playing-a-wav-file-from-the-database-on-fpmi-clients/224)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 7\ **Last updated:** [December 1, 2009, 11:03pm UTC](https://forum.inductiveautomation.com/t/playing-a-wav-file-from-the-database-on-fpmi-clients/224 "2009-12-01T23:03:51Z")
This will allow you to play sound files on any FactoryPMI client. The approach only downloads the audio when it needs to be played and does not rely on any shared network or local media to store the files - it uses the S… --- ## [Set control focus from code](https://forum.inductiveautomation.com/t/set-control-focus-from-code/1389)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 6\ **Last updated:** [December 1, 2009, 12:52am UTC](https://forum.inductiveautomation.com/t/set-control-focus-from-code/1389 "2009-12-01T00:52:43Z")
Is there any way to set focus to a particular control using code? What I'm trying to do is check the value of a numeric text field after it's been changed. If it exceeds a certain value, warn the user and check they wa… --- ## [Problem using Global Event Keystroke](https://forum.inductiveautomation.com/t/problem-using-global-event-keystroke/1392)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 5\ **Last updated:** [November 30, 2009, 11:27pm UTC](https://forum.inductiveautomation.com/t/problem-using-global-event-keystroke/1392 "2009-11-30T23:27:04Z")
I'm trying to launch a particular window whenever a key is pressed, by putting fpmi.nav.windowName in a Global Event Keystroke script. I've found that the key press doesn't work unless the user first interacts with a co… --- ## [Window Focus lost behind other windows](https://forum.inductiveautomation.com/t/window-focus-lost-behind-other-windows/1390)
**Author:** [@rthomas](https://forum.inductiveautomation.com/u/rthomas)\ **Replies:** 2\ **Last updated:** [November 30, 2009, 9:20pm UTC](https://forum.inductiveautomation.com/t/window-focus-lost-behind-other-windows/1390 "2009-11-30T21:20:05Z")
doing this in the "main" window if event.button == event.BUTTON1: fpmi.nav.openWindow('Cooling Unit Status Display', {'UnitString' : param1, 'TagPath' : param2, 'dbPath' : param3}) fpmi.nav.centerWindow('Cooling Uni… --- ## [Import Window](https://forum.inductiveautomation.com/t/import-window/1388)
**Author:** [@terryg42](https://forum.inductiveautomation.com/u/terryg42)\ **Replies:** 2\ **Last updated:** [November 30, 2009, 9:15pm UTC](https://forum.inductiveautomation.com/t/import-window/1388 "2009-11-30T21:15:32Z")
When I try to import a window in designer...I right click on an existing window and get the drop down menu. I click on import window and it looks for \*.fwin files...when I locate the file I want to import I click on it … --- ## [Creating and adding to a dataset](https://forum.inductiveautomation.com/t/creating-and-adding-to-a-dataset/1391)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 5\ **Last updated:** [November 30, 2009, 8:47pm UTC](https://forum.inductiveautomation.com/t/creating-and-adding-to-a-dataset/1391 "2009-11-30T20:47:05Z")
I'm trying to create a dataset of a user's roles on startup and pass them to a window for display in a list. I've tried the following code data = \[\] for role in fpmi.security.getRoles(): data = fpmi.dataset.addRow(… --- ## [ERROR(304): Connection Error: Cannot get a connection, pool](https://forum.inductiveautomation.com/t/error-304-connection-error-cannot-get-a-connection-pool/1387)
**Author:** [@Robert](https://forum.inductiveautomation.com/u/Robert)\ **Replies:** 4\ **Last updated:** [November 27, 2009, 10:37pm UTC](https://forum.inductiveautomation.com/t/error-304-connection-error-cannot-get-a-connection-pool/1387 "2009-11-27T22:37:43Z")
We used to get this error a fair bit. Then we reworked the app and tweaked the number of connections and things seemed to be working. Today the customer called with the error on his screen: Gateway Error 304: Connectio… --- ## [System.retarget to previous screen (within project)?](https://forum.inductiveautomation.com/t/system-retarget-to-previous-screen-within-project/1386)
**Author:** [@rthomas](https://forum.inductiveautomation.com/u/rthomas)\ **Replies:** 3\ **Last updated:** [November 22, 2009, 12:32am UTC](https://forum.inductiveautomation.com/t/system-retarget-to-previous-screen-within-project/1386 "2009-11-22T00:32:17Z")
Is there a way to use system.retarget to return to the "Calling" screen I have a project "projectA" "screenZ" that uses system.retarget to jump to another project/screen "project B/screenQ". I'd like to return back t… --- ## [Msqld.exe has a problem and needs to close](https://forum.inductiveautomation.com/t/msqld-exe-has-a-problem-and-needs-to-close/1385)
**Author:** [@rwzelnick](https://forum.inductiveautomation.com/u/rwzelnick)\ **Replies:** 1\ **Last updated:** [November 19, 2009, 6:04pm UTC](https://forum.inductiveautomation.com/t/msqld-exe-has-a-problem-and-needs-to-close/1385 "2009-11-19T18:04:53Z")
I get this message when restarting my computer. I tried starting it with the mysql administrator, I get "could not connect to the specified instance". I run through the mySQL Server Instance Config Wizard and after hitt… --- ## [XML documet structures Error](https://forum.inductiveautomation.com/t/xml-documet-structures-error/1379)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 1\ **Last updated:** [November 19, 2009, 5:02pm UTC](https://forum.inductiveautomation.com/t/xml-documet-structures-error/1379 "2009-11-19T17:02:51Z")
Periodically we experience an "XML document structures must start and end within the same entity" fault. This causes tags to go stale, and to get rid of the fault requires a gateway restart. Any Ideas? --- ## [Column Selector Layout](https://forum.inductiveautomation.com/t/column-selector-layout/1384)
**Author:** [@david\_mccutchen](https://forum.inductiveautomation.com/u/david_mccutchen)\ **Replies:** 0\ **Last updated:** [November 19, 2009, 4:47pm UTC](https://forum.inductiveautomation.com/t/column-selector-layout/1384 "2009-11-19T16:47:45Z")
I would like the selections in the column selector to layout Vertically with scroll. The only thing it will do right know is Horizontal. I can click the "normal widths button" several times and they will stack up vertica… --- ## [Another List Question](https://forum.inductiveautomation.com/t/another-list-question/1011)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 20\ **Last updated:** [November 19, 2009, 3:30am UTC](https://forum.inductiveautomation.com/t/another-list-question/1011 "2009-11-19T03:30:56Z")
I’m using your List component in multiple interval mode to create a multi-select drop-down list. I assume that multi-select isn’t possible with your drop-down list component, right? Anyway, that’s why I went this route. … --- ## [FSQL writing to Google Spreadsheet?](https://forum.inductiveautomation.com/t/fsql-writing-to-google-spreadsheet/1381)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 1\ **Last updated:** [November 18, 2009, 6:47pm UTC](https://forum.inductiveautomation.com/t/fsql-writing-to-google-spreadsheet/1381 "2009-11-18T18:47:02Z")
Would it be possible to create a feature to allow connection to a Google Spreadsheet as a data source? This would make for a simple way to provide web based status pages that could be accessed from mobile phone browsers … --- ## [Configure: Indirect SQLTag](https://forum.inductiveautomation.com/t/configure-indirect-sqltag/710)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 2\ **Last updated:** [November 16, 2009, 5:17pm UTC](https://forum.inductiveautomation.com/t/configure-indirect-sqltag/710 "2009-11-16T17:17:19Z")
Hey guys. I would like to have an Indirect Tag opion when configuring buttons (or other actions for that matter). That would sure be nice. I'm spoiled by that option when binding elsewhere. Thanks a ton! --- ## [Error Gateway connection lost](https://forum.inductiveautomation.com/t/error-gateway-connection-lost/1378)
**Author:** [@Shailesh](https://forum.inductiveautomation.com/u/Shailesh)\ **Replies:** 1\ **Last updated:** [November 14, 2009, 10:20pm UTC](https://forum.inductiveautomation.com/t/error-gateway-connection-lost/1378 "2009-11-14T22:20:53Z")
Dear Carl, While I am accessing application from client on WAN I m getting this error so many times. Regards Shailesh --- ## [Changing the default name of a pdf in report viewer](https://forum.inductiveautomation.com/t/changing-the-default-name-of-a-pdf-in-report-viewer/1377)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [November 13, 2009, 9:50pm UTC](https://forum.inductiveautomation.com/t/changing-the-default-name-of-a-pdf-in-report-viewer/1377 "2009-11-13T21:50:09Z")
How can I make the default name change from report.pdf to a dynamic value when using report viewer? --- ## [Printing a specific page from a report](https://forum.inductiveautomation.com/t/printing-a-specific-page-from-a-report/1374)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [November 13, 2009, 12:46am UTC](https://forum.inductiveautomation.com/t/printing-a-specific-page-from-a-report/1374 "2009-11-13T00:46:34Z")
I have done a report screen using the reporting plug in. When it returns data there is more than one page of information. As you know at the bottom of the report is arrows where you can scroll thru the various pages. Wh… --- ## [Java2d and Paintable Canvas](https://forum.inductiveautomation.com/t/java2d-and-paintable-canvas/1308)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 9\ **Last updated:** [November 12, 2009, 3:09am UTC](https://forum.inductiveautomation.com/t/java2d-and-paintable-canvas/1308 "2009-11-12T03:09:10Z")
First off, I LOVE the paintable canvas. Only one problem.... Not familiar with Java2d code. So, here's my question: Is there some way to DRAW and image, say in a program SIMILAR to AutoCAD and then have it RENDER the … --- ## [Data Logging at Precise Sampling Frequency wrt Timestamp](https://forum.inductiveautomation.com/t/data-logging-at-precise-sampling-frequency-wrt-timestamp/1375)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 1\ **Last updated:** [November 11, 2009, 5:39pm UTC](https://forum.inductiveautomation.com/t/data-logging-at-precise-sampling-frequency-wrt-timestamp/1375 "2009-11-11T17:39:06Z")
I have a required of logging data at a frequcny of 500 millisec. I have tried various options but i cannot seem to allign the timestamp. e.g the timestamp should be hh:mm:ss.000 hh:mm:ss.500 hh:mm:ss.000 hh:mm:ss.500 .… --- ## [Ignore if sum=null](https://forum.inductiveautomation.com/t/ignore-if-sum-null/1376)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 3\ **Last updated:** [November 11, 2009, 1:33pm UTC](https://forum.inductiveautomation.com/t/ignore-if-sum-null/1376 "2009-11-11T13:33:30Z")
Hi guys! I have the following MSSQL query: SELECT ModuleID, SUM(CASE ST80\_Image\_3\_Complete When 0 THEN 1 else NULL end) AS CapCrimp FROM ST080\_Pallet\_info Where ST80\_Rejected=-1 Group by moduleID order by moduleID Th… --- ## [Redundant OPC Server Connections](https://forum.inductiveautomation.com/t/redundant-opc-server-connections/1372)
**Author:** [@fahadfrq](https://forum.inductiveautomation.com/u/fahadfrq)\ **Replies:** 4\ **Last updated:** [November 11, 2009, 8:54am UTC](https://forum.inductiveautomation.com/t/redundant-opc-server-connections/1372 "2009-11-11T08:54:45Z")
Hi, I am looking into a FactorySQL system design in which, if I install the OPC Server on all redundant FactorySQL nodes and the conenction in my project is localhost, if a master goes down completely, will the slave or … --- ## [Refresh a text field or drop down list](https://forum.inductiveautomation.com/t/refresh-a-text-field-or-drop-down-list/1370)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 5\ **Last updated:** [November 10, 2009, 10:49pm UTC](https://forum.inductiveautomation.com/t/refresh-a-text-field-or-drop-down-list/1370 "2009-11-10T22:49:54Z")
What is the sytax for refreshing a text field or drop down list, for the component table I use the word table, I've tried this with text and text filed and dropdown and I get errors. --- ## [Error while adding exression on Start Date property](https://forum.inductiveautomation.com/t/error-while-adding-exression-on-start-date-property/1368)
**Author:** [@Shailesh](https://forum.inductiveautomation.com/u/Shailesh)\ **Replies:** 3\ **Last updated:** [November 10, 2009, 6:41pm UTC](https://forum.inductiveautomation.com/t/error-while-adding-exression-on-start-date-property/1368 "2009-11-10T18:41:49Z")
Dear Carl, As per the summary page trends provided by IA in Demo application ,same trends we have configure in our application. I want to add manual mode for selection and when user will select manual mode it has to ta… --- ## [Referencing bits within words](https://forum.inductiveautomation.com/t/referencing-bits-within-words/1109)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 6\ **Last updated:** [November 10, 2009, 2:59pm UTC](https://forum.inductiveautomation.com/t/referencing-bits-within-words/1109 "2009-11-10T14:59:54Z")
Simple question. I was wondering if there is any way to reference an individual bit of a word. Basically, I have a tag defined in my OPC server as a word and I would like to monitor the individual bits to see if they cha… --- ## [Alert filtering](https://forum.inductiveautomation.com/t/alert-filtering/1216)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 11\ **Last updated:** [November 10, 2009, 2:50pm UTC](https://forum.inductiveautomation.com/t/alert-filtering/1216 "2009-11-10T14:50:42Z")
OK, now that my alarms are displayed in FPMI with recipe and batch with the following code: SELECT L.item\_name, L.state\_name, L.active\_time, (SELECT R.recipe\_name FROM recipes R WHERE R.line\_id=LEFT(L.… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=20) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=22)