SQL Visual Basic
Microsoft Visual Basic
An example of an combined Update and Join SQL statement is
UPDATE project,tasks
SET project.projectstatus ='tests'
WHERE tasks.duedate< date() and tasks.actualdate =NULL;
It can also be executed programatically
On Error Resume Next
Set mydb = DBEngine.Workspaces(0).OpenDatabase(MDIForm1.currentdatabase)
mydb.Execute "Update project, tasks SET project.projectstatus ='tesyytsgfgf'" & _
"WHERE tasks.duedate< date() and tasks.actualdate =NULL AND project.projectid=tasks.projectid;"
Referenced By
Informix 4GL/SQL | SQL keywords | SQL language | SQL programming language | Structured Query Language
|
