_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