# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=53 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 54 --- ## [FONT doesn't seem to work for the slider](https://forum.inductiveautomation.com/t/font-doesnt-seem-to-work-for-the-slider/304)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 4\ **Last updated:** [July 10, 2007, 11:20am UTC](https://forum.inductiveautomation.com/t/font-doesnt-seem-to-work-for-the-slider/304 "2007-07-10T11:20:17Z")
I have several sliders on my page and want to change the font (the scale numbers built into the slider). None of the FONT properties seem to work for the slider! Am I doing something wrong? John --- ## [SQL and PMI questions](https://forum.inductiveautomation.com/t/sql-and-pmi-questions/300)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 7\ **Last updated:** [July 9, 2007, 4:23pm UTC](https://forum.inductiveautomation.com/t/sql-and-pmi-questions/300 "2007-07-09T16:23:57Z")
I have been reading over these news groups and have come across some information that I would like clarification on. In one group it was mentioned that it is possible to detect if the communications is lost between yo… --- ## [Sort OPC Item](https://forum.inductiveautomation.com/t/sort-opc-item/294)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 5\ **Last updated:** [July 6, 2007, 6:13pm UTC](https://forum.inductiveautomation.com/t/sort-opc-item/294 "2007-07-06T18:13:30Z")
In the Factory SQL Configuration screen: Is there any way to sort the browsed OPC items. I notice I can sort the items I selected and plaed in the database. It would speed up the process of selecting item if I cou… --- ## [Toggle Button "Selected Label"](https://forum.inductiveautomation.com/t/toggle-button-selected-label/302)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [July 5, 2007, 7:13pm UTC](https://forum.inductiveautomation.com/t/toggle-button-selected-label/302 "2007-07-05T19:13:20Z")
I have figured out how to display a different label on the Toggle Button if it is selected. However, it would be nice if the Toggle Button had the built-in property, "Selected Label". It already has "Selected Image Pat… --- ## [Is this possible in FactorySQL](https://forum.inductiveautomation.com/t/is-this-possible-in-factorysql/301)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [July 5, 2007, 4:13pm UTC](https://forum.inductiveautomation.com/t/is-this-possible-in-factorysql/301 "2007-07-05T16:13:00Z")
I dont recall what you call the various panes and/or views in the factorySQL software so I will do my best to describe what it is I would like to do. In the lower left hand side of the screen there is a pane that is lo… --- ## [Retrieving "Periodic" Data](https://forum.inductiveautomation.com/t/retrieving-periodic-data/298)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 9\ **Last updated:** [July 3, 2007, 5:59pm UTC](https://forum.inductiveautomation.com/t/retrieving-periodic-data/298 "2007-07-03T17:59:35Z")
I'm considering FactorySQL for a project but have questions related to data retrieval. I've been told that the data is only written to a DB table when it changes. I understand the advantages of this method in that it g… --- ## [Problems getting SQL connection](https://forum.inductiveautomation.com/t/problems-getting-sql-connection/299)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [July 3, 2007, 3:22pm UTC](https://forum.inductiveautomation.com/t/problems-getting-sql-connection/299 "2007-07-03T15:22:17Z")
Our IT dept and I are working on this proposed project and are having trouble getting PMI to attach to our MicroSoft SQL server. We have tried it using the //name and also with //IP. Also with and without username and pa… --- ## [Linking tables between DBM's](https://forum.inductiveautomation.com/t/linking-tables-between-dbms/297)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [June 26, 2007, 12:25pm UTC](https://forum.inductiveautomation.com/t/linking-tables-between-dbms/297 "2007-06-26T12:25:31Z")
Guys, Is it possible to link tables between MySQL and Posrtgress? --- ## [Sort OPC items](https://forum.inductiveautomation.com/t/sort-opc-items/293)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 1\ **Last updated:** [June 22, 2007, 4:04pm UTC](https://forum.inductiveautomation.com/t/sort-opc-items/293 "2007-06-22T16:04:01Z")
A good idea for the next Factory SQL would be to allow sorting OPC items using Alphabetical order. This would greatly cut down the time used to find items inside of your database. John --- ## [Search capabilities in drop down boxes](https://forum.inductiveautomation.com/t/search-capabilities-in-drop-down-boxes/296)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [June 20, 2007, 9:04pm UTC](https://forum.inductiveautomation.com/t/search-capabilities-in-drop-down-boxes/296 "2007-06-20T21:04:29Z")
A nice feature to add would be a drop down box that has a built in search functions so when you start typing it will automactically find the closest match. Ex. 'drop down box that queries all the states and when the ope… --- ## [No Duplicates](https://forum.inductiveautomation.com/t/no-duplicates/292)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [June 18, 2007, 9:25pm UTC](https://forum.inductiveautomation.com/t/no-duplicates/292 "2007-06-18T21:25:11Z")
Is it possible to set a column to no duplicates values like you can in Access? --- ## [Caching historical data in the PLC](https://forum.inductiveautomation.com/t/caching-historical-data-in-the-plc/291)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [June 7, 2007, 2:54am UTC](https://forum.inductiveautomation.com/t/caching-historical-data-in-the-plc/291 "2007-06-07T02:54:10Z")
FactorySQL supports automatic data caching when it loses connection to the SQL database, but is still communicating with the PLC. If you have a central database/FactoryPMI setup with remote sites over a questionable conn… --- ## [FactoryPMI Gateway on a disconnected laptop](https://forum.inductiveautomation.com/t/factorypmi-gateway-on-a-disconnected-laptop/290)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [June 6, 2007, 4:14pm UTC](https://forum.inductiveautomation.com/t/factorypmi-gateway-on-a-disconnected-laptop/290 "2007-06-06T16:14:32Z")
If you have a laptop running FactoryPMI that doesn't work when it's disconnected from the network, there is hope. This is a common setup for demonstrations. Windows XP has a feature called Media Sensing that disables … --- ## [IP Web camera component](https://forum.inductiveautomation.com/t/ip-web-camera-component/289)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 1\ **Last updated:** [June 6, 2007, 4:05pm UTC](https://forum.inductiveautomation.com/t/ip-web-camera-component/289 "2007-06-06T16:05:50Z")
My web camera component works for awhile, then quits working. I have a Panasonic BL-C30 camera. --- ## [Incorrect cluster settings can cause problems - have fix](https://forum.inductiveautomation.com/t/incorrect-cluster-settings-can-cause-problems-have-fix/288)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [June 1, 2007, 9:15pm UTC](https://forum.inductiveautomation.com/t/incorrect-cluster-settings-can-cause-problems-have-fix/288 "2007-06-01T21:15:48Z")
A known issue as of now is if you try to bind the cluster address to a bad address. You would do this in the Gateway Configuration page-\>Network and 1. Unchecking Autodetect Bind Interface 2. Typing a bad address under B… --- ## [Internal DB config file corruption possible. Upgrade 2.1.4+](https://forum.inductiveautomation.com/t/internal-db-config-file-corruption-possible-upgrade-2-1-4/287)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [June 1, 2007, 9:06pm UTC](https://forum.inductiveautomation.com/t/internal-db-config-file-corruption-possible-upgrade-2-1-4/287 "2007-06-01T21:06:55Z")
We've seen cases where FactoryPMI versions between 2.0 and 2.1.3 corrupt the internal database configuration file (fpmi\_internal.properties). If this happened the FactoryPMI Service (and Gateway) will not start. You didn… --- ## [Uncaught exception with old Reporting Plugin-Upgrade version](https://forum.inductiveautomation.com/t/uncaught-exception-with-old-reporting-plugin-upgrade-version/286)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [June 1, 2007, 8:58pm UTC](https://forum.inductiveautomation.com/t/uncaught-exception-with-old-reporting-plugin-upgrade-version/286 "2007-06-01T20:58:48Z")
If you just upgraded to a new version of FactoryPMI (\>= 2.x) and you had an older version of the Reporting Plugin, you'll need to upgrade the reporting plugin with it (\>=1.1.1). Upgrades are fully backward compatible and… --- ## [Dynamic-Link Libraries](https://forum.inductiveautomation.com/t/dynamic-link-libraries/285)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 5\ **Last updated:** [June 1, 2007, 3:56pm UTC](https://forum.inductiveautomation.com/t/dynamic-link-libraries/285 "2007-06-01T15:56:39Z")
Is Factory PMI compatible with dynamic-link libraries? If so, how do I import them? --- ## [Global Script Module Subroutines](https://forum.inductiveautomation.com/t/global-script-module-subroutines/283)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 2\ **Last updated:** [May 31, 2007, 1:37pm UTC](https://forum.inductiveautomation.com/t/global-script-module-subroutines/283 "2007-05-31T13:37:56Z")
What's the correct syntax for calling a module within another module? For instance, under app.\* I have two modules: level and levelMod. How does a subroutine in levelMod call a subroutine in level or within its own … --- ## [Easy Chart "save to" does not save second in xls f](https://forum.inductiveautomation.com/t/easy-chart-save-to-does-not-save-second-in-xls-f/282)
**Author:** [@ideas](https://forum.inductiveautomation.com/u/ideas)\ **Replies:** 1\ **Last updated:** [May 27, 2007, 10:29pm UTC](https://forum.inductiveautomation.com/t/easy-chart-save-to-does-not-save-second-in-xls-f/282 "2007-05-27T22:29:50Z")
Hi, or maybe there is a setup somewhere but I can't find it. Maybe a feature request ? --- ## [Binding to NAME property](https://forum.inductiveautomation.com/t/binding-to-name-property/281)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 3\ **Last updated:** [May 25, 2007, 2:17pm UTC](https://forum.inductiveautomation.com/t/binding-to-name-property/281 "2007-05-25T14:17:26Z")
It seems that I cannot bind to the “Name” property of an object (e.g. a container). Is this true? If so, I would like to see this capability, to save some repetitive typing. --- ## [Populating a Table With a Text File](https://forum.inductiveautomation.com/t/populating-a-table-with-a-text-file/229)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 12\ **Last updated:** [May 24, 2007, 7:46pm UTC](https://forum.inductiveautomation.com/t/populating-a-table-with-a-text-file/229 "2007-05-24T19:46:11Z")
I'm a student programmer, and most of my experience is limited to C++ and Perl. Although Factory PMI is a great designer, I'm having a little trouble getting used to it. In my project, I'd like to load a table with va… --- ## [Formatted Text Field Input](https://forum.inductiveautomation.com/t/formatted-text-field-input/279)
**Author:** [@Moody](https://forum.inductiveautomation.com/u/Moody)\ **Replies:** 6\ **Last updated:** [May 22, 2007, 5:56pm UTC](https://forum.inductiveautomation.com/t/formatted-text-field-input/279 "2007-05-22T17:56:11Z")
For my project, each tank has several different levels represented by a string with three integers separated by dashes. The first number (feet) can be any integer greater than or equal to 0. The second (inches) can be … --- ## [Running a query on 2 differnt schemas in PMI](https://forum.inductiveautomation.com/t/running-a-query-on-2-differnt-schemas-in-pmi/280)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [May 21, 2007, 10:29pm UTC](https://forum.inductiveautomation.com/t/running-a-query-on-2-differnt-schemas-in-pmi/280 "2007-05-21T22:29:09Z")
Is it possible to run a query in PMI on differnt schemas or run 1 query on 2 diffent data sources. --- ## [Jython Sockets](https://forum.inductiveautomation.com/t/jython-sockets/278)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [May 18, 2007, 11:32pm UTC](https://forum.inductiveautomation.com/t/jython-sockets/278 "2007-05-18T23:32:38Z")
I have a question about Jython sockets. My plc is broadcasting CHAR arrays over UDP (length up to 1024 bytes), and I would like to grab them and insert them as a text blob in a table. This would be bypassing the OPC Serv… --- ## [Alert Log, count alarms by 1 hour interval](https://forum.inductiveautomation.com/t/alert-log-count-alarms-by-1-hour-interval/277)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 8\ **Last updated:** [May 18, 2007, 7:01pm UTC](https://forum.inductiveautomation.com/t/alert-log-count-alarms-by-1-hour-interval/277 "2007-05-18T19:01:53Z")
So I am trying to make a mini alarm management system. I want to be able to take the selected alarm, and chart using a bar chart the alarm count vs hr interval. Now i was thinking of creating 24 sql queries and populate… --- ## [Date Popup Date property](https://forum.inductiveautomation.com/t/date-popup-date-property/276)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 2\ **Last updated:** [May 15, 2007, 10:07pm UTC](https://forum.inductiveautomation.com/t/date-popup-date-property/276 "2007-05-15T22:07:49Z")
I am trying to dynamically change the date selected when i activate the internal frame. The queries dont give me any errors, but the date isnt changing. I think its due to format errors, but i am not sure. here is my co… --- ## [Basic database layout theory - static versus dynamic schema](https://forum.inductiveautomation.com/t/basic-database-layout-theory-static-versus-dynamic-schema/275)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [May 10, 2007, 5:33pm UTC](https://forum.inductiveautomation.com/t/basic-database-layout-theory-static-versus-dynamic-schema/275 "2007-05-10T17:33:36Z")
Let me define a term - schema refers to the structure of your database (tables, columns, keys) as opposed to the data in it (rows). Static schema refers to that structure never changing. A dynamic schema is one that chan… --- ## [Setting Touchscreen mode for autologin computers](https://forum.inductiveautomation.com/t/setting-touchscreen-mode-for-autologin-computers/273)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 3\ **Last updated:** [May 8, 2007, 9:49pm UTC](https://forum.inductiveautomation.com/t/setting-touchscreen-mode-for-autologin-computers/273 "2007-05-08T21:49:43Z")
I have a touchscreen computers that are set to autologin. How can I set them to touchscreen mode automatically? How can I set other desktop computers to launch the projects without going into touchscreen? Can the user… --- ## [Open a web page within FPMI application](https://forum.inductiveautomation.com/t/open-a-web-page-within-fpmi-application/272)
**Author:** [@timg](https://forum.inductiveautomation.com/u/timg)\ **Replies:** 4\ **Last updated:** [May 7, 2007, 4:39pm UTC](https://forum.inductiveautomation.com/t/open-a-web-page-within-fpmi-application/272 "2007-05-07T16:39:50Z")
I would like to open a web page within my FPMI application. I've used the openURL but it opens a seperate window. I would like the web page to open within my application. [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=52) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=54)