How to set relation for MySql?

[dutch]

Dear All,

I try to work with TMySql but I cannot find "How to set Relation" between 2 related file.

How much difference between ::Query() and ::Seek()?

Regards,
Dutch

[lucasdebeltran]

Hello,

You can try:


SELECT * FROM Address, Customer WHERE Address.Id = Customer.Id


where Id is the relation field. Then you can use

oRs:Fields( "Name" ):Value

[wmormar]

dutch,

The relationships are given in the tables directly access eg

SELECT a.venta, a.cliente, a.fecha, b.nombrecliente FROM sales AS a INNER JOIN customer AS b ON b.clave = a.cliente

The :: Seek method is used to find information in the table and the row can regbresarte found or a value true or false, meanwhile :: Query you table extracts information such as set an example query above.

[dutch]

Dear William and Lucas,

Thanks for your kind help, I get an idea now.