You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old February 13th, 2018, 07:07 AM   #16
rahilansari
Member
India

rahilansari is offline
 
Join Date: Jul 2008
Location: INDIA
Posts: 101
Dear Sigmadelta,

When I use the command
USE mstw_db
DELETE from events

I am getting syntax error message. Also could you please tell me instead of writing query can I use empty table. I can see this option when I right click on events! Please advice
__________________
Rahil
  Reply With Quote
Old February 13th, 2018, 07:11 AM   #17
rahilansari
Member
India

rahilansari is offline
 
Join Date: Jul 2008
Location: INDIA
Posts: 101
I have copied and replaced my old events.myd file from my ghost backup too as you said in earlier comment.
__________________
Rahil
  Reply With Quote
Old February 13th, 2018, 07:15 AM   #18
rahilansari
Member
India

rahilansari is offline
 
Join Date: Jul 2008
Location: INDIA
Posts: 101
I have attached the error message that I got after writing the query.
Attached Images
File Type: jpg A3C1D748-59A8-46F1-9912-98D5A9F2B6A0.jpg (41.5 KB, 5 views)
__________________
Rahil
  Reply With Quote
Old February 13th, 2018, 08:36 AM   #19
sigmadelta
Member
Canada

sigmadelta is offline
 
Join Date: Apr 2016
Location: From Canada - Living in Bulgaria
Posts: 799
Place a semi-colon (;) at the end of each line.
__________________
Freelance Automation Programmer
  Reply With Quote
Old February 13th, 2018, 11:30 AM   #20
rahilansari
Member
India

rahilansari is offline
 
Join Date: Jul 2008
Location: INDIA
Posts: 101
After I copied the file, I repaired and refreshed the table and now my events started logging. But still I will try to perform a delete operation just to start the file from 0. Thanks a lot for your support����
__________________
Rahil
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Citect - MySql ysn6741 LIVE PLC Questions And Answers 0 February 7th, 2014 03:45 AM


All times are GMT -5. The time now is 12:53 AM.


.