# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=54 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 55 --- ## [Dynamic positioning](https://forum.inductiveautomation.com/t/dynamic-positioning/271)
**Author:** [@timg](https://forum.inductiveautomation.com/u/timg)\ **Replies:** 1\ **Last updated:** [May 4, 2007, 1:25pm UTC](https://forum.inductiveautomation.com/t/dynamic-positioning/271 "2007-05-04T13:25:45Z")
I am working on application that will contain a header bar and a left bar similar to the Skeleton application. I have tags that I want to display on the header bar and I want them positioned the same for any HMI or comp… --- ## [FactoryPMI and a Sybase SQL Database](https://forum.inductiveautomation.com/t/factorypmi-and-a-sybase-sql-database/270)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 2\ **Last updated:** [May 1, 2007, 10:58pm UTC](https://forum.inductiveautomation.com/t/factorypmi-and-a-sybase-sql-database/270 "2007-05-01T22:58:58Z")
Does FactoryPMI support Sybase databases? --- ## [Add/remove functions for datasets and tables](https://forum.inductiveautomation.com/t/add-remove-functions-for-datasets-and-tables/269)
**Author:** [@Kamal\_Lang](https://forum.inductiveautomation.com/u/Kamal_Lang)\ **Replies:** 4\ **Last updated:** [May 1, 2007, 3:10pm UTC](https://forum.inductiveautomation.com/t/add-remove-functions-for-datasets-and-tables/269 "2007-05-01T15:10:19Z")
Hi I wanted to know if the table component or the dataset has functions with which it is possible to find elements, remove elements, add elements (element by element) to it. Could you give me a full list of functions … --- ## [FactoryPMI Reporting Plugin Released!](https://forum.inductiveautomation.com/t/factorypmi-reporting-plugin-released/118)
**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Replies:** 1\ **Last updated:** [April 30, 2007, 11:00pm UTC](https://forum.inductiveautomation.com/t/factorypmi-reporting-plugin-released/118 "2007-04-30T23:00:06Z")
The eagerly-anticipated FactoryPMI Reporting Plugin has been released. Generate high-quality PDF and printed reports, all from your existing FactoryPMI project. Download the trial version today --- ## [Copy/Paste into Datasets](https://forum.inductiveautomation.com/t/copy-paste-into-datasets/267)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [April 29, 2007, 6:51pm UTC](https://forum.inductiveautomation.com/t/copy-paste-into-datasets/267 "2007-04-29T18:51:02Z")
I'm in the midst of making a "multi-state indicator" & need a shortcut. I'm converting a project from Panel builder. I have over 100 descriptions relating to different states that I am putting into the "translations" t… --- ## [TCP, UDP, firewalls, clustering, and FactoryPMI clients](https://forum.inductiveautomation.com/t/tcp-udp-firewalls-clustering-and-factorypmi-clients/268)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [April 29, 2007, 6:35pm UTC](https://forum.inductiveautomation.com/t/tcp-udp-firewalls-clustering-and-factorypmi-clients/268 "2007-04-29T18:35:41Z")
This post pertains to setting up Firewall rules with FactoryPMI, particularly when putting your projects on the Internet. These aren't the simplest of networking topics, but I'm sure you'll be able to tackle the concepts… --- ## [System SQLTags ideas](https://forum.inductiveautomation.com/t/system-sqltags-ideas/266)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [April 28, 2007, 2:30pm UTC](https://forum.inductiveautomation.com/t/system-sqltags-ideas/266 "2007-04-28T14:30:07Z")
We're looking for input on system SQLTags - think of these like globally bindable properties. These are what I came up with: status now - current timestamp, can format with expression. idleTime - seconds since last key… --- ## [Selecting Colors for Different States](https://forum.inductiveautomation.com/t/selecting-colors-for-different-states/265)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 3\ **Last updated:** [April 27, 2007, 9:52pm UTC](https://forum.inductiveautomation.com/t/selecting-colors-for-different-states/265 "2007-04-27T21:52:51Z")
All right, it looks like I have another challenge on my hands. I'm adding an options screen to my HMI in which the user can choose virtually any color to represent a state (empty, failed, etc.). Currently, I'm using a… --- ## [Hiding top menu bar](https://forum.inductiveautomation.com/t/hiding-top-menu-bar/264)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 1\ **Last updated:** [April 27, 2007, 2:42pm UTC](https://forum.inductiveautomation.com/t/hiding-top-menu-bar/264 "2007-04-27T14:42:27Z")
You can remove all the custom menu items on the bar at the top of the project, but then the Help and Windows menus are still available. I was wondering if there is a way to completely hide or remove the bar. The login sc… --- ## [Swap rows and columns for charting](https://forum.inductiveautomation.com/t/swap-rows-and-columns-for-charting/263)
**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\ **Replies:** 1\ **Last updated:** [April 25, 2007, 8:45pm UTC](https://forum.inductiveautomation.com/t/swap-rows-and-columns-for-charting/263 "2007-04-25T20:45:20Z")
In order to trend data in FPMI, I need each tag to be represented in a column and the rows delineated by date. My data is returned in one big column. How can I swap the rows for columns? --- ## [Multiple Text Lines on a Button](https://forum.inductiveautomation.com/t/multiple-text-lines-on-a-button/262)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [April 23, 2007, 11:39pm UTC](https://forum.inductiveautomation.com/t/multiple-text-lines-on-a-button/262 "2007-04-23T23:39:41Z")
Is it possible to have multiple text lines on a button? --- ## [I need to load my MySQl tables with data from Excel](https://forum.inductiveautomation.com/t/i-need-to-load-my-mysql-tables-with-data-from-excel/261)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [April 23, 2007, 10:22pm UTC](https://forum.inductiveautomation.com/t/i-need-to-load-my-mysql-tables-with-data-from-excel/261 "2007-04-23T22:22:35Z")
Will the before mentioned solution work in both directions, I only need to send data from Excel to MySQl. --- ## [Loading MySQL tables from Excel](https://forum.inductiveautomation.com/t/loading-mysql-tables-from-excel/259)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [April 23, 2007, 10:16pm UTC](https://forum.inductiveautomation.com/t/loading-mysql-tables-from-excel/259 "2007-04-23T22:16:51Z")
Is it possible to load and update MySQL tables from Excel, and if so how? I havn't been able to find any source code. --- ## [Database Query to return 0 when no rows](https://forum.inductiveautomation.com/t/database-query-to-return-0-when-no-rows/260)
**Author:** [@welliott](https://forum.inductiveautomation.com/u/welliott)\ **Replies:** 2\ **Last updated:** [April 21, 2007, 1:07am UTC](https://forum.inductiveautomation.com/t/database-query-to-return-0-when-no-rows/260 "2007-04-21T01:07:35Z")
This is what i have now but when there are no rows i recieve an error. i would like to set it to 0 when no rows are present. SELECT DISTINCT IF (ack\_time IS NULL, 2, IF( ack\_time IS NOT NULL AND clear\_time IS NULL,1, 0… --- ## [Global Variables](https://forum.inductiveautomation.com/t/global-variables/257)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 4\ **Last updated:** [April 19, 2007, 3:15pm UTC](https://forum.inductiveautomation.com/t/global-variables/257 "2007-04-19T15:15:02Z")
In my HMI, I want the selected row number to be a global variable which changes when the user chooses an entry in a dropdown list. Here is the code in app.variables: def getRow\_Number(): global Row\_Number … --- ## [MySQL Administrator SQL database restore problem](https://forum.inductiveautomation.com/t/mysql-administrator-sql-database-restore-problem/258)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [April 17, 2007, 9:03pm UTC](https://forum.inductiveautomation.com/t/mysql-administrator-sql-database-restore-problem/258 "2007-04-17T21:03:31Z")
I can't seem to restore a large database backup (db.SQL) with the MySQL Administrator. It hangs at random points. Is there another way that I can restore my database? --- ## [Opaque property on button](https://forum.inductiveautomation.com/t/opaque-property-on-button/256)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [April 13, 2007, 3:51pm UTC](https://forum.inductiveautomation.com/t/opaque-property-on-button/256 "2007-04-13T15:51:16Z")
I would like it if the there was an option to make buttons see-through. I know I can make anything a button by changing the properties to react to a command. They don't seem to work as good as a good old button for nav… --- ## [Connecting to server](https://forum.inductiveautomation.com/t/connecting-to-server/255)
**Author:** [@11thhour](https://forum.inductiveautomation.com/u/11thhour)\ **Replies:** 2\ **Last updated:** [April 11, 2007, 6:13pm UTC](https://forum.inductiveautomation.com/t/connecting-to-server/255 "2007-04-11T18:13:36Z")
New to IA. That said here is my daily problem. When I start my computer, I start the client. I get "Browsing not available when disconnected from service" in the OPC Browser window. I then try to connect to service. Th… --- ## [Chart Question](https://forum.inductiveautomation.com/t/chart-question/247)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 5\ **Last updated:** [April 10, 2007, 7:49pm UTC](https://forum.inductiveautomation.com/t/chart-question/247 "2007-04-10T19:49:59Z")
Just wondering if it is possible to pull up historical data from a table, but use real time data as well. What i mean is, say while i am looking at the chart, i want to see my new values update every 1 second, but store… --- ## [Concat a field name](https://forum.inductiveautomation.com/t/concat-a-field-name/254)
**Author:** [@11thhour](https://forum.inductiveautomation.com/u/11thhour)\ **Replies:** 5\ **Last updated:** [April 10, 2007, 7:35pm UTC](https://forum.inductiveautomation.com/t/concat-a-field-name/254 "2007-04-10T19:35:22Z")
Desiring to modify the field modified from a popup window: Original update( that works): UPDATE tanks SET PumpAuto\_1 = {this} WHERE tank = {Root Container.Device} Would like something like : UPDATE tanks SET PumpAuto\_1… --- ## [Replacing a Table Cell Value with a Numeric Text Value](https://forum.inductiveautomation.com/t/replacing-a-table-cell-value-with-a-numeric-text-value/253)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 6\ **Last updated:** [April 9, 2007, 2:40pm UTC](https://forum.inductiveautomation.com/t/replacing-a-table-cell-value-with-a-numeric-text-value/253 "2007-04-09T14:40:51Z")
I'm trying to let the user change the tank alias of the currently selected row in the table by changing the value of a numeric text field. In FocusGained: value = event.source.intValue #Numeric field's value tankNa… --- ## [Reading strings as arrays of ASCII values](https://forum.inductiveautomation.com/t/reading-strings-as-arrays-of-ascii-values/252)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 2\ **Last updated:** [April 2, 2007, 8:10pm UTC](https://forum.inductiveautomation.com/t/reading-strings-as-arrays-of-ascii-values/252 "2007-04-02T20:10:34Z")
When I drag "A" (ASCII) words into FactorySQL I only see 2 characters. How can I read more at once? When I have FactorySQL sitting side by side with RSView, it shows the whole word. RSView shows "Yogurt" and FactorySQL s… --- ## [Block group: Must declare the variable "@1"](https://forum.inductiveautomation.com/t/block-group-must-declare-the-variable-1/251)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [March 30, 2007, 6:52pm UTC](https://forum.inductiveautomation.com/t/block-group-must-declare-the-variable-1/251 "2007-03-30T18:52:26Z")
Hey all, I just helped out someone who was having this problem, and thought it would be good to put up here: Using block groups with MS SQL Server, they were getting the error "Must declare variable @1". The trick he… --- ## [Java](https://forum.inductiveautomation.com/t/java/250)
**Author:** [@Kamal\_Lang](https://forum.inductiveautomation.com/u/Kamal_Lang)\ **Replies:** 5\ **Last updated:** [March 26, 2007, 10:41pm UTC](https://forum.inductiveautomation.com/t/java/250 "2007-03-26T22:41:23Z")
I have used bits of java code in the form of 1 or 2 method calls like from java.net import InetAddress compname = InetAddress.getLocalHost().getHostName() But what if i want to instantiate a standard Java class and … --- ## [Easy Chart - Binding to a join select sentence](https://forum.inductiveautomation.com/t/easy-chart-binding-to-a-join-select-sentence/249)
**Author:** [@Kamal\_Lang](https://forum.inductiveautomation.com/u/Kamal_Lang)\ **Replies:** 6\ **Last updated:** [March 26, 2007, 6:42pm UTC](https://forum.inductiveautomation.com/t/easy-chart-binding-to-a-join-select-sentence/249 "2007-03-26T18:42:20Z")
Hi guys. I have a general question regarding the Easy Chart component. The data that i want to display in the chart is a result of a complex join SQL sentence. Is it possible to give the chart such a select sentence. … --- ## [Pipe Joint - Dynamic Property](https://forum.inductiveautomation.com/t/pipe-joint-dynamic-property/248)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [March 26, 2007, 4:36pm UTC](https://forum.inductiveautomation.com/t/pipe-joint-dynamic-property/248 "2007-03-26T16:36:36Z")
Any chance we can get the ability to add a Dynamic Property to the Pipe Joint? Doesn't seem to be an option at this point. --- ## [Performance Issue](https://forum.inductiveautomation.com/t/performance-issue/246)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 2\ **Last updated:** [March 24, 2007, 8:00pm UTC](https://forum.inductiveautomation.com/t/performance-issue/246 "2007-03-24T20:00:14Z")
I transferred my FPMI/FSQL to a new computer, and my cpu usage went from 40-60% on the old system to 5-15% on the new system. Looks like it is a hardware issue, but I am gonna reinstall XP on the original computer. S… --- ## [Ms-mug](https://forum.inductiveautomation.com/t/ms-mug/210)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [March 20, 2007, 12:42am UTC](https://forum.inductiveautomation.com/t/ms-mug/210 "2007-03-20T00:42:21Z")
I stumbled across this. Anybody know much about it? Seems like a poor choice for an acronym. MS certainly sets their own precedents. MicroSoft Manufacturers Users Group http://public.arcweb.com/msmug/Reliable%20Systems… --- ## [Fpmi designer and vista](https://forum.inductiveautomation.com/t/fpmi-designer-and-vista/244)
**Author:** [@ideas](https://forum.inductiveautomation.com/u/ideas)\ **Replies:** 2\ **Last updated:** [March 19, 2007, 9:14pm UTC](https://forum.inductiveautomation.com/t/fpmi-designer-and-vista/244 "2007-03-19T21:14:40Z")
Hi, I know fpmi is not officially supported under vista, but...is there a java guru here whoa can explain why i cannot connect to the designer ? below is the error code : java.net.MalformedURLException: For input s… --- ## [Date/Time format on Chart X-axis](https://forum.inductiveautomation.com/t/date-time-format-on-chart-x-axis/188)
**Author:** [@torulf](https://forum.inductiveautomation.com/u/torulf)\ **Replies:** 4\ **Last updated:** [March 14, 2007, 10:50pm UTC](https://forum.inductiveautomation.com/t/date-time-format-on-chart-x-axis/188 "2007-03-14T22:50:53Z")
Is there a way to define the format for Date/Time displayed on the X-axis of a Chart object somewhat like the function in the Table object? I reside in Europe and it seems that the default format is MM DD, YYY with a 12 … [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=53) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=55)