_View.Modify (gb.mysql)

Sub Modify ( View As String, Statement As String )

Modifie la vue spécifiée.

View: Est le nom de la vue.
Statement: Est la requête pour modifier la vue.

Exemples

Dim hCon As New Connection

With hCon
  .Type = "mysql"
  .Port = "3306"
  .Host = "localhost"
  .User = "root"
  .Password = "mypass"
  .Name = "Gambas"
  .Open()
End With

hCon.MySQL.View.Modify("view_actor", "SELECT first_name, last_name FROM actor")

MySQL statement: CREATE OR REPLACE VIEW `view_actor` AS SELECT first_name, last_name FROM actor