How to create table names dynamically?

flying0718

This is wrong, how can I solve it? Thank you
procedure TForm3.Button2Click (Sender: TObject);
var
  tablename: string;
begin
    tablename: = formatdatetime ('yyyymd', strtodatetime (daystr));
    with ADOquery2 do
    begin
       close;
       sql.Clear;
       sql.Add ('select book number, sales quantity, sales unit price into' + tablename + 'from bookout');
       sql.Add ('where sales date =' + quotedstr (daystr));

yourapy

sql.Add('exec(select book number, sales quantity, sales unit price into'+tablename+' from bookout');
sql.Add('where sales date='''+quotedstr(daystr))+''')';


Your date, I quoted it for you, should be needed.

xiao8342

sql.Add('select book number, sales quantity, sales unit price into'+quotedstr(tablename)+' from bookout');
sql.Add('where sale date='+quotedstr(daystr));

That's right

abomination

What you wrote upstairs is right!
It's tablename. What do you put in quotation marks?


I didn’t see any problem with the sql written by the host, you can try to add a space before where to see, I use adodataset instead of adoquery


sql.Add('select book number, sales quantity, sales unit price into'+tablename+' from bookout');
sql.Add(' where sale date='+quotedstr(daystr));

abomination

It’s not the problem I said, please send your error message to see

abomination

Where did your daysr come from? Global variables?

flying0718

It is not wrong when using English letters for the table name, but it is wrong when using the date. What is wrong?

muchlore

ShowMessage takes a look at the actual statement to see if there are any errors. Such a simple question

endman

Try adding a space before where