# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=37 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 38 --- ## [FactorySQL and Microsoft Clustering](https://forum.inductiveautomation.com/t/factorysql-and-microsoft-clustering/877)
**Author:** [@jimwinchell](https://forum.inductiveautomation.com/u/jimwinchell)\ **Replies:** 2\ **Last updated:** [November 21, 2008, 12:21am UTC](https://forum.inductiveautomation.com/t/factorysql-and-microsoft-clustering/877 "2008-11-21T00:21:45Z")
Hello, We are currently installing/configuring a new (2) two node server cluster with a SQL Server 2005 failover cluster. We have not used FactorySQL long, but we would like to take advantage of our cluster and instal… --- ## [OPC Server Data Goes Away - FSQL still writes to DB](https://forum.inductiveautomation.com/t/opc-server-data-goes-away-fsql-still-writes-to-db/876)
**Author:** [@billysmithde](https://forum.inductiveautomation.com/u/billysmithde)\ **Replies:** 3\ **Last updated:** [November 20, 2008, 6:00pm UTC](https://forum.inductiveautomation.com/t/opc-server-data-goes-away-fsql-still-writes-to-db/876 "2008-11-20T18:00:47Z")
When I disconnect my datasource to the OPC server (i.e. pull the network cable to the plc generating the data) Kepware says 'Device no responding'. In OPC Quick Client, the Values are 'Unknown' and the Quality is 'Bad'. … --- ## [Regular Expressions](https://forum.inductiveautomation.com/t/regular-expressions/874)
**Author:** [@dmcglynn](https://forum.inductiveautomation.com/u/dmcglynn)\ **Replies:** 5\ **Last updated:** [November 19, 2008, 7:34pm UTC](https://forum.inductiveautomation.com/t/regular-expressions/874 "2008-11-19T19:34:43Z")
Are there any future plans for support of Regular Expressions in action-items? I've got a situation where I'm migrating over some perl-programs which were used to collect data from an OPC server, do some text-conversio… --- ## [Trigger store to DB if any tag in group changes value?](https://forum.inductiveautomation.com/t/trigger-store-to-db-if-any-tag-in-group-changes-value/875)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 7\ **Last updated:** [November 19, 2008, 7:06pm UTC](https://forum.inductiveautomation.com/t/trigger-store-to-db-if-any-tag-in-group-changes-value/875 "2008-11-19T19:06:15Z")
Is it possible to trigger a group to store to the DB if any tag in the group changes value? I just put together an Access interface for our production supervisors to set the schedule of the startup and shutdown of an … --- ## [Regular expressions in Fsql, via plugin or builtin?](https://forum.inductiveautomation.com/t/regular-expressions-in-fsql-via-plugin-or-builtin/871)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 7\ **Last updated:** [November 19, 2008, 4:21pm UTC](https://forum.inductiveautomation.com/t/regular-expressions-in-fsql-via-plugin-or-builtin/871 "2008-11-19T16:21:09Z")
I took a peak through the FSQL expression language, Didn't find an easy way to do regular expressions. Am I missing a built-in function? Or is this more of a plugin style thing. Thanks, Mike --- ## [MSSQL select where value in column changed](https://forum.inductiveautomation.com/t/mssql-select-where-value-in-column-changed/872)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [November 18, 2008, 12:28am UTC](https://forum.inductiveautomation.com/t/mssql-select-where-value-in-column-changed/872 "2008-11-18T00:28:57Z")
I was wondering, I have a similar posting on a SQL forum site, it has been there 2 days and it must not get the kind of traffic and attention this site gets. SO I am hoping someone on here would be willing to guide me in… --- ## [Dynamically creating objects](https://forum.inductiveautomation.com/t/dynamically-creating-objects/865)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 10\ **Last updated:** [November 11, 2008, 9:42pm UTC](https://forum.inductiveautomation.com/t/dynamically-creating-objects/865 "2008-11-11T21:42:43Z")
Is there any way to dynamically create objects at run-time? I'm thinking of something like a factory overview page with custom icons pasted at locations read from a database. Al --- ## [Dynamic Tag Reads & Command Line Parameters](https://forum.inductiveautomation.com/t/dynamic-tag-reads-command-line-parameters/868)
**Author:** [@bryan\_cook](https://forum.inductiveautomation.com/u/bryan_cook)\ **Replies:** 2\ **Last updated:** [November 11, 2008, 9:28pm UTC](https://forum.inductiveautomation.com/t/dynamic-tag-reads-command-line-parameters/868 "2008-11-11T21:28:41Z")
Two questions, hopefully they make sense ... Is it possible to read a dynamic number of PLC tags with FactorySQL, possibly with some form of Action Item? For example, in one scenario I would wish to read five tags co… --- ## [Table resize column](https://forum.inductiveautomation.com/t/table-resize-column/867)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [November 11, 2008, 7:30pm UTC](https://forum.inductiveautomation.com/t/table-resize-column/867 "2008-11-11T19:30:04Z")
I was wondering, in the table component of FPMI, is there a way to auto resize the data in a particular column? Example: say the initial size of the column is 18 pixels high and has a capacity to display upto 25 charac… --- ## [Popup Calendar returning null pointer error](https://forum.inductiveautomation.com/t/popup-calendar-returning-null-pointer-error/870)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [November 11, 2008, 7:27pm UTC](https://forum.inductiveautomation.com/t/popup-calendar-returning-null-pointer-error/870 "2008-11-11T19:27:51Z")
I have a popup calendar on my window that gets the date from an entry in the dataset that a user selects. The problem is that sometimes this value starts off as Null from the database. I have the date field bound to thi… --- ## [PDF Viewer requires language pack update](https://forum.inductiveautomation.com/t/pdf-viewer-requires-language-pack-update/869)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 1\ **Last updated:** [November 11, 2008, 7:11pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-requires-language-pack-update/869 "2008-11-11T19:11:41Z")
I am using an older version of Reporting Plugin (1.1.9) and cannot open a PDF that makes use of the Japanese language font. I did have to update my Adobe reader for this. Is there a method of viewing this PDF or do I h… --- ## [Saving PDF into db table as BLOB](https://forum.inductiveautomation.com/t/saving-pdf-into-db-table-as-blob/866)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 6\ **Last updated:** [November 11, 2008, 3:49pm UTC](https://forum.inductiveautomation.com/t/saving-pdf-into-db-table-as-blob/866 "2008-11-11T15:49:06Z")
Hello all knowing ones, I am looking for a generic method to insert PDF files into a MS SQL table. My reason for inserting the whole PDF is that access is needed from different locations and not all have access to the… --- ## [Table questions regarding FSQL](https://forum.inductiveautomation.com/t/table-questions-regarding-fsql/864)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [November 6, 2008, 5:53pm UTC](https://forum.inductiveautomation.com/t/table-questions-regarding-fsql/864 "2008-11-06T17:53:44Z")
Earlier today about 5pm EST I talked with Jim, he said he would pass the information along to someone when they became free. I do not know whom got the message but thought I would write this from home since at around 6 I… --- ## [Datasets](https://forum.inductiveautomation.com/t/datasets/718)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 12\ **Last updated:** [November 3, 2008, 8:40pm UTC](https://forum.inductiveautomation.com/t/datasets/718 "2008-11-03T20:40:59Z")
I am missing something fundamental about datasets. Here is what I'm trying to do: I added a dataset as a dynamic property to the root container. The dataset has three columns (an int and two strings). I populate this d… --- ## [Problem with charts](https://forum.inductiveautomation.com/t/problem-with-charts/863)
**Author:** [@tegola](https://forum.inductiveautomation.com/u/tegola)\ **Replies:** 3\ **Last updated:** [November 3, 2008, 6:01pm UTC](https://forum.inductiveautomation.com/t/problem-with-charts/863 "2008-11-03T18:01:05Z")
The chart doesn't draw pens on the client. This happens only if the client is launched remotely. The same with the demo on your site. Any clue? --- ## [Reporting Plug in conversion question](https://forum.inductiveautomation.com/t/reporting-plug-in-conversion-question/861)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 6\ **Last updated:** [November 3, 2008, 3:57pm UTC](https://forum.inductiveautomation.com/t/reporting-plug-in-conversion-question/861 "2008-11-03T15:57:02Z")
On a page I have a reporting screen in FPMI so I am hoping I am posting this in the right section. Anyway the dataset that populates this reporting screen comes from a query. The one section of the query brings in a valu… --- ## [OPC addressing weirdness](https://forum.inductiveautomation.com/t/opc-addressing-weirdness/862)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 1\ **Last updated:** [October 31, 2008, 5:38pm UTC](https://forum.inductiveautomation.com/t/opc-addressing-weirdness/862 "2008-10-31T17:38:30Z")
I'd love to be able to fully take advantage of the drag and drop abilities of FactorySQL, but the addresses aren't showing up correctly. For instance,when I browse an OPC server and look for a bit (say B3:0/15), the elem… --- ## [Run time query math](https://forum.inductiveautomation.com/t/run-time-query-math/853)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 20\ **Last updated:** [October 30, 2008, 8:55pm UTC](https://forum.inductiveautomation.com/t/run-time-query-math/853 "2008-10-30T20:55:49Z")
I am in the process of designing a screen for the supervisors that would give runtime and efficiencies. I was having some trouble coming up with a SQL query that would do what I wanted so I found a work around that seems… --- ## [Driving properties using a Root Container dynamic property?](https://forum.inductiveautomation.com/t/driving-properties-using-a-root-container-dynamic-property/859)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 6\ **Last updated:** [October 30, 2008, 8:31pm UTC](https://forum.inductiveautomation.com/t/driving-properties-using-a-root-container-dynamic-property/859 "2008-10-30T20:31:47Z")
Is it possible to setup one dynamic property on the root container and use that to Drive several objects style properties? I can't seem to figure out how to do it w/out defining Dynamic Properties on each object. --- ## [Stored Procedure group problem](https://forum.inductiveautomation.com/t/stored-procedure-group-problem/854)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 46\ **Last updated:** [October 29, 2008, 6:58pm UTC](https://forum.inductiveautomation.com/t/stored-procedure-group-problem/854 "2008-10-29T18:58:33Z")
I have a stored procedure I'm trying to get working in FactorySQL and I keep getting the same error. "...Procedure 'SP\_LRunNumbers' expects parameter '@inputRunNumber', which is not supplied." My stored procedure is set … --- ## [Times entered this week are off by 1 hour](https://forum.inductiveautomation.com/t/times-entered-this-week-are-off-by-1-hour/857)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 13\ **Last updated:** [October 29, 2008, 1:55pm UTC](https://forum.inductiveautomation.com/t/times-entered-this-week-are-off-by-1-hour/857 "2008-10-29T13:55:10Z")
I have an application where the users input data for the database tables. There are a couple of datetime fields. Just starting this week, they enter a time and when they pull that record back up from the database, the … --- ## [Java Web Start problems](https://forum.inductiveautomation.com/t/java-web-start-problems/856)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 5\ **Last updated:** [October 28, 2008, 8:14pm UTC](https://forum.inductiveautomation.com/t/java-web-start-problems/856 "2008-10-28T20:14:59Z")
I've recently set up remote access to a customer's site via a VPN connection. I am frequently having a problem with Java Web Start when I try to run the application remotely. The download starts OK, but once it reaches… --- ## [Database indexing and keys](https://forum.inductiveautomation.com/t/database-indexing-and-keys/855)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [October 27, 2008, 6:00pm UTC](https://forum.inductiveautomation.com/t/database-indexing-and-keys/855 "2008-10-27T18:00:15Z")
I was wondering, when using the Inductive Automation software and running queries on Microsoft SQL I know that you can setup indexes and such in SQL. But a DB programmer asked me if in your software you have to call the … --- ## [Save an image from a camera](https://forum.inductiveautomation.com/t/save-an-image-from-a-camera/846)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 7\ **Last updated:** [October 25, 2008, 1:48am UTC](https://forum.inductiveautomation.com/t/save-an-image-from-a-camera/846 "2008-10-25T01:48:41Z")
I have been experimenting with the camera component in FPMI and I like what I see. However, I now want to save a snapshot of the image based on a trigger. How would I do this in FSQL? --- ## [Can I trigger group on status of more than one item?](https://forum.inductiveautomation.com/t/can-i-trigger-group-on-status-of-more-than-one-item/851)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [October 23, 2008, 11:32pm UTC](https://forum.inductiveautomation.com/t/can-i-trigger-group-on-status-of-more-than-one-item/851 "2008-10-23T23:32:24Z")
I have a group that is writting to the db every 5 seconds even when all the machines are stopped. I would like to have this trigger only when they are in production mode. The catch is that there are two machines feedin… --- ## [Conditional Group Trigger](https://forum.inductiveautomation.com/t/conditional-group-trigger/852)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [October 23, 2008, 11:26pm UTC](https://forum.inductiveautomation.com/t/conditional-group-trigger/852 "2008-10-23T23:26:42Z")
I have a group where the trigger is a value change of a string. The test equipment I am monitoring will write an empty string if there is an invalid test. The group is seeing this change to an empty string and running th… --- ## [Multiple MySQL versions on same PC?](https://forum.inductiveautomation.com/t/multiple-mysql-versions-on-same-pc/849)
**Author:** [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Replies:** 9\ **Last updated:** [October 20, 2008, 11:49pm UTC](https://forum.inductiveautomation.com/t/multiple-mysql-versions-on-same-pc/849 "2008-10-20T23:49:27Z")
I would like to drop the latest version of FactorySQL onto a PC that is already running a Java application utilizing MySQL ver 4.1. I would also like to use MySQL 5.x that comes with FSQL. Can they peacefully coexist or … --- ## [Determining window size in Python](https://forum.inductiveautomation.com/t/determining-window-size-in-python/749)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 13\ **Last updated:** [October 20, 2008, 8:09am UTC](https://forum.inductiveautomation.com/t/determining-window-size-in-python/749 "2008-10-20T08:09:40Z")
Can you determine the x and y size of a window in script? --- ## [Error excetuting update query](https://forum.inductiveautomation.com/t/error-excetuting-update-query/829)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 8\ **Last updated:** [October 17, 2008, 8:39pm UTC](https://forum.inductiveautomation.com/t/error-excetuting-update-query/829 "2008-10-17T20:39:18Z")
I have a standard group with an OPC item called 'RollProfile' and the contents are shown below. Dragging this item into a group creates a data type of 'array'. FSQL created varchar(255) in MS-SQL but I changed it to varc… --- ## [Correct Place?](https://forum.inductiveautomation.com/t/correct-place/845)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 8\ **Last updated:** [October 17, 2008, 4:40pm UTC](https://forum.inductiveautomation.com/t/correct-place/845 "2008-10-17T16:40:07Z")
I am not even sure which heading to put this under FPMI or FSQL. I am leaning toward FSQL but again am unsure. Here is my question: I am looking at doing some changing on some of my project. However I know where I want… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=36) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=38)