TableName as parameter in query MSSQL

[castore]

How can i write in right manner this ?:

select * from :table
in D7 + MsSQL

I need to set tablename at runtime

thanks to all

 

[towerbase]

You cannot set the table name using the : technique because this is for accessing fields only.

You need to change the table name in the SQL statement. For example, if you wished to change the table name in a TQuery:

var
  tablename: string;
...
  tablename := 'MENSA';
...
  Query.Close;
  Query.SQL.Text := Format( 'SELECT * FROM %s', [tablename] );
  Query.Open;

Sometimes the requirement to change the table name at runtime indicates that the database design requires normalisation.

Andrew
Hampshire, UK

 

[castore]

Thanks Andrew