# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=57 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 58 --- ## [Help - SQL Server authentication problem](https://forum.inductiveautomation.com/t/help-sql-server-authentication-problem/143)
**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\ **Replies:** 1\ **Last updated:** [December 2, 2006, 1:04am UTC](https://forum.inductiveautomation.com/t/help-sql-server-authentication-problem/143 "2006-12-02T01:04:22Z")
When trying to connect to a local MS SQL Server I get an error message that says: "Problem: Login failed for user 'Username'. Reason: Not associated with a trusted SQL Server connection." What's going on? --- ## [Siemens S7 and DB2](https://forum.inductiveautomation.com/t/siemens-s7-and-db2/148)
**Author:** [@Fons](https://forum.inductiveautomation.com/u/Fons)\ **Replies:** 3\ **Last updated:** [November 28, 2006, 8:57pm UTC](https://forum.inductiveautomation.com/t/siemens-s7-and-db2/148 "2006-11-28T20:57:37Z")
Hi Nathan, I see your name a lot in all kinds of fora about this subject (Linux SCADA) and you almost got me convinced :slight\_smile: I'm planning to integrate a SCADA system in an high tech /low automated production … --- ## [Problems running a project on one particular Windows pc](https://forum.inductiveautomation.com/t/problems-running-a-project-on-one-particular-windows-pc/151)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [November 27, 2006, 11:58pm UTC](https://forum.inductiveautomation.com/t/problems-running-a-project-on-one-particular-windows-pc/151 "2006-11-27T23:58:22Z")
Hi All: We are one of MS's beta testers for Windows Vista and Longhorn server. It is probably unlikely that you have tested Factory PMI against it, so I don't know if you can respond to this, but there is one machine … --- ## [Binding to an unbindable property](https://forum.inductiveautomation.com/t/binding-to-an-unbindable-property/150)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [November 27, 2006, 9:25pm UTC](https://forum.inductiveautomation.com/t/binding-to-an-unbindable-property/150 "2006-11-27T21:25:20Z")
I'm trying to create a text label that shows which index is selected based on a dropdown list. The data in the dropdown list is dynamically populated. If there are 4 possible options and I have the first selected, I'd li… --- ## [Vendor Not Set](https://forum.inductiveautomation.com/t/vendor-not-set/149)
**Author:** [@dmusser](https://forum.inductiveautomation.com/u/dmusser)\ **Replies:** 1\ **Last updated:** [November 27, 2006, 2:18am UTC](https://forum.inductiveautomation.com/t/vendor-not-set/149 "2006-11-27T02:18:01Z")
How do I Clear the Vendor Not Set message? Put our company in Place? --- ## [Dynamic SQL datasource for Dropdown](https://forum.inductiveautomation.com/t/dynamic-sql-datasource-for-dropdown/146)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 2\ **Last updated:** [November 22, 2006, 5:30pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql-datasource-for-dropdown/146 "2006-11-22T17:30:03Z")
Hi all... First, I feel like I have completely lost the plot! Here's the problem: Main window with 6 buttons, one for each line (line 1 thru line 6) A container with a dropdown in it - I want the dataset to be related to… --- ## [Password Protect Button Action](https://forum.inductiveautomation.com/t/password-protect-button-action/144)
**Author:** [@ChuckP](https://forum.inductiveautomation.com/u/ChuckP)\ **Replies:** 2\ **Last updated:** [November 22, 2006, 12:56pm UTC](https://forum.inductiveautomation.com/t/password-protect-button-action/144 "2006-11-22T12:56:12Z")
How do I put a password on a button. I want to require a user to input a password prior to the button preforming designed action. Thanks --- ## [Allen Bradley picos](https://forum.inductiveautomation.com/t/allen-bradley-picos/59)
**Author:** [@integrator\_adam72](https://forum.inductiveautomation.com/u/integrator_adam72)\ **Replies:** 11\ **Last updated:** [November 17, 2006, 5:52pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-picos/59 "2006-11-17T17:52:13Z")
Anyone have experience with AB Pico PLCs? How do they compare with Micros? --- ## [How do I tally production data by shift?](https://forum.inductiveautomation.com/t/how-do-i-tally-production-data-by-shift/53)
**Author:** [@IA\_old\_forum](https://forum.inductiveautomation.com/u/IA_old_forum)\ **Replies:** 3\ **Last updated:** [November 9, 2006, 3:17pm UTC](https://forum.inductiveautomation.com/t/how-do-i-tally-production-data-by-shift/53 "2006-11-09T15:17:57Z")
Mark 05JUL05 - I have 3 shifts: 12-7:00, 8-3:00, 4-11:00. I'd like to record total tonnage and peak output (both tallied in the PLC) for each shift, every shift. What would be the best way to do this? --- ## [Ability to reference queries from different pages](https://forum.inductiveautomation.com/t/ability-to-reference-queries-from-different-pages/141)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [November 9, 2006, 6:30am UTC](https://forum.inductiveautomation.com/t/ability-to-reference-queries-from-different-pages/141 "2006-11-09T06:30:06Z")
I have several pages that run the same query and if I make a change I have to make sure I change the same query on all of the pages. Would it possible to come up with a way so that we could create queries in the windows… --- ## [Pervasive SQL if/switch syntax in SELECT query](https://forum.inductiveautomation.com/t/pervasive-sql-if-switch-syntax-in-select-query/140)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 2\ **Last updated:** [November 8, 2006, 11:49pm UTC](https://forum.inductiveautomation.com/t/pervasive-sql-if-switch-syntax-in-select-query/140 "2006-11-08T23:49:35Z")
Does anybody know how to do an IF or SWITCH statement inside of a SELECT query in a PSQL database? Looking this up for a customer. They have pdf based docs that aren't all that good. If nobody knows, I'll download a t… --- ## [Login screen - several questions](https://forum.inductiveautomation.com/t/login-screen-several-questions/126)
**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Replies:** 1\ **Last updated:** [November 2, 2006, 9:38pm UTC](https://forum.inductiveautomation.com/t/login-screen-several-questions/126 "2006-11-02T21:38:24Z")
Hello, Thanks for trying out our software! These are great questions, here are the answers: \[quote="fakoly33"\]1) How can I customize the logging screen of the runtime windows ? Not only texte but also images etc ? 2)… --- ## [Random IE7 rant](https://forum.inductiveautomation.com/t/random-ie7-rant/137)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [November 2, 2006, 1:24am UTC](https://forum.inductiveautomation.com/t/random-ie7-rant/137 "2006-11-02T01:24:11Z")
What's the best browser Internet Explorer Mozilla Firefox Netscape Communicator/Naviagtor Apple Safari Opera...for Carl...1 vote.... 0voters Show results I just ran across a few forum posts where users were re… --- ## [TCP/IP convention with non-routable addresses,subnet masks](https://forum.inductiveautomation.com/t/tcp-ip-convention-with-non-routable-addresses-subnet-masks/138)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [November 1, 2006, 6:36pm UTC](https://forum.inductiveautomation.com/t/tcp-ip-convention-with-non-routable-addresses-subnet-masks/138 "2006-11-01T18:36:34Z")
After seeing some users do funny stuff with address schemes on other forums, I decided to post this. First of all the deal with the 192.168.x.x address range that's become so popular is that it's the non-routable class C… --- ## [MySQL Password](https://forum.inductiveautomation.com/t/mysql-password/136)
**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\ **Replies:** 1\ **Last updated:** [November 1, 2006, 3:42pm UTC](https://forum.inductiveautomation.com/t/mysql-password/136 "2006-11-01T15:42:03Z")
I forgot my password and cannot open the database with MySQL Administrator. Is there a way to reset the password? --- ## [SQL - Select rows when a field contains certain characters](https://forum.inductiveautomation.com/t/sql-select-rows-when-a-field-contains-certain-characters/135)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [October 31, 2006, 2:31pm UTC](https://forum.inductiveautomation.com/t/sql-select-rows-when-a-field-contains-certain-characters/135 "2006-10-31T14:31:33Z")
What would be the SQL statement to select particular rows if one of the fields contains particular characters? Example: Table with the fields studentID and StudentGrade Table looks like: 34 Freshman 22 Fros… --- ## [Pervasive DBM](https://forum.inductiveautomation.com/t/pervasive-dbm/129)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [October 26, 2006, 6:26pm UTC](https://forum.inductiveautomation.com/t/pervasive-dbm/129 "2006-10-26T18:26:11Z")
Hae you ever connected to a Pervasive database? --- ## [Insert new record disabled in action tab](https://forum.inductiveautomation.com/t/insert-new-record-disabled-in-action-tab/131)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 0\ **Last updated:** [October 26, 2006, 3:19pm UTC](https://forum.inductiveautomation.com/t/insert-new-record-disabled-in-action-tab/131 "2006-10-26T15:19:08Z")
Certainly! Essentially, the "insert new record" button is disabled if your group mode is set to anything other than OPC-\>DB. The reason is: All of the other modes require reading from the database. It would make no se… --- ## [Unable to connect to service msg form FSQL service status](https://forum.inductiveautomation.com/t/unable-to-connect-to-service-msg-form-fsql-service-status/130)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 1\ **Last updated:** [October 25, 2006, 8:23pm UTC](https://forum.inductiveautomation.com/t/unable-to-connect-to-service-msg-form-fsql-service-status/130 "2006-10-25T20:23:39Z")
Hello- Generally this does not indicate a significant problem. It simply means that the status window cannot retrieve the status from the service for whatever reason. Try opening the FactorySQL frontend. If you cann… --- ## [Remote Servers](https://forum.inductiveautomation.com/t/remote-servers/124)
**Author:** [@wadewa](https://forum.inductiveautomation.com/u/wadewa)\ **Replies:** 3\ **Last updated:** [October 23, 2006, 9:28pm UTC](https://forum.inductiveautomation.com/t/remote-servers/124 "2006-10-23T21:28:24Z")
Is there a way to stop FactorySQL from refreshing the list of remote servers? I want to remove all of the servers that I am not interested in. --- ## [Moving object](https://forum.inductiveautomation.com/t/moving-object/128)
**Author:** [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Replies:** 0\ **Last updated:** [October 23, 2006, 7:03pm UTC](https://forum.inductiveautomation.com/t/moving-object/128 "2006-10-23T19:03:35Z")
Unfortunately, true path based animation is not currently available, although this is a pending feature. There are two types of animation that are currently supported Rotational Animation. This type of animation is a… --- ## [Word wrapping column headers of the table object](https://forum.inductiveautomation.com/t/word-wrapping-column-headers-of-the-table-object/127)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 1\ **Last updated:** [October 23, 2006, 6:55pm UTC](https://forum.inductiveautomation.com/t/word-wrapping-column-headers-of-the-table-object/127 "2006-10-23T18:55:56Z")
How can I make the column headers of the table object multiple rows and force the text in the header to wrap? thanks travis --- ## [Table name dropdown on Action Tab](https://forum.inductiveautomation.com/t/table-name-dropdown-on-action-tab/120)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 2\ **Last updated:** [October 23, 2006, 9:59am UTC](https://forum.inductiveautomation.com/t/table-name-dropdown-on-action-tab/120 "2006-10-23T09:59:22Z")
When I drop down the table name list on the action tab - I have a list that repeats the database name instead of listing all the tables in the db... what have I done? Is it meant to be a list that I can choose from and a… --- ## [Scheduled items do not appear in list](https://forum.inductiveautomation.com/t/scheduled-items-do-not-appear-in-list/121)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 4\ **Last updated:** [October 21, 2006, 2:35pm UTC](https://forum.inductiveautomation.com/t/scheduled-items-do-not-appear-in-list/121 "2006-10-21T14:35:52Z")
I have attempted to create a couple of scheduled items and have found that they will appear in the database but even after refreshing the FSQL frontend they don't appear in the Scheduled Items list. Everything in the gro… --- ## [Multiple db column mappings](https://forum.inductiveautomation.com/t/multiple-db-column-mappings/125)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 1\ **Last updated:** [October 20, 2006, 10:52pm UTC](https://forum.inductiveautomation.com/t/multiple-db-column-mappings/125 "2006-10-20T22:52:15Z")
I have a group to INSERT a row when a line changes product, a group to INSERT a row when the shifts change and a group to UPDATE the last row on an interval (all the same table). This is how I want the t\_stamp to behave … --- ## [Updating a field in PMI from a multiple row table](https://forum.inductiveautomation.com/t/updating-a-field-in-pmi-from-a-multiple-row-table/122)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [October 18, 2006, 3:05am UTC](https://forum.inductiveautomation.com/t/updating-a-field-in-pmi-from-a-multiple-row-table/122 "2006-10-18T03:05:53Z")
How would I update a Text Field or a Numeric Text Field from the last row of a table? --- ## [Basic approaches to building graphs (and other windows?)](https://forum.inductiveautomation.com/t/basic-approaches-to-building-graphs-and-other-windows/117)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 3\ **Last updated:** [October 6, 2006, 6:20pm UTC](https://forum.inductiveautomation.com/t/basic-approaches-to-building-graphs-and-other-windows/117 "2006-10-06T18:20:30Z")
Hi All: After reading Carl and Colby's responses to the thread on assigning values to a variable in code, I think I have started to understand better how to use Factory PMI. It seems that most of what I've been trying… --- ## [Assigning a value to a variable in code](https://forum.inductiveautomation.com/t/assigning-a-value-to-a-variable-in-code/116)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 2\ **Last updated:** [October 4, 2006, 2:23am UTC](https://forum.inductiveautomation.com/t/assigning-a-value-to-a-variable-in-code/116 "2006-10-04T02:23:55Z")
I have a graph window that retreives data for a tank based on a parameter that is passed in when the window is opened. I have also placed a combo box on the window so that once it is open, users can switch to another ta… --- ## [Firing an event for window onOpen](https://forum.inductiveautomation.com/t/firing-an-event-for-window-onopen/107)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 7\ **Last updated:** [September 29, 2006, 6:01pm UTC](https://forum.inductiveautomation.com/t/firing-an-event-for-window-onopen/107 "2006-09-29T18:01:06Z")
I have a window with a few dozen tanks, with various labels and such. The tank and its level indicators, temperature labels, etc. are grouped into a container (cntTank\_1, for example) and I think copied it many times, r… --- ## [Determining if data is up to date](https://forum.inductiveautomation.com/t/determining-if-data-is-up-to-date/111)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 2\ **Last updated:** [September 29, 2006, 4:29pm UTC](https://forum.inductiveautomation.com/t/determining-if-data-is-up-to-date/111 "2006-09-29T16:29:21Z")
On a FPMI trial install; I have displayed a table -- Line number, Item code, case count -- I am using FSQL to update the SQLrows and include the timestamp. I would like to add a green check or red X (in the table) to ind… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=56) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=58)