SQL Visual Basic

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;"