dynamic sql via code

G

Gianluca_Venezia

I'm trying to develop a thing, even if I don't know exactly for what I
need it; however I'm sure that it's an useful code.

I want to realize a routine that make dinamically a query: starting
from some table and field, I want to realize a "right" query to
visualize datas.

Two are the teoric most difficult:
- table relationship
- bidirectionally of process

Stating that I'd want to make this on MS-SQL and on MY-SQL, even of in
MS-ACCESS, I need to know:
- there are tools that do this
- there are pratical obstacle that I don't know now
- is there in MSA a realationship object to use (and is there in other
like MYSQL or MSSQL)

Thanks
Gianluca
 
Top