_Field.ForeignKey (gb.mysql)
Sub ForeignKey ( Field As String, RefTable As String, RefField As String [ , OnDelete As String, OnUpdate As String ] )
Stores the information for a foreign key, later, that information will be used to create a table.
Field: Is the field to reference.
RefTable: Is the table we are referencing.
RefField: Is the field we are referencing.
OnDelete: Which action execute on delete.
OnUpdate: Which action execute on update.
When the table is created all the foreign key's information is cleaned.
Examples
Dim hCon As New Connection
With hCon
.Type = "mysql"
.Port = "3306"
.Host = "localhost"
.User = "root"
.Password = "mypass"
.Name = "Gambas"
.Open()
End With
hCon.MySQL.Field.ForeignKey("country_id", "country", "country_id", "RESTRICT", "CASCADE")
Part of the MySQL statement:
KEY `idx_fk_country_id` (`country_id`),
CONSTRAINT `city_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `country` (`country_id`) ON UPDATE CASCADE