Sign in to follow this  
Followers 0
moamed

delete data from sql using vijeo citec

1 post in this topic

Hello
I tray to get way to delete data from table in SQL using Vijeo Citec v7.4

I write this Cicode but i didn't work
any help please

{{

FUNCTION Report_delete ()

INT hSQL;
INT dSQL;


hSQL = SQLConnect("DSN=Abdelwahed");

dSQL="DELETE FROM June WHERE date = 'Thursday, June 16, 2016'" ;

SQLBeginTran(hSQL);

SQLExec(hSQL,dSQL);



END


}}

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0