# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=43 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 44 --- ## [Problem with Form Loading](https://forum.inductiveautomation.com/t/problem-with-form-loading/669)
**Author:** [@neato20](https://forum.inductiveautomation.com/u/neato20)\ **Replies:** 3\ **Last updated:** [May 13, 2008, 10:31pm UTC](https://forum.inductiveautomation.com/t/problem-with-form-loading/669 "2008-05-13T22:31:11Z")
I have a form that has many toggle buttons and enabled/disabled text fields that rely on those buttons and calculations going on when the buttons are pressed or information is entered. My problem is that whenever I close… --- ## [Deleting Files](https://forum.inductiveautomation.com/t/deleting-files/670)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 7\ **Last updated:** [May 13, 2008, 4:15pm UTC](https://forum.inductiveautomation.com/t/deleting-files/670 "2008-05-13T16:15:24Z")
I have a file importing into my DB after I open a window.I want to delete this file after the import. What scripting would I use for this. --- ## [FSQL Service unable to start/connect](https://forum.inductiveautomation.com/t/fsql-service-unable-to-start-connect/667)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 8\ **Last updated:** [May 12, 2008, 5:35pm UTC](https://forum.inductiveautomation.com/t/fsql-service-unable-to-start-connect/667 "2008-05-12T17:35:32Z")
Our customer decided to change IP address schemes on us, and ever since I changed the IP of the PC that is running FSQL, I have had problems. I am not 100% sure the problem is with FSQL, but I am ruling out RSLinx as the… --- ## [Using PMI to view documents](https://forum.inductiveautomation.com/t/using-pmi-to-view-documents/668)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [May 12, 2008, 4:59pm UTC](https://forum.inductiveautomation.com/t/using-pmi-to-view-documents/668 "2008-05-12T16:59:39Z")
I'm developing PMI to be used for our document control systems, my plan is to have PMI link a table of addresses to documents that currently reside on our server. I've gotten the document viewer to work with .html, .ht… --- ## [Dropdown list initial value](https://forum.inductiveautomation.com/t/dropdown-list-initial-value/665)
**Author:** [@deryk](https://forum.inductiveautomation.com/u/deryk)\ **Replies:** 2\ **Last updated:** [May 7, 2008, 5:21am UTC](https://forum.inductiveautomation.com/t/dropdown-list-initial-value/665 "2008-05-07T05:21:43Z")
How can I change the initial value of a dropdown list? Specifically, I'd like to change from "" to "" eg a value not in the assigned dataset. Also, how would I set it to a default value from my dataset? --- ## [Converting an integer to a string](https://forum.inductiveautomation.com/t/converting-an-integer-to-a-string/664)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 3\ **Last updated:** [May 6, 2008, 3:59am UTC](https://forum.inductiveautomation.com/t/converting-an-integer-to-a-string/664 "2008-05-06T03:59:35Z")
Hi, I need to concatenate a string where one piece of the data is an integer. I have a numeric text field (RecipeInUse) bound to a recipe number in a table. I then defined a dynamic property (RecipeField) with the ex… --- ## [Brain Teaser](https://forum.inductiveautomation.com/t/brain-teaser/659)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 4\ **Last updated:** [May 5, 2008, 6:42pm UTC](https://forum.inductiveautomation.com/t/brain-teaser/659 "2008-05-05T18:42:44Z")
Is a nested query possible? First part of the query would need to select distict sequence numbers from a production schedule (threre are mulitples). ex. select distinct(seqno) from schedule; The second part would n… --- ## [Getting SQL truncation from runPrepStmt](https://forum.inductiveautomation.com/t/getting-sql-truncation-from-runprepstmt/662)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 2\ **Last updated:** [May 5, 2008, 4:07pm UTC](https://forum.inductiveautomation.com/t/getting-sql-truncation-from-runprepstmt/662 "2008-05-05T16:07:10Z")
I have a popup window that collectes a bunch of values from the user to update an SQL table. I have the following code statement to insert a new record into the table: if ID == None: fpmi.db.runPrepStmt("ins… --- ## [Network Architectures for Industrial Automation](https://forum.inductiveautomation.com/t/network-architectures-for-industrial-automation/490)
**Author:** [@Industrial\_Ethernet](https://forum.inductiveautomation.com/u/Industrial_Ethernet)\ **Replies:** 16\ **Last updated:** [May 3, 2008, 5:08pm UTC](https://forum.inductiveautomation.com/t/network-architectures-for-industrial-automation/490 "2008-05-03T17:08:04Z")
Dear folks I am creating a new section on network architecture. Please feel free to post your questions here. Excellent online resource created by Inductive Automation. Regards Pradeep pp@cisco.com --- ## [Question on frontend and group errors](https://forum.inductiveautomation.com/t/question-on-frontend-and-group-errors/660)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 3\ **Last updated:** [May 1, 2008, 7:11pm UTC](https://forum.inductiveautomation.com/t/question-on-frontend-and-group-errors/660 "2008-05-01T19:11:27Z")
Does the front end only show errors that occur while it is running, or does it load errors that occured before? The service status window shows that a few group errors have occured, but when I look at the groups in the f… --- ## [Soundex](https://forum.inductiveautomation.com/t/soundex/656)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 3\ **Last updated:** [May 1, 2008, 5:06pm UTC](https://forum.inductiveautomation.com/t/soundex/656 "2008-05-01T17:06:11Z")
I'm wonderig if this is really feasible or not. I'm interfacing to a machine where I get basic order information such as OrderName, Quantity, etc via tcpip. These orders are planned at the machine GUI, and have nothing t… --- ## [Problems Migrating Between MySQL and MSSQL](https://forum.inductiveautomation.com/t/problems-migrating-between-mysql-and-mssql/658)
**Author:** [@neato20](https://forum.inductiveautomation.com/u/neato20)\ **Replies:** 1\ **Last updated:** [May 1, 2008, 4:31pm UTC](https://forum.inductiveautomation.com/t/problems-migrating-between-mysql-and-mssql/658 "2008-05-01T16:31:51Z")
I posted this under "FactoryPMI Problems but then realized it might be better suited under this heading. I am having a problem with migrating all my forms and SQL queries from MySQL to MSSQL. The code for the script th… --- ## [Problems with MySQL to MSSQL Migration In Scripts](https://forum.inductiveautomation.com/t/problems-with-mysql-to-mssql-migration-in-scripts/657)
**Author:** [@neato20](https://forum.inductiveautomation.com/u/neato20)\ **Replies:** 1\ **Last updated:** [May 1, 2008, 4:26pm UTC](https://forum.inductiveautomation.com/t/problems-with-mysql-to-mssql-migration-in-scripts/657 "2008-05-01T16:26:53Z")
I am having a problem with migrating all my forms and SQL queries from MySQL to MSSQL. The code for the script that is excuted whenever I want to try and open a CSV file is in the attached file. I do not think my syntax … --- ## [FPMI getSystemFlags questions](https://forum.inductiveautomation.com/t/fpmi-getsystemflags-questions/654)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [May 1, 2008, 7:01am UTC](https://forum.inductiveautomation.com/t/fpmi-getsystemflags-questions/654 "2008-05-01T07:01:33Z")
Until we receive the memory upgrade for our server, currently it resides at 2gig we are taking it to 4gig, our prject occasionally shuts down on a thread locked issue. In an effort to make all mgmt aware that something h… --- ## [Defalut Date syntax for MicroSoft SQL Server](https://forum.inductiveautomation.com/t/defalut-date-syntax-for-microsoft-sql-server/655)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [April 30, 2008, 4:26pm UTC](https://forum.inductiveautomation.com/t/defalut-date-syntax-for-microsoft-sql-server/655 "2008-04-30T16:26:09Z")
Do you know the default syntax? ex. yyyy-mm-dd or mm/dd/yy???? --- ## [Upload from Excel to MySQL with a Where statement](https://forum.inductiveautomation.com/t/upload-from-excel-to-mysql-with-a-where-statement/630)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 4\ **Last updated:** [April 29, 2008, 2:28pm UTC](https://forum.inductiveautomation.com/t/upload-from-excel-to-mysql-with-a-where-statement/630 "2008-04-29T14:28:13Z")
How would I add a where statement to exclude rows already loaded into the table? LOAD DATA LOCAL INFILE 'C:\\FilePath\\File.csv' INTO TABLE table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\n' (index, name); --- ## [SMS Text Messaging](https://forum.inductiveautomation.com/t/sms-text-messaging/653)
**Author:** [@smd](https://forum.inductiveautomation.com/u/smd)\ **Replies:** 1\ **Last updated:** [April 28, 2008, 3:29pm UTC](https://forum.inductiveautomation.com/t/sms-text-messaging/653 "2008-04-28T15:29:29Z")
Are there any plans to add SMS text messaging as an option in FSQL alerting? Is there any other way currently in FSQL or FPMI to accomplish this? --- ## [Setting outputs from FactoryPMI](https://forum.inductiveautomation.com/t/setting-outputs-from-factorypmi/642)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [April 26, 2008, 4:37am UTC](https://forum.inductiveautomation.com/t/setting-outputs-from-factorypmi/642 "2008-04-26T04:37:25Z")
I'm a bit stuck with this one. I have a FactoryPMI system which has to send a number of control outputs to a PLC. Clicking on an item of plant opens a popup which contains all the controls for that item, plus an Execut… --- ## [Combining data from several servers](https://forum.inductiveautomation.com/t/combining-data-from-several-servers/650)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [April 26, 2008, 4:08am UTC](https://forum.inductiveautomation.com/t/combining-data-from-several-servers/650 "2008-04-26T04:08:20Z")
I'm looking at installing several systems for a company who have a number of geographically separate facilities. The retargetting feature to allow connection to a number of different systems looked interesting. I have … --- ## [Help debugging](https://forum.inductiveautomation.com/t/help-debugging/649)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [April 25, 2008, 3:50pm UTC](https://forum.inductiveautomation.com/t/help-debugging/649 "2008-04-25T15:50:29Z")
attach is a sample of code I am testing. I am getting an error with the use of the SWITCH command. So what did I forget in the switch command? The first line checks to see if the value which is an integer is greater th… --- ## [Timestamp milliseconds in MySQL](https://forum.inductiveautomation.com/t/timestamp-milliseconds-in-mysql/647)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 13\ **Last updated:** [April 25, 2008, 1:37am UTC](https://forum.inductiveautomation.com/t/timestamp-milliseconds-in-mysql/647 "2008-04-25T01:37:05Z")
I'm reading that MySQL does not support fractional seconds in the Timestamp data type. Is this true? Is there any guidance you can offer to work around this shortcoming to display fractional second data in a chart? T… --- ## [Commercial hosting](https://forum.inductiveautomation.com/t/commercial-hosting/574)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 8\ **Last updated:** [April 24, 2008, 6:26pm UTC](https://forum.inductiveautomation.com/t/commercial-hosting/574 "2008-04-24T18:26:20Z")
What experience/advice/warning do you have regarding running OPC server, FSQL, FPMI and MySQL on a remote commercial host site? Can you recommend any hosts that have experience with your products? Thanks. --- ## [Error checking Formatted Text Field](https://forum.inductiveautomation.com/t/error-checking-formatted-text-field/648)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 2\ **Last updated:** [April 23, 2008, 10:41pm UTC](https://forum.inductiveautomation.com/t/error-checking-formatted-text-field/648 "2008-04-23T22:41:30Z")
I want to use Formatted Text Field for input to database, and expected to see some sort of 'isValid' property. Is there such a thing? --- ## [setSelectedValue and requestFocusInWidow](https://forum.inductiveautomation.com/t/setselectedvalue-and-requestfocusinwidow/641)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 10\ **Last updated:** [April 23, 2008, 5:14pm UTC](https://forum.inductiveautomation.com/t/setselectedvalue-and-requestfocusinwidow/641 "2008-04-23T17:14:47Z")
I am trying to programmatically set the Selected Focus Border around a particular item in a list box. Here is my script. list1 = event.source.parent.getComponent('MenuContainer1').getComponent('list') print list1 #li… --- ## [Missing channel and devices in KepWare](https://forum.inductiveautomation.com/t/missing-channel-and-devices-in-kepware/646)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 1\ **Last updated:** [April 22, 2008, 5:33pm UTC](https://forum.inductiveautomation.com/t/missing-channel-and-devices-in-kepware/646 "2008-04-22T17:33:04Z")
I had added a new channel and several devices in KepWare on the 8th of April. I went back today to work on them, and they were gone. I looked and the devices are still in FSQL, but obviously they are not talking to any… --- ## [I need to have reporting plugin wait for tables to update](https://forum.inductiveautomation.com/t/i-need-to-have-reporting-plugin-wait-for-tables-to-update/645)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [April 22, 2008, 5:31pm UTC](https://forum.inductiveautomation.com/t/i-need-to-have-reporting-plugin-wait-for-tables-to-update/645 "2008-04-22T17:31:20Z")
I have some FPMI code that runs several SQL proceedures and builds/populates an SQL table. It then opens a new window with the report for that table so the user can print it. The problem is that when the reporting wind… --- ## [Question on hybrid security profile](https://forum.inductiveautomation.com/t/question-on-hybrid-security-profile/643)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 6\ **Last updated:** [April 22, 2008, 5:28pm UTC](https://forum.inductiveautomation.com/t/question-on-hybrid-security-profile/643 "2008-04-22T17:28:27Z")
Can you tell me how to impliment the hybrid security profile? I assume that I need to add a AD/Hybrid profile, but it looks like all that it is asking for is the AD information in the add screen. How do I impliment grou… --- ## [Turn off SQLTag Component feedback](https://forum.inductiveautomation.com/t/turn-off-sqltag-component-feedback/644)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [April 22, 2008, 12:14am UTC](https://forum.inductiveautomation.com/t/turn-off-sqltag-component-feedback/644 "2008-04-22T00:14:50Z")
Is there any way to Turn off SQLTag Component feedback? I setup 90% of my projects remotely before hooking up to a PLC. Therefore, I'm dealing with a lot of red boxes on my screen. Any way to turn that off when develo… --- ## [runScript in SQLTag](https://forum.inductiveautomation.com/t/runscript-in-sqltag/639)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 4\ **Last updated:** [April 17, 2008, 6:58pm UTC](https://forum.inductiveautomation.com/t/runscript-in-sqltag/639 "2008-04-17T18:58:29Z")
I am trying to use the runScript() function as the expression defining a tag value. I get this error (sent to you in full). Error parsing expression: Parse error: Function 'runScript' is not defined. What's up? Can… --- ## [Populating a component table from another table click event](https://forum.inductiveautomation.com/t/populating-a-component-table-from-another-table-click-event/640)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [April 17, 2008, 6:53pm UTC](https://forum.inductiveautomation.com/t/populating-a-component-table-from-another-table-click-event/640 "2008-04-17T18:53:03Z")
I have two table components on a window (tblCellar,tblChosen). One is populated from a database. The other one table I want to populate as the user clicks on rows from the first table. I have the following: if even… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=42) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=44)