# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=41 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 42 --- ## [Restricting OS access](https://forum.inductiveautomation.com/t/restricting-os-access/666)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 10\ **Last updated:** [July 22, 2008, 6:24pm UTC](https://forum.inductiveautomation.com/t/restricting-os-access/666 "2008-07-22T18:24:52Z")
Is there any way to restrict access to the OS when FactoryPMI is running in full-screen mode? Having a view client in an office-type environment, or using full screen on a touch-panel is fine, but in a control room it i… --- ## [Text boxes not getting values on some PCs](https://forum.inductiveautomation.com/t/text-boxes-not-getting-values-on-some-pcs/739)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [July 21, 2008, 8:16pm UTC](https://forum.inductiveautomation.com/t/text-boxes-not-getting-values-on-some-pcs/739 "2008-07-21T20:16:43Z")
I have a form that queries several database tables to get values depending on a calendar date. I bound the text field of several textboxes to individual SQL queries. These queries collected a sum, but had a fallback va… --- ## [Swap Window Navigation](https://forum.inductiveautomation.com/t/swap-window-navigation/740)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 2\ **Last updated:** [July 21, 2008, 4:08pm UTC](https://forum.inductiveautomation.com/t/swap-window-navigation/740 "2008-07-21T16:08:39Z")
Hi There... I'm using "swap" function to navigate throughout my projects. I noticed that there were multiple windows open in the "windows" menu/ I double checked & I am using the "swap" function. However, instead of… --- ## [Populating datasets](https://forum.inductiveautomation.com/t/populating-datasets/737)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 6\ **Last updated:** [July 19, 2008, 2:48pm UTC](https://forum.inductiveautomation.com/t/populating-datasets/737 "2008-07-19T14:48:40Z")
I'm changing the data displayed in a table by binding its Data property to the result of a SQL query (translated by the toDataSet function). One of the 'views' I want to display is a static list of data. How can I put… --- ## [Video camera control](https://forum.inductiveautomation.com/t/video-camera-control/738)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 3\ **Last updated:** [July 18, 2008, 8:57pm UTC](https://forum.inductiveautomation.com/t/video-camera-control/738 "2008-07-18T20:57:57Z")
I have a pan tilt IP camera that I want to be able to control from an FPMI interface. I think it just uses a url for the preset pan tilt functions. How can I access this with a button in FPMI? 192.168.3.33:80/nphContro… --- ## [Click to Graph for standard chart \[now: easychart selection\]](https://forum.inductiveautomation.com/t/click-to-graph-for-standard-chart-now-easychart-selection/736)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [July 18, 2008, 4:49pm UTC](https://forum.inductiveautomation.com/t/click-to-graph-for-standard-chart-now-easychart-selection/736 "2008-07-18T16:49:35Z")
I have implemented the click to graph "goodie" into my project. Our process department wants to be able to click on a point and extract the data for that point. Since the easy chart used in the click to graph sample does… --- ## [SQL indirect tag questions](https://forum.inductiveautomation.com/t/sql-indirect-tag-questions/735)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [July 18, 2008, 3:58pm UTC](https://forum.inductiveautomation.com/t/sql-indirect-tag-questions/735 "2008-07-18T15:58:07Z")
I was wondering if anyone could tell me if this was already in FPMI or if it is not if it would make a good idea for future improvement. If this is already available please tell me how would be the best way to accomplish… --- ## [SQL INSERT command assistance](https://forum.inductiveautomation.com/t/sql-insert-command-assistance/734)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 1\ **Last updated:** [July 17, 2008, 3:39pm UTC](https://forum.inductiveautomation.com/t/sql-insert-command-assistance/734 "2008-07-17T15:39:02Z")
I am having a problem with what should be a simple script. I know I am missing something stupid and simple. I have the following within a script on an action button: col1\_val = integerValue col2\_val = stringValue fp… --- ## [Problem with DSN connection](https://forum.inductiveautomation.com/t/problem-with-dsn-connection/732)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 11\ **Last updated:** [July 16, 2008, 7:42pm UTC](https://forum.inductiveautomation.com/t/problem-with-dsn-connection/732 "2008-07-16T19:42:38Z")
I am trying to setup a DSN connection in factorySQL. I got it working a few months ago, but now it does not seem to work. When I select the DB connection and try to "view table data" I get an error Cannot execute q… --- ## [Multiple date fields](https://forum.inductiveautomation.com/t/multiple-date-fields/733)
**Author:** [@ryanjmclaughlin](https://forum.inductiveautomation.com/u/ryanjmclaughlin)\ **Replies:** 2\ **Last updated:** [July 16, 2008, 4:16pm UTC](https://forum.inductiveautomation.com/t/multiple-date-fields/733 "2008-07-16T16:16:13Z")
I have one table where I enter both a StartDate when I create the record, but then I come back and update later and enter an EndDate. The problem I am have is that I have 2 different groups, and I want each group to us… --- ## [Lost connections](https://forum.inductiveautomation.com/t/lost-connections/728)
**Author:** [@richxie](https://forum.inductiveautomation.com/u/richxie)\ **Replies:** 8\ **Last updated:** [July 16, 2008, 12:34pm UTC](https://forum.inductiveautomation.com/t/lost-connections/728 "2008-07-16T12:34:01Z")
I am still evaluating this SCADA system. The connections was working fine 2 weeks ago. But since last week, I could not see live tags from RSOPC server though I could still see the PLC. While trying to solve that problem… --- ## [Data Entry via barcode reader](https://forum.inductiveautomation.com/t/data-entry-via-barcode-reader/727)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 4\ **Last updated:** [July 16, 2008, 2:21am UTC](https://forum.inductiveautomation.com/t/data-entry-via-barcode-reader/727 "2008-07-16T02:21:16Z")
How to send data entry via barcode reader to Database SQL Server in automatic? Best Regards --- ## [Classic chart print script](https://forum.inductiveautomation.com/t/classic-chart-print-script/730)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 1\ **Last updated:** [July 15, 2008, 11:57pm UTC](https://forum.inductiveautomation.com/t/classic-chart-print-script/730 "2008-07-15T23:57:21Z")
Can you give me a script example that will print the classic chart? I need to be able to print and I'm doing some funky stuff that requires I use the classic chart. --- ## [Items in an expression](https://forum.inductiveautomation.com/t/items-in-an-expression/712)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 3\ **Last updated:** [July 15, 2008, 5:26pm UTC](https://forum.inductiveautomation.com/t/items-in-an-expression/712 "2008-07-15T17:26:12Z")
I ran into something strange this week. I added an action item to one of my groups. I used the script from a screen I was already using in FPMI which has worked fine for months. In the script, I do some math, which ent… --- ## [Integer vs String](https://forum.inductiveautomation.com/t/integer-vs-string/729)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [July 15, 2008, 4:16pm UTC](https://forum.inductiveautomation.com/t/integer-vs-string/729 "2008-07-15T16:16:22Z")
In a dynamic property I have a value which is an Integer value. What I would like to be able to do is take another dynamic proper which is a String value and have it equal the Integer value but be 2 digits in length. S… --- ## [Changing a table's SQL query without code](https://forum.inductiveautomation.com/t/changing-a-tables-sql-query-without-code/725)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 8\ **Last updated:** [July 14, 2008, 7:59pm UTC](https://forum.inductiveautomation.com/t/changing-a-tables-sql-query-without-code/725 "2008-07-14T19:59:21Z")
I am designing a user interface with a number of radio buttons and a table. When the user clicks on a radio button, I want to change the table's SQL query and update the table to show the new data. Is it possible to d… --- ## [Selectable Y axis scale](https://forum.inductiveautomation.com/t/selectable-y-axis-scale/723)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 2\ **Last updated:** [July 14, 2008, 7:53pm UTC](https://forum.inductiveautomation.com/t/selectable-y-axis-scale/723 "2008-07-14T19:53:03Z")
I need a script to run on a slider bar to change the Y axis upper or lower bound on the easy chart. --- ## [I need the table to select row 0 after a data change](https://forum.inductiveautomation.com/t/i-need-the-table-to-select-row-0-after-a-data-change/726)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 1\ **Last updated:** [July 14, 2008, 7:10pm UTC](https://forum.inductiveautomation.com/t/i-need-the-table-to-select-row-0-after-a-data-change/726 "2008-07-14T19:10:25Z")
I have a table that stores recipes. When someone selects a recipe if this is a new recipe it will prompt the user to transfer this to the recipe table. The problem I am having is that if they have selected a recipe with … --- ## [Screen help](https://forum.inductiveautomation.com/t/screen-help/721)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [July 11, 2008, 8:38pm UTC](https://forum.inductiveautomation.com/t/screen-help/721 "2008-07-11T20:38:03Z")
Attached please find a screen shot of something I am trying to work on. The top box is a text box which obtains the job number dynamically from a data set. The table itself used this value to find all machine numbers tha… --- ## [Divider lines between cells in Reporting Designer tables](https://forum.inductiveautomation.com/t/divider-lines-between-cells-in-reporting-designer-tables/722)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [July 11, 2008, 5:34pm UTC](https://forum.inductiveautomation.com/t/divider-lines-between-cells-in-reporting-designer-tables/722 "2008-07-11T17:34:16Z")
I have reports that I create that are only partially filled in by the database. They are printed off and passed around to different departmens to finish the data entry. Currently, they do not want to change or automate… --- ## [FSQL Group execution error](https://forum.inductiveautomation.com/t/fsql-group-execution-error/719)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 5\ **Last updated:** [July 9, 2008, 5:39pm UTC](https://forum.inductiveautomation.com/t/fsql-group-execution-error/719 "2008-07-09T17:39:49Z")
Hi All, I am getting an error when running the following SQL command in a group: SELECT TimeDiff((SELECT EndTime FROM Table WHERE Table\_ndx = 10), (SELECT BeginTime FROM Table WHERE Table\_ndx = 10)) The message st… --- ## [Re.compile](https://forum.inductiveautomation.com/t/re-compile/720)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 4\ **Last updated:** [July 9, 2008, 4:31pm UTC](https://forum.inductiveautomation.com/t/re-compile/720 "2008-07-09T16:31:57Z")
I've been trying to use regular expressions on a particular function, and am struggling with the last part. I'm hoping one of you Python experts can help me out. Here's what I have so far (you can copy it right into the … --- ## [Timer values on screen](https://forum.inductiveautomation.com/t/timer-values-on-screen/628)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 13\ **Last updated:** [July 7, 2008, 3:17pm UTC](https://forum.inductiveautomation.com/t/timer-values-on-screen/628 "2008-07-07T15:17:56Z")
I was wondering if it is possible in FPMI to have some sort of timer that will start when an event occurs on the screen and as it is accumulating it will display the value. Then when the event clears it will stop accumul… --- ## [New security model not being fully pushed out to clients](https://forum.inductiveautomation.com/t/new-security-model-not-being-fully-pushed-out-to-clients/717)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [July 3, 2008, 9:27pm UTC](https://forum.inductiveautomation.com/t/new-security-model-not-being-fully-pushed-out-to-clients/717 "2008-07-03T21:27:30Z")
I have an application running that was securited under the AD/Internal Hybrid model. I ended up changing the project to the Internal model, with an autologon for the ID and password. My problem is that the users are st… --- ## [Action Item Question](https://forum.inductiveautomation.com/t/action-item-question/715)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [July 2, 2008, 4:01pm UTC](https://forum.inductiveautomation.com/t/action-item-question/715 "2008-07-02T16:01:43Z")
I think I already know the answer to this question but thought I would ask the GURU's here. I have an action item which is writes to a table in Microsoft SQL. This action item is in a group which is triggered and the t… --- ## [Faster PC = slower performance?](https://forum.inductiveautomation.com/t/faster-pc-slower-performance/713)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [July 1, 2008, 5:42pm UTC](https://forum.inductiveautomation.com/t/faster-pc-slower-performance/713 "2008-07-01T17:42:47Z")
I've finally upgraded my creaky old PC to a new one, but I'm having a couple of problems with FactoryPMI I can't work out: The load performance (either of a project or the Designer) is much worse. For example on my o… --- ## [Stored procedures for exporting CSV?](https://forum.inductiveautomation.com/t/stored-procedures-for-exporting-csv/680)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 12\ **Last updated:** [July 1, 2008, 1:52pm UTC](https://forum.inductiveautomation.com/t/stored-procedures-for-exporting-csv/680 "2008-07-01T13:52:57Z")
I was looking for the changelog on the new FSQL 4.2.0 (not in integrator portal yet), but I noticed for version 4.1.4 there was an item: Fixed - Stored procedure group CSV export not correct. Can anyone elaborate? If e… --- ## [Comparing Strings and Numbers](https://forum.inductiveautomation.com/t/comparing-strings-and-numbers/711)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [June 27, 2008, 6:03pm UTC](https://forum.inductiveautomation.com/t/comparing-strings-and-numbers/711 "2008-06-27T18:03:06Z")
I have a piece of lab equipment that has a carousel they load tests on. As they load the samples, they enter the sample data in a table on my FPMI interface. My application reads data from the lab equipment and matches… --- ## [Viewing Text Files](https://forum.inductiveautomation.com/t/viewing-text-files/689)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 10\ **Last updated:** [June 27, 2008, 4:07pm UTC](https://forum.inductiveautomation.com/t/viewing-text-files/689 "2008-06-27T16:07:39Z")
Related to my other thread, I now need to do something with the files I've created. I've stuck the list of file names in a datset, and populated a table (instead of a dropdown list, but the principle remains the same). A… --- ## [SQL query error on a table](https://forum.inductiveautomation.com/t/sql-query-error-on-a-table/709)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 6\ **Last updated:** [June 27, 2008, 3:57pm UTC](https://forum.inductiveautomation.com/t/sql-query-error-on-a-table/709 "2008-06-27T15:57:17Z")
I have a table in SQL. I have the following query against said table: SELECT coalesce(setdate,'') as datetime from error WHERE fault = 1 Now I can take SQL manager and look at the table and the first 2 rows of data h… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=40) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=42)