# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=49 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 50 --- ## [Rolling-my-own progress bar](https://forum.inductiveautomation.com/t/rolling-my-own-progress-bar/453)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 1\ **Last updated:** [December 19, 2007, 8:44pm UTC](https://forum.inductiveautomation.com/t/rolling-my-own-progress-bar/453 "2007-12-19T20:44:50Z")
I've got an application where I can't really use the Progress Bar control but I need to animate the width of a rectangle. The rectangle has to be perfectly squared with no outlines, whereas Progress Bar has a subtle 1-pi… --- ## [HMI Images](https://forum.inductiveautomation.com/t/hmi-images/452)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 3\ **Last updated:** [December 19, 2007, 5:22pm UTC](https://forum.inductiveautomation.com/t/hmi-images/452 "2007-12-19T17:22:30Z")
Just making a post for users to post industrial images, or hints at making there own. Up until 2 weeks ago, i had to tint the background color of my images to make it invisible, so only the actual device would show up. … --- ## [64 bit os support](https://forum.inductiveautomation.com/t/64-bit-os-support/447)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 9\ **Last updated:** [December 19, 2007, 12:14pm UTC](https://forum.inductiveautomation.com/t/64-bit-os-support/447 "2007-12-19T12:14:26Z")
I noticed that FSQL supports a 64 bit windows os, but does FPMI. I have not seen it explicitly stated anywhere. Also, other than allowing for more useable ram, is there a speed advantage? --- ## [Combining inputs with an SQLTag expression](https://forum.inductiveautomation.com/t/combining-inputs-with-an-sqltag-expression/446)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 16\ **Last updated:** [December 19, 2007, 8:40am UTC](https://forum.inductiveautomation.com/t/combining-inputs-with-an-sqltag-expression/446 "2007-12-19T08:40:16Z")
I'm trying to combine a couple of inputs using SQLTags. It's the classic 2 signals (open and close) for a valve, from which I want to derive the value position. For testing, I created 2 points named Input\_1 and Input\_… --- ## [System Status](https://forum.inductiveautomation.com/t/system-status/439)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 5\ **Last updated:** [December 19, 2007, 8:36am UTC](https://forum.inductiveautomation.com/t/system-status/439 "2007-12-19T08:36:22Z")
This quote by Nathan in another thread got me thinking: "Can you verify that the FactoryPMI service is running (control panel-\>admin tools-\>services)?" Maybe there is already a way to do this, but can you expose the ga… --- ## [How to make buttons to control a timer](https://forum.inductiveautomation.com/t/how-to-make-buttons-to-control-a-timer/451)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 6\ **Last updated:** [December 19, 2007, 8:32am UTC](https://forum.inductiveautomation.com/t/how-to-make-buttons-to-control-a-timer/451 "2007-12-19T08:32:26Z")
OK I have my timer component which works and it's flipping through a set of windows. Now I'm trying to make three buttons on the same window as the timer. The first button should stop the timer and scroll one window ba… --- ## [Configure Actions, Navigation tab](https://forum.inductiveautomation.com/t/configure-actions-navigation-tab/450)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 4\ **Last updated:** [December 17, 2007, 8:44pm UTC](https://forum.inductiveautomation.com/t/configure-actions-navigation-tab/450 "2007-12-17T20:44:20Z")
In the Configure Actions: Timer, Navigation tab, there is an option that says Forward/Back. How does this option work? What I'm looking to do is a simple timer that can rotate through displaying a group of windows. The… --- ## [Table Engine for historical data/realtime data](https://forum.inductiveautomation.com/t/table-engine-for-historical-data-realtime-data/445)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 1\ **Last updated:** [December 15, 2007, 8:30pm UTC](https://forum.inductiveautomation.com/t/table-engine-for-historical-data-realtime-data/445 "2007-12-15T20:30:55Z")
What type of table do you recommend for historical data? I was using InnoDB, which i thought should be faster with row level locking, but i dont know if this really applies because i am not updating the data, just inser… --- ## [Animations using Alerts](https://forum.inductiveautomation.com/t/animations-using-alerts/443)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [December 14, 2007, 6:19pm UTC](https://forum.inductiveautomation.com/t/animations-using-alerts/443 "2007-12-14T18:19:59Z")
Is it possible to animate an object in FPMI using the Alert levels of a SQLTags point? Something like, if point A has a high alert standing, colour it red, if it has a low alert standing colour it blue. --- ## [Another Jython question](https://forum.inductiveautomation.com/t/another-jython-question/441)
**Author:** [@jhardin](https://forum.inductiveautomation.com/u/jhardin)\ **Replies:** 4\ **Last updated:** [December 13, 2007, 8:32am UTC](https://forum.inductiveautomation.com/t/another-jython-question/441 "2007-12-13T08:32:07Z")
OK so after reviewing online information for Python how do I get the scripts that I write in Jython to work with objects in PMI and is there documentation that provides object and their related methods, events, and prope… --- ## [Dock windows](https://forum.inductiveautomation.com/t/dock-windows/434)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 8\ **Last updated:** [December 12, 2007, 7:34pm UTC](https://forum.inductiveautomation.com/t/dock-windows/434 "2007-12-12T19:34:10Z")
Is it possible to dock a window to a corner, like the north west corner in my case --- ## [Jython Script](https://forum.inductiveautomation.com/t/jython-script/440)
**Author:** [@jhardin](https://forum.inductiveautomation.com/u/jhardin)\ **Replies:** 1\ **Last updated:** [December 12, 2007, 6:18pm UTC](https://forum.inductiveautomation.com/t/jython-script/440 "2007-12-12T18:18:32Z")
I am looking for some examples of using Jython in PMI if anyone has some can you send them to me at hardinj@tampabay.rr.com Thanks --- ## [Log out of FactoryPMI configuration now app won’t launch](https://forum.inductiveautomation.com/t/log-out-of-factorypmi-configuration-now-app-won-t-launch/438)
**Author:** [@k2kelley](https://forum.inductiveautomation.com/u/k2kelley)\ **Replies:** 5\ **Last updated:** [December 12, 2007, 6:14pm UTC](https://forum.inductiveautomation.com/t/log-out-of-factorypmi-configuration-now-app-won-t-launch/438 "2007-12-12T18:14:14Z")
After working in PMI, I logged out using the log out link on the top of the configuration page. Then when I tried to restart using the configuration page. IE pops up and I get ‘The page cannot be displayed’ error page. … --- ## [Data entry form based data collection](https://forum.inductiveautomation.com/t/data-entry-form-based-data-collection/436)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 6\ **Last updated:** [December 11, 2007, 8:05pm UTC](https://forum.inductiveautomation.com/t/data-entry-form-based-data-collection/436 "2007-12-11T20:05:22Z")
I want to use a HMI window as a form for manual data entry into a database table. The user fills in some text boxes and selects some Boolean values and clicks submit. The data is taken from each field and entered as a n… --- ## [Reading/Writing Files to the Database](https://forum.inductiveautomation.com/t/reading-writing-files-to-the-database/428)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 24\ **Last updated:** [December 10, 2007, 11:35pm UTC](https://forum.inductiveautomation.com/t/reading-writing-files-to-the-database/428 "2007-12-10T23:35:39Z")
Ok, so i have this working, just wondering if there is an easier way to do this. In my database, i have a table called files, with 5 columns: \[ul\]ID , which is of type INTEGER and is auto-incrementing Tag, which is of… --- ## [Dynamic Properties not passed in Jython scripts?](https://forum.inductiveautomation.com/t/dynamic-properties-not-passed-in-jython-scripts/431)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 3\ **Last updated:** [December 10, 2007, 9:14pm UTC](https://forum.inductiveautomation.com/t/dynamic-properties-not-passed-in-jython-scripts/431 "2007-12-10T21:14:35Z")
Alright, i am having an issue with some properties nto passing through in a jython scripts. Non dynamic properties, such as name work. But in my case, dynamic properties, such as Tag, do not. Here is my code \[code\]de… --- ## [Animating Boolean SQLTags](https://forum.inductiveautomation.com/t/animating-boolean-sqltags/432)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [December 10, 2007, 5:49pm UTC](https://forum.inductiveautomation.com/t/animating-boolean-sqltags/432 "2007-12-10T17:49:03Z")
I've imported a number of digital input tags into SQLTags as Booleans which I was going to display on the screen using the colour of a number of shapes e.g. the fill colour of a circle. I've found however that FPMI does… --- ## [Confirmation box](https://forum.inductiveautomation.com/t/confirmation-box/429)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 6\ **Last updated:** [December 6, 2007, 9:24pm UTC](https://forum.inductiveautomation.com/t/confirmation-box/429 "2007-12-06T21:24:42Z")
Hi. The following works fine by its self: response = fpmi.db.runScalarQuery("select \* from elan\_pgres\_elanhost\_dig\_out\_ctl('localhost', %d, '%s', 'Close/Open', 'digital-out', 'Direct Operate', 'None', 'Close', '500',… --- ## [Unable to Connect with MySQL from Factory PMI](https://forum.inductiveautomation.com/t/unable-to-connect-with-mysql-from-factory-pmi/427)
**Author:** [@WildeKurt](https://forum.inductiveautomation.com/u/WildeKurt)\ **Replies:** 5\ **Last updated:** [December 5, 2007, 8:04pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-with-mysql-from-factory-pmi/427 "2007-12-05T20:04:32Z")
Factory PMI can not connect to the MySQL database. I've set the connection to: jdbc:mysql://localhost:3306/test. test is the name of the database. Also, it cannot connect to IADemo that came with. I get the followi… --- ## [No updating of data after Update Rate Change](https://forum.inductiveautomation.com/t/no-updating-of-data-after-update-rate-change/424)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 7\ **Last updated:** [December 5, 2007, 6:41pm UTC](https://forum.inductiveautomation.com/t/no-updating-of-data-after-update-rate-change/424 "2007-12-05T18:41:15Z")
I use an Easychart to display data. I keep the data for 30 days and was updating the table every second. Everything worked fine. I wanted to change the update rate to every 5 seconds. Changed the rate in FactorySQL a… --- ## [Messagebox and result of a select statement](https://forum.inductiveautomation.com/t/messagebox-and-result-of-a-select-statement/423)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 4\ **Last updated:** [December 5, 2007, 9:51am UTC](https://forum.inductiveautomation.com/t/messagebox-and-result-of-a-select-statement/423 "2007-12-05T09:51:11Z")
Hi Guys, I have the following code in the 'Script Editor' of the 'MouseClicked' event of a button. response = fpmi.db.runQuery("select \* from elan\_pgres\_elanhost\_dig\_out\_ctl('localhost', %d, '%s', 'Automatic Operatio… --- ## [Setbit function?](https://forum.inductiveautomation.com/t/setbit-function/419)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 5\ **Last updated:** [December 2, 2007, 3:16am UTC](https://forum.inductiveautomation.com/t/setbit-function/419 "2007-12-02T03:16:24Z")
I know I am missing something here, but I have a hard time setting individual bits in DINTs in a ControlLogix PLC. I use the getbit function to read individual status bits, but how do I write an individual bit? I have … --- ## [Delete a custom component](https://forum.inductiveautomation.com/t/delete-a-custom-component/420)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 2\ **Last updated:** [December 1, 2007, 12:29am UTC](https://forum.inductiveautomation.com/t/delete-a-custom-component/420 "2007-12-01T00:29:34Z")
Hi guys, How do I delete a custom component that I have created. The reason being that the custom component has been changed. Regards Qurban --- ## [Max value](https://forum.inductiveautomation.com/t/max-value/418)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 4\ **Last updated:** [November 30, 2007, 7:07pm UTC](https://forum.inductiveautomation.com/t/max-value/418 "2007-11-30T19:07:09Z")
Hi Guys. I have about 6 or so dynamic properties(type float) which are linked to other properties on the window. How do I find the max value among the 6 and then subtract the rest from it. I know expression has a max fun… --- ## [Microsoft SQLServer Connection Refused from FactoryPMI](https://forum.inductiveautomation.com/t/microsoft-sqlserver-connection-refused-from-factorypmi/417)
**Author:** [@mdowdell](https://forum.inductiveautomation.com/u/mdowdell)\ **Replies:** 1\ **Last updated:** [November 29, 2007, 8:21pm UTC](https://forum.inductiveautomation.com/t/microsoft-sqlserver-connection-refused-from-factorypmi/417 "2007-11-29T20:21:10Z")
When I try to connect to my SQL Server db in Datasources, I get the following error: Network error IOException: Connection refused: connect host: ALEX port: 1433 database: TrainingPants Connect URL= jdbc:jtds:sqlse… --- ## [Running Total Graphic](https://forum.inductiveautomation.com/t/running-total-graphic/416)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 3\ **Last updated:** [November 26, 2007, 11:08pm UTC](https://forum.inductiveautomation.com/t/running-total-graphic/416 "2007-11-26T23:08:05Z")
I have a table with running totals in one column and the time the total was taken in another column. I want to graph the difference between n and n-1 in a bar-graph. An additional obstacle is that the time-range overla… --- ## ['Like' in a where clause](https://forum.inductiveautomation.com/t/like-in-a-where-clause/415)
**Author:** [@qurban](https://forum.inductiveautomation.com/u/qurban)\ **Replies:** 8\ **Last updated:** [November 26, 2007, 7:58pm UTC](https://forum.inductiveautomation.com/t/like-in-a-where-clause/415 "2007-11-26T19:58:40Z")
Hi Guys, Here is a basic question. The code below works just fine without line 2 & 3 (the if statement with 'LIKE' in it.) As soon as I select the 'Alarm Name' checkbox, the alarm table becomes empty regardless of what … --- ## [Modifying fields logged in alert table](https://forum.inductiveautomation.com/t/modifying-fields-logged-in-alert-table/414)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 3\ **Last updated:** [November 22, 2007, 3:48pm UTC](https://forum.inductiveautomation.com/t/modifying-fields-logged-in-alert-table/414 "2007-11-22T15:48:10Z")
Is there any way to get one of the opc tags logged to a column in the alert table, or to add a column to the table? I have a batch number that identifies each batch that I would like to log. TIA David --- ## [Best Way to Determine Number of Items in a List Component](https://forum.inductiveautomation.com/t/best-way-to-determine-number-of-items-in-a-list-component/402)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 11\ **Last updated:** [November 21, 2007, 10:43pm UTC](https://forum.inductiveautomation.com/t/best-way-to-determine-number-of-items-in-a-list-component/402 "2007-11-21T22:43:54Z")
I have a window containing a list component. I want to determine, within a script, the number of items in the list. What's the best way to do this? I've tried something like "len(list.data)" but apparently the dataset … --- ## [Alerts based on multiple inputs](https://forum.inductiveautomation.com/t/alerts-based-on-multiple-inputs/411)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 4\ **Last updated:** [November 21, 2007, 10:09pm UTC](https://forum.inductiveautomation.com/t/alerts-based-on-multiple-inputs/411 "2007-11-21T22:09:56Z")
Hi all: One of our processes has a number of substeps that are represented by a status bit. It can take any value between 1 and 8. When status=1, I would like to generate alerts based on another value falling below 12… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=48) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=50)