kaare_t

No problem, glad you got it working. As a side note: Something must be completely wrong with FW v1.046. The first thing I checked was if there was any changes for the EVAL regarding FW, but the manual states that all float instructions are available from the first FW version from Mitsu, so obviously something very strange going on with FW v1.046. Thank you for the update and solution!

I meant exactly what you are suggesting; FMOVP K0 D7900 K30... I looked through the manuals and I cannot find anything related to versioning regarding the EVAL instruction so basically you should be good to go. As mentioned, I don't have a FX5 where I am now, but if no one else can test it, I can get my hands on one this weekend I think. In the meantime, I noticed you are using double-quotes for the strings ("). Could you try using single-quotes (') instead? So instead of: $MOVP "123" D7900 use $MOVP '123' D7900 Also: Does the code run fine in simulation mode on your computer? Is it only after downloading to the PLC you are getting problems? Which version of GW3 are you running?

Are you sure you are clearing all the areas in the "from" field (D7900 ->)? And you are sure that nothing is overwriting anything in these areas? I don't have a CPU where I am now, but simulating it works fine. As a test, try to use pulse instructions only, to know that nothing is overwriting anything elsewhere (external comms?): FMOVP K0 D7900 K30 $MOVP "123" D7900 EVALP D7900 D7940 RST M721 Only run M721 and see. If it works doing the above, we know that something is modifying/adding data to D7900-D7929 somewhere causing the EVAL instruction to complain.

OK, so I've been giving this some thought, and I must say I'm a bit in the dark exactly what you want to achieve by getting the data "inline" like you describe. Maybe you could also describe what your "final goal" is, just to make my understanding better, and to shed some light on possible routes? I mean; the output you are referring to in the pictures is just the raw output right? In your report application you can organize and adjust where you want the data placed? What I'm trying to point out is that I'm pretty sure you want to do the UI logic in the View application instead of in the SQL query? Anyway, I've created a query you can use for your question, but please post more information if you can and we'll try to help you accomplish your goal in the "correct way. See code below, works for MS SQL Express server. You can copy-paste this code into your SQL Management Studio to be able to run the query if you want to test (you might have to adjust the DB names etc). -- Creates a temporary timestamp value (and sets it to NULL in my test) -> Set it to the correct value in your application query DECLARE @stamp AS DateTime SET @stamp = NULL; -- Creates a temporary table that we will use to insert into - note that these are the columns you want DECLARE @tmpTable AS TABLE ( ValDateTime datetime, Val1 float, Val2 float, Val3 float, Val4 float, Val5 float, Str1 nvarchar(82), Str2 nvarchar(82), Str3 nvarchar(82) ) -- Inserts into the temporary table INSERT INTO @tmpTable(ValDateTime, Val1, Val2, Val3, Val4, Val5, Str1, Str2, Str3) VALUES ((SELECT TOP (1) DateAndTime FROM FloatTable WHERE DateAndTime LIKE @stamp), (SELECT Val FROM FloatTable WHERE TagIndex = 1 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 2 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 3 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 4 AND DateAndTime LIKE @stamp), (SELECT Val From FloatTable WHERE TagIndex = 5 AND DateAndTime LIKE @stamp), (SELECT Val From StringTable WHERE TagIndex = 1 AND DateAndTime LIKE @stamp), (SELECT Val From StringTable WHERE TagIndex = 2 AND DateAndTime LIKE @stamp), (SELECT Val From StringTable WHERE TagIndex = 3 AND DateAndTime LIKE @stamp)) -- In the end, just use a SELECT * from the temp table to select all columns SELECT * FROM @tmpTable   Gives the following result (note that in my DB I only created the columns with NULL value in the datetime column. Top line is headers, and bottom line is data. ValDateTime Val1 Val2 Val3 Val4 Val5 Str1 Str2 Str3 NULL 1 2 3 4 5 String 1 String 2 String 3  

Understood! I will get back to you but I need to do some investigation first... I'll let you know.

Oh, sorry about that. I now see what the topic starter meant. Thanks @Inntele

Probably because the compiler generates temp vars to map data. In other words, the compiler makes use of variables to compile the code into IL for execution. The FB can be with, or without macrocode which indicates if it is placed inline or as a "subroutine". It's hard to explain your exact issue without seeing the code with and without modifications.

I see, so what you're saying is that you want to replace TagIndex with a name of some sort, to represent the device or the actual equipment? Then, you want to show them kind of "in-line" one after the other? So for example: TimeDate | Variable1 | Variable2 | Variable3 If that's the case, were closer to a solution. Could you also post how your tables are structured? I see you have a JOIN in your first post, so obviously you have at least two tables. Do you have more than those two (for this scenario), or is it just float/string tables each containing a correct datetime?

I'm not sure what you need help with here, would you please explain what it is you want to read out from your tables? I get that you have one table for string values and one table for float values, but instead of explaining what is not working, could you explain what you are trying to accomplish? Maybe that helps my understanding?

What does the error text say? Could you post a screenshot of the error message?

Answered here: http://forums.mrplc.com/index.php?/topic/34720-please-need-help/

Which software are you using? If you have the possibility to implement functionblocks then Mitsubishi already have these available for FX2N together with BD cards.

Yes, FX3G supports ModbusRTU using ADPRW.

The above codeline will, as explained in comment: Always move 211words from G10000+ into D2000+. So the problem here is that the local buffer in the EIP isn't cleared after it's read. You need to find a way (probably a bit in a BFM or something) that clears the input area of the EIP, AFTER you've successfully read the data. The sequence should be something like this: Scan bc Store bc in EIP Notify Q03 (can be done by a bit, or by looking at new data available) Transfer data from EIP to Q03 Clear EIP buffer area Ready for next data Alternatively, if speed is of essence and you want to avoid clearing the EIP buffer you can probably find a buffer in EIP that indicates the length in bytes that are currently received. Use that length variable instead of K211 in your BMOV instruction. Note that the variable is probably in 'byte' units so you'll have to do some calculations that way.

How are you controlling STF/STR signals? Are they digital? And also, you are sending an analog signal for the frequency setpoint, or are you using a potmeter? Please let us know your complete setup.

Already discussing this topic here: http://forums.mrplc.com/index.php?/topic/34407-mitsubhishi-serial-drivers/

It's almost impossible to help you with this little information. The Q06UDEH CPU doesn't have a serial port, so the nextgen2000 obviously doesn't convert the serial CPU-port protocol to Ethernet... Can you be more specific with what equipment you currently have, and also where everything is connected? What is your purpose of "installing the serial driver directly"? What is it that you want to do? What does the system do today?

Could you also take a screenshot of the 'Open' settings for the Ethernet card (where you assign IP/Port/Application to the appropriate connections for the Ethernet card (Network Parameter -> Ethernet / CC IE / MELSECNET -> Open Setting). Are you trying to use the same connection number for both send and receive data? The Ethernet card needs one connection number per send and/or receive. This essentially means that you need to e.g. use connection number 1 for receiving data, and connection number 2 for sending data. You also need to specify if you are actually sending or receiving data on a given connection number.

Already discussing this here: http://forums.mrplc.com/index.php?/topic/34314-gx-works-2/

I agree with @Ron_S, what is it that you want to accomplish with this?

Hey! C1A6 indicates that you're trying to open an incorrect 'connection number' in the Ethernet card (QJ71E71-100). It should be between 1-16 (ur 1-15 if you are using send/receive paired connection). Could you post some screenshots of your PLC code for easier debugging if the problem persists? P.S. In section 11.3 in the manual, there's an error code list where all the hex error codes are (like the one you posted).

You don't need to script...: Add a regular button Under "Actions", select "Show Users Dialog" (see attached picture) This will open a dialog with all the current users for editing, and you can also add new users to existing security groups.

I'm pretty sure you cannot use Domain integration with iX HMI's...

What do you mean by "Customized User Dialog"? Like a popup, or?

And how many pulses do you get per rotation now?