I am trying to pass a SQL to the DataEnvironment at run time
ysing the Command1_click event:

DataEnvironment1.Commands("orders").CommandText=_
SELECT account FROM orders WHERE account="12345";

And I get syntax error in FROM clause so I change tosee where the problem is to:
SELECT * FROM orders
And still get the same error what am I doing wrong?