Mega Code Archive

 

Categories / Delphi / ADO Database

 

Heterojen sql kullanımı

//Delphi FAQs and TIs //Birden fazla Alias arasında da SQL yazılabilir. :) {The SQL syntax should be formatted as follows: a double quote, a colon, a real alias name, a colon, the table name, and a double quote. See example below. Leave the DatabaseName property of the TQuery blank, unless the alias is local. For example, specifying DBDEMOS in the Query's DatabaseName property will work, but using IBLOCAL will cause a general SQL error.} SELECT A.ITEMNO, B.VENDORNO FROM ":DBDEMOS:ITEMS" A, ":IBLOCAL:VENDORS" B WHERE A.VENDORNO = B.VENDORNO