# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=44 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 45 --- ## [Troubling getting value from fpmi.db.runUpdateQueryGetKey](https://forum.inductiveautomation.com/t/troubling-getting-value-from-fpmi-db-runupdatequerygetkey/638)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [April 15, 2008, 11:51pm UTC](https://forum.inductiveautomation.com/t/troubling-getting-value-from-fpmi-db-runupdatequerygetkey/638 "2008-04-15T23:51:54Z")
I am doing an insert into a database via a call to a stored proceedure in SQL server. I am running the following piece of code: BBTID = fpmi.db.runUpdateQueryGetKey("exec dbo.usp\_BBTCreateRecord '%s', '%s', '%s', '%s… --- ## [Binding a dynamic property to the text of a radio button](https://forum.inductiveautomation.com/t/binding-a-dynamic-property-to-the-text-of-a-radio-button/637)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 7\ **Last updated:** [April 15, 2008, 6:34pm UTC](https://forum.inductiveautomation.com/t/binding-a-dynamic-property-to-the-text-of-a-radio-button/637 "2008-04-15T18:34:49Z")
Hi Guys, I have a dynamic property on the root container called BBT that is a string. I have a container on the window with about 20 differnet radio buttons in it for the user to select the correct BBT. Is there a slic… --- ## [Questions concerning the Ping Routine](https://forum.inductiveautomation.com/t/questions-concerning-the-ping-routine/636)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 14, 2008, 3:07pm UTC](https://forum.inductiveautomation.com/t/questions-concerning-the-ping-routine/636 "2008-04-14T15:07:51Z")
I was wondering, I downloaded the PING module and installed it. I can use it in FSQL and I can use it in the FPMI SQLTags section. But I can not seem to get it to work under either the scriting or the expressions section… --- ## [Finding the ending letter in a string](https://forum.inductiveautomation.com/t/finding-the-ending-letter-in-a-string/626)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [April 12, 2008, 10:30pm UTC](https://forum.inductiveautomation.com/t/finding-the-ending-letter-in-a-string/626 "2008-04-12T22:30:09Z")
I have the following code snipit that I am trying to determine which tanks end with the letter 'T' and put them into the list transferList. I get an error on the line "if tank.endswith('T')". I give up. What am I doin… --- ## [Layout Mode Problem](https://forum.inductiveautomation.com/t/layout-mode-problem/634)
**Author:** [@neato20](https://forum.inductiveautomation.com/u/neato20)\ **Replies:** 7\ **Last updated:** [April 10, 2008, 10:34pm UTC](https://forum.inductiveautomation.com/t/layout-mode-problem/634 "2008-04-10T22:34:03Z")
So I have a minor issue that I would love to get an answer to. I am designing my windows in the design mode and am having trouble with the Layout Mode on just one window. All of my windows start out at a specified size a… --- ## [Can I pass a dataset into a script module](https://forum.inductiveautomation.com/t/can-i-pass-a-dataset-into-a-script-module/632)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [April 10, 2008, 3:47pm UTC](https://forum.inductiveautomation.com/t/can-i-pass-a-dataset-into-a-script-module/632 "2008-04-10T15:47:36Z")
I have a label that has the text value bound to a script module runScript("app.faultState.Depal({Root Container.dsDepal1})") I would like to pass a dataset into a script module, but I get an error when I call it this… --- ## [Creating Links to open pdf files](https://forum.inductiveautomation.com/t/creating-links-to-open-pdf-files/631)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [April 10, 2008, 12:59am UTC](https://forum.inductiveautomation.com/t/creating-links-to-open-pdf-files/631 "2008-04-10T00:59:47Z")
I need to create a way to link part numbers in my database to blue prints stored on a server. The goal is to pick the part number from a drop down on PMI and have it display the print to the screen in either a picture … --- ## [Alert event based on comparison of times](https://forum.inductiveautomation.com/t/alert-event-based-on-comparison-of-times/629)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [April 7, 2008, 3:27pm UTC](https://forum.inductiveautomation.com/t/alert-event-based-on-comparison-of-times/629 "2008-04-07T15:27:52Z")
I have a request to send an email to management any time the equipment is below a certain speed for more than 30 minutes. A = equipment A RPM B = equipment B RPM If (A is less than 20) and (B is less than 20) for mor… --- ## [Scale values](https://forum.inductiveautomation.com/t/scale-values/627)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [April 3, 2008, 7:33pm UTC](https://forum.inductiveautomation.com/t/scale-values/627 "2008-04-03T19:33:30Z")
Is there a way to use FPMI to display a scales value on a clients application? I other words, I have a scale connected to a client machine. The print key on the scale is set up to send the scale weight to the PC. I n… --- ## [List box highlight color](https://forum.inductiveautomation.com/t/list-box-highlight-color/550)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 12\ **Last updated:** [April 2, 2008, 8:22pm UTC](https://forum.inductiveautomation.com/t/list-box-highlight-color/550 "2008-04-02T20:22:55Z")
Can I control the highlight color of the selected item in a list? I see foreground and background only. Thanks. --- ## [Search and replace](https://forum.inductiveautomation.com/t/search-and-replace/624)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 3\ **Last updated:** [April 1, 2008, 4:50pm UTC](https://forum.inductiveautomation.com/t/search-and-replace/624 "2008-04-01T16:50:11Z")
I have my groups sorted into folders based on what station on the machine they pertain to. I have 4 stations. Each station has about 45 groups. Right now I set up 1 station and now I want to copy/paste the groups to a ne… --- ## [Wrap text in a Table cell](https://forum.inductiveautomation.com/t/wrap-text-in-a-table-cell/625)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 5\ **Last updated:** [March 31, 2008, 10:40pm UTC](https://forum.inductiveautomation.com/t/wrap-text-in-a-table-cell/625 "2008-03-31T22:40:42Z")
Can I? --- ## [Click/F2 to rename group in tree view](https://forum.inductiveautomation.com/t/click-f2-to-rename-group-in-tree-view/623)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 0\ **Last updated:** [March 31, 2008, 8:16pm UTC](https://forum.inductiveautomation.com/t/click-f2-to-rename-group-in-tree-view/623 "2008-03-31T20:16:15Z")
It looks like you can't use the same shortcuts to rename groups or folders in tree view mode as you can in large/small icon mode. You can only right click and select rename. It isn't a big deal, but I do love my keyboard… --- ## [Viewing Documentation](https://forum.inductiveautomation.com/t/viewing-documentation/567)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 9\ **Last updated:** [March 27, 2008, 9:47pm UTC](https://forum.inductiveautomation.com/t/viewing-documentation/567 "2008-03-27T21:47:56Z")
Ok, here is what I have working on the server at the moment. Wherever I have a little “tools” icon displayed, the techs can bring up a drop-down list of documentation to view (pdfs, drawings, video, whatever). I have the… --- ## [Using a dynamic property value in bound property reference](https://forum.inductiveautomation.com/t/using-a-dynamic-property-value-in-bound-property-reference/620)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [March 27, 2008, 9:23pm UTC](https://forum.inductiveautomation.com/t/using-a-dynamic-property-value-in-bound-property-reference/620 "2008-03-27T21:23:18Z")
I have many containers with some dynamic properties. For instance, strTank is the tank number/name and not bound to anything, intAge is the number of days old the product in the tank is. Currently intAge is bound to t… --- ## [Dynamically change 'delete records older than'](https://forum.inductiveautomation.com/t/dynamically-change-delete-records-older-than/621)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 2\ **Last updated:** [March 27, 2008, 6:38pm UTC](https://forum.inductiveautomation.com/t/dynamically-change-delete-records-older-than/621 "2008-03-27T18:38:51Z")
Possibly be able to tie it to an action item. This would be nice so I could put an entry on the HMI for a supervisor to determine how long they want to keep records for. --- ## [Format value in meter](https://forum.inductiveautomation.com/t/format-value-in-meter/619)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 3\ **Last updated:** [March 26, 2008, 8:13pm UTC](https://forum.inductiveautomation.com/t/format-value-in-meter/619 "2008-03-26T20:13:10Z")
How do I format the value that shows up in a meter? I am monitoring a SQLTag, type float. I want to display exactly one decimal place, but don't see how to do that. Thanks. --- ## [SetMode() Function for EasyChart](https://forum.inductiveautomation.com/t/setmode-function-for-easychart/616)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 5\ **Last updated:** [March 25, 2008, 9:21pm UTC](https://forum.inductiveautomation.com/t/setmode-function-for-easychart/616 "2008-03-25T21:21:55Z")
In a previous post "Binding Chart mode selection to buttons" 2/9/2007 Carl Gould mentioned a SetMode() function that would be added in a future release. Do you have a time frame for this? --- ## [Using split to process a list](https://forum.inductiveautomation.com/t/using-split-to-process-a-list/618)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 6\ **Last updated:** [March 25, 2008, 9:16pm UTC](https://forum.inductiveautomation.com/t/using-split-to-process-a-list/618 "2008-03-25T21:16:05Z")
I have a variable that contains a comma seperated listing of between 1 and 8 tanks. I want to run an SQL proceedure for each one. I know I should be able to use split() and loop through the tanks from the list running … --- ## [Font sizing and datasource connections](https://forum.inductiveautomation.com/t/font-sizing-and-datasource-connections/617)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [March 25, 2008, 9:14pm UTC](https://forum.inductiveautomation.com/t/font-sizing-and-datasource-connections/617 "2008-03-25T21:14:59Z")
Two questions I was wondering: Is there a way to monitor the gateway connection and should the connection go down, log why it went down. I ask because we have had a few gremlins sneak in where for some reason the data… --- ## [Horizontal scrollbar in table](https://forum.inductiveautomation.com/t/horizontal-scrollbar-in-table/103)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 12\ **Last updated:** [March 24, 2008, 6:06pm UTC](https://forum.inductiveautomation.com/t/horizontal-scrollbar-in-table/103 "2008-03-24T18:06:07Z")
Hi All: I am building a table and haven't found a way to get a horizontal scrollbar to show up (the vertical one is there). Related to this, I would like to set column widths so that all the headers are visible. As I… --- ## [Change DB tables in charts based on external conditions](https://forum.inductiveautomation.com/t/change-db-tables-in-charts-based-on-external-conditions/614)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 3\ **Last updated:** [March 21, 2008, 7:27pm UTC](https://forum.inductiveautomation.com/t/change-db-tables-in-charts-based-on-external-conditions/614 "2008-03-21T19:27:58Z")
In a chart, can I change the table that a pen is pointing to, based on some condition? Ideally, I'd like to use the value of a SQLTag or a property (a la indirect tags) in the table name. That way, I can display the co… --- ## [SQLTags in FSQL](https://forum.inductiveautomation.com/t/sqltags-in-fsql/613)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 5\ **Last updated:** [March 21, 2008, 3:31pm UTC](https://forum.inductiveautomation.com/t/sqltags-in-fsql/613 "2008-03-21T15:31:31Z")
Can I read SQLTags in FSQL? I want to add noise to a value for a demo. I have OPC tags generating random numbers. I want to multiply this random number times a value from my database. However, I don't have and can't… --- ## [Image color based on value from a dataset](https://forum.inductiveautomation.com/t/image-color-based-on-value-from-a-dataset/609)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 9\ **Last updated:** [March 19, 2008, 3:31pm UTC](https://forum.inductiveautomation.com/t/image-color-based-on-value-from-a-dataset/609 "2008-03-19T15:31:11Z")
Hi All, I am sure this has been addressed somewhere on the forum, but I didn't find it... I have a container with various controls in it. There is a dataset also associated with the container, with about 20 columns (j… --- ## [Selectable bar graph still shows selection after graph chnge](https://forum.inductiveautomation.com/t/selectable-bar-graph-still-shows-selection-after-graph-chnge/605)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 9\ **Last updated:** [March 19, 2008, 2:43pm UTC](https://forum.inductiveautomation.com/t/selectable-bar-graph-still-shows-selection-after-graph-chnge/605 "2008-03-19T14:43:52Z")
I have a bar graph that has selection enabled. When I click on a bar, that generates a new query for another graph. In this way I am drilling down into the equipment downtime problem. I notice that when the graph i… --- ## [Archive and purge old records from tables](https://forum.inductiveautomation.com/t/archive-and-purge-old-records-from-tables/608)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [March 19, 2008, 2:09pm UTC](https://forum.inductiveautomation.com/t/archive-and-purge-old-records-from-tables/608 "2008-03-19T14:09:33Z")
I was wondering about the best way to automatically archive and delete old records from the FSQL tables. I see that there are options on objects and groups to delete records older than # of days, but don't see an option… --- ## [Animation](https://forum.inductiveautomation.com/t/animation/610)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [March 19, 2008, 12:44am UTC](https://forum.inductiveautomation.com/t/animation/610 "2008-03-19T00:44:06Z")
When you have a minute, take a look at this screen and see if you can tell me what’s going on. I’m just thinking ahead, trying to come up with ways I can spruce up my screens in the future. There are two fans, one that… --- ## [SCAN Class Editor](https://forum.inductiveautomation.com/t/scan-class-editor/607)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [March 17, 2008, 9:31pm UTC](https://forum.inductiveautomation.com/t/scan-class-editor/607 "2008-03-17T21:31:05Z")
This one might have been talked about but in the event it has not what I think would be nice is in certain areas where you can set time periods, be allowed to choose a base for the period of time. So in a drop down box… --- ## [Cntrl-Click to Select Multiple Images](https://forum.inductiveautomation.com/t/cntrl-click-to-select-multiple-images/603)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 22\ **Last updated:** [March 14, 2008, 10:39pm UTC](https://forum.inductiveautomation.com/t/cntrl-click-to-select-multiple-images/603 "2008-03-14T22:39:35Z")
Hi All: We have a screen that shows a tank farm, and the user will select one or more tanks, then click a button to cause them to be added to a schedule of actions. At the moment we have the user highlight a tank, then… --- ## [Resizing Components](https://forum.inductiveautomation.com/t/resizing-components/588)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 12\ **Last updated:** [March 13, 2008, 4:50pm UTC](https://forum.inductiveautomation.com/t/resizing-components/588 "2008-03-13T16:50:52Z")
In the designer, if I change the size of a container either by dragging the border or typing the new value in the dialog box, the container changes size and its components change size as well with everything remaining in… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=43) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=45)