0

Using a dbexpress component to connect to a mysql DB. If I want to commands like Insert, Delete and UPDATE I use a query. The question is How can I let the user Write the commands into a Richedit or Memo, what ever is the best. And then load those lines to the queries.sql lines?

Tried:
richeditSQL.Lines.Assign(mysqlQuery.SQL);
mysqlQuery.SQL.Assign(richeditSQL.Lines);

Not working.

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by finalist
0

Using a dbexpress component to connect to a mysql DB. If I want to commands like Insert, Delete and UPDATE I use a query. The question is How can I let the user Write the commands into a Richedit or Memo, what ever is the best. And then load those lines to the queries.sql lines?

Tried:
richeditSQL.Lines.Assign(mysqlQuery.SQL);
mysqlQuery.SQL.Assign(richeditSQL.Lines);

Not working.

May be:

mysqlQuery.SQL.Text := MemoSQL.Text;
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.