In that case, show me your code and also change the above example to reflect your case. In the example the Embedded SQL is ->
Macro=SQL0:SELECT OrderID,OrderDate,RequiredDate,ShippedDate from orders where customerID= '#1#'
what is your SQL looks like.
Fk