Member Avatar for Singlem

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
  • 144 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by finalist
Member Avatar for finalist

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;
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.