Invite a Co-worker

DavidSkilbeck

@tfranklin So something like below should work in a mimic script Set Table1 = Server.FindObject("XXX.XXX1") Set Table2 = Server.FindObject("XXX.XXX2") SelectedRow = Mimic.Layers("XXX").Item("Lst_1").Current1stColDataStr Set Test = Server.Query("INSERT INTO XXX2 (column1, column2, column3) SELECT column1, column2, column3 FROM XXX1 WHERE ID = '" + SelectedRow + "'" + "") Thanks,

DavidSkilbeck

Hi, can I use INSERT INTO table2 SELECT * FROM table1 WHERE condition ; Or is there some other method? Thanks,

DavidSkilbeck

Hi Guy's, I don't think there is. However, I may stand corrected. Which would be a good thing in this case. With Geo SCADA VB can you convert a string into a long? CLng does not seem to exist. Also, is there another way? Thanks,

DavidSkilbeck · ‎2020-09-24

Hi, is there a way I could add a vertical scroll bar to a text or to do something else that would give the same result? Thanks,

DavidSkilbeck · ‎2020-09-20

Hi, I want to concatenate the fields from a selected row of a data table into a string. Then display the string in a text on a mimic. What is the best way to do this? Is it with SQL, something like the start of below or is there a better way. Thanks, Set objectTable = Server.FindObject("PoC.XXXXX.XXXXX.XXXXX.Table.Data") SelectedRow = Mimic.Layers("New Layer").Item("Lst_1").Current1stColDataStr

DavidSkilbeck · ‎2020-09-19

Hi, thanks Bevan. Automation Interface externally and I am looking at approx. 70 columns to add. I have added 5 test columns through code and was hoping I could create the rest in the next day or so. Sounds like there should be no issues. Thanks,

DavidSkilbeck · ‎2020-09-18

Hi, what is the maximum number of columns in a data table and where can you find this information? Thanks,

DavidSkilbeck · ‎2020-09-17

Hi, from the schema for CDBObject I see the below. AddRecord Add Row Adds a new record to a data table. Control [retval] Record (Long) : Record ID of the new record in the data table. The below code works. However, I thought I would be able to use - obj.Interface.AddRecord(RecordId); to return the record id of the new record. But, it does not allow me. Unless I am going about the syntax wrong? Thanks, obj.Interface.AddRecord(); RecordId = obj.Interface.RecordCount(RecordId); RecordId = RecordId - 1; obj.Interface.SetValue("TestField", RecordId, "Test");

DavidSkilbeck · ‎2020-09-14

Hi, I have a data table I have created in GeoSCADA, which has a number of fields, one of the fields is called originatorID. The table is an object, so is it accessible via SQL (external using SOAP)?. Can I access the fields content. Below is a snippet from code used to read from the CDBPoint table externally. I would like to read from the table top fields as to points. I have tried, but I am not sure where to look in help files. Do I need to go about it an entirely different way (different type of table, list) or is it a case of a certain SQL statement. Select CurrentValueFormatted, FullName from CDBPoint where FullName='PoC.Web Service.Work Order.Machine 1.Request.reference'", obj, out limit Thanks,

DavidSkilbeck · ‎2020-09-10

Hi, I had tried MyObj.Interface.CurrentValue = myVal again and previously and had not got it to work. I had tried a number of combinations and had not got it to work. However, the below does seem to work for me. Thanks, PointId = 7478 Set MyObj = Server.LookUpObject(PointId) MyObj.Interface.Override AlarmSeverity MyObj.Interface.CurrentValue = AlarmSeverity MyObj.Interface.Release

Online Status	Offline
Date Last Visited	yesterday

Invite a Co-worker

Invitation Sent

About DavidSkilbeck

Re: GeoSCADA back fill from Enterprise Historian possibilities

Re: Unable to read all points in CBDPoint

Re: GPS Tracking

Re: SQL Insert into table

SQL Insert into table

String to Long

Text with vertical scroll bar

Concatenate the fields from a selected row of a data table into a string

Re: Maximum columns of a data table

Maximum columns of a data table

Add record to DataTable externally

Read Data Table externally

Re: Write to a point from global script

Support

FAQ

About

Invite a Co-worker

Invitation Sent

About DavidSkilbeck

Support

FAQ

About

Full access is just steps away!

Connect with Peers & Experts

Get Support in Our Knowledge Base

Ask Questions. Give Solutions