Fredrix

MrPLC Member
  • Content count

    138
  • Joined

  • Last visited

Everything posted by Fredrix

  1. Is there any way to connect to another IP adress when the HMI is online? (I have to identical PLCs, and I want to switch between them in online mode)
  2. ask for a instruction in citect

    Are you sure this is a CitectSCADA function and not a custom function in your project? Which version of CitectSCADA are you running?
  3. popup page in citect

    How do you open the popup? If you use the cicode function WinNewAt you can open the popup either as a normal page (mode 0) or a child window (mode 2). In both cases the popup will stay open.
  4. I use SqlAppend, just as described in the KnowledgeBase (Q3773) SQLSet(hSQL, "SELECT *") SQLAppend(hSQL, " FROM EMP"); SQLAppend(hSQL, " ORDER BY last_name"); SQLExec(hSQL, "");
  5. First you must configure the database and add the required tables and users, you may use HeidiSQL to do this: http://www.heidisql.com/ Let me know if you need help with the initial setup of the server/database. Then you must download and install the MySQL ODBC Connector: http://dev.mysql.com/downloads/connector/odbc/ The ODBC configuration is usually located in Administrative Tools in Control Panel, you may find various examples here: http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-examples.html I may post a screenshot of my ODBC setup tomorrow In Citect we then use SQLConnect and SQLExec to interact with the database, I can post some examples when I get back to work tomorrow
  6. If you use the MySQL ODBC driver, communication with Citect should be just as easy as writing to a DBF... Let me know if you need any more help, I've just finished a project with Citect and MySQL myself
  7. You can use MySQL - it's free, and it works!
  8. SCADA: VB.NET solution

    Where do you get this from? K&R never developed C, they wrote a book about it (and maybe did some tweaking of the syntax)! C was developed by AT&T for UNIX and later implemented as a standard by ANSI. I will agree that it's a more difficult language to use, but no other language is as powerful as C/C++. But I don't personally use C/C++, I primarily use C# and PHP VB6 is officially dead, Microsoft ended the extended support period in March 2008 and the designated successor was Visual Basic .NET. That should be enough for anyone to stop using VB6 to develop new applications, as I mentioned earlier - it doesn't even work on new computers! And then of course you have all the limitations, how do you make a VB6 application multi-threaded? You can't... But you still haven't answered my question, what do you use it for?
  9. SCADA: VB.NET solution

    Well, C/C++ is actually the only language you can use to develop anything, for any platform (almost)... I really can't understand how you can find .NET more cumbersome than VB6, what do you use it for?
  10. Citect Word>PDF

    You might use CtAPI to read variable data from Citect in VBA, VB or C#, would that help you?
  11. SCADA: VB.NET solution

    Have you actually tried developing on the .NET platform? Firstly, it's not only for web applications - it works perfectly for desktop applications as well. You also won't need any license for any of the .NET platforms, you may even get the IDE for free! (Express edition) VB is practically dead, it doesn't even work on Windows Vista (without messing with the registry and adding old system files, if you can find them)! If the development time increases from 1 week to 6 months by moving forward and choosing the newest technology - then you really should find something else to work with... (VB.NET is not that far away from VB6) After I moved from VB6 to C#.NET 3.5 both my productivity and knowledge increased - fast! I would like to know which IDE you use for VB, because if you think the interface is better than for .NET - you have to be using something else than me!
  12. SCADA: VB.NET solution

    VBA is still included in Office because .NET never was meant to replace VBA, it was meant to replace VB and C++... However, more and more software projects utilizing VBA is looking to replace it with .NET. Eg. the developers of CitectSCADA are looking into replacing VBA with VB.NET or C#.NET in V.8...
  13. Citect and Cicode

    It would be easier to help you if you post some code :) How do you write to the tag? TagWrite?
  14. I have a major problem with CX-Programmer, when I try to transfer a program (both upload and download) CX-Programmer wont let me choose what to download (I have to go with the defaults). This makes it impossible for me to upload the entire program from the PLC to the PC, it also makes it impossible to download for example only the settings. Anyone experienced this before? I need to get this fixed as soon as possible, and appreciate any help I can get from you! My CX-Programmer version is 7.11
  15. Citect,Cicode Forms,

    Did a small test here, and it worked very nice
  16. Citect,Cicode Forms,

    Hi, It looks to me like hForm is a global variable, that's why it only works for the last form If you do like this instead, it should work: INT FUNCTION StopShip() INT hCurrForm, hCurrField; FormCurr(hCurrForm, hCurrField); FormDestroy(hCurrForm); Alarm_Control_Reg_S =CurrentFb BITOR 0x04; RETURN 0; END
  17. I’m currently in the planning phase of a project involving extraction of data from various Omron files. I need to read the values of PLC memory areas from .mem files, Backup Tool and Memory Card. I have found and understood the structure of .mem files, so that should be easy, and Backup Tool saves all memory areas in a .mem file. But I have not been able to interpret any data from the memory card. I suspect that the .IOM files on the memory card contain IO Memory data, does anyone know if that is correct? And if not, where do I find the IO Memory Area? And most important, how can I interpret data saved in this files?
  18. PROBLEM WITH CITECT SOUND

    Citect complains about the sleep() function, sleep() is a blocking cicode function, which means it blocks everything else in the same thread until it's finished. Running blocking functions in forground task (the task that shows you graphics) are not allowed of obvious reasons (would lock up graphics). This is also a very bad way to do this, how do you plan to stop the sound? This will loop forever once it's started, and making infinite-loops are not a good idea! If you need the sleep you should make a wrapper function, and use TaskNew() to call this function, also you should make some code to detect when the alarm goes back to normal, so you can stop the sound again
  19. Need help with Citect super genie

    Why do you have "TAG" in front of the tag names comming from the genie? Maybe this is what's causing your problems Try AssVarTags(-2,0,STSP,LR);
  20. I have a project where I want to make a Visual Basic application to communicate (read/write I/O) with a Omron CJ1M CPU11-ETN Are there any easy ways to do this without the use of OPC-servers or CX-Server? The computer is connected to the PLC's Ethernet port
  21. What does CX stand for?

    What does CX in CX-One stand for?
  22. What does CX stand for?

    What does it mean? Why CX?
  23. Controlling Ethernet I/P Datalinks

    I have multiple links configured, and I want a way to turn some of them on/off from the PLC program - anyone done this before? Is it possible? I'm using a CJ2H PLC with built-in EIP
  24. Controlling Ethernet I/P Datalinks

    I have three PLCs, two of them should have a link between them going all the time The third PLC should recieve data from both of the other PLCs, but only one at a time I can't turn off all the datalinks, are there any other ways to control the link? Maybe by using Explicit Messaging?
  25. CJ2H USB Drivers

    Can someone please tell me where I can find USB drivers for the CJ2H CPU ? I've tried to search at the Omron page, but couldn't find anything