« Return to Thread: Transforming a query in variable and vice-versa

Transforming a query in variable and vice-versa

by Ranieri Oliveira :: Rate this Message:

Reply to Author | View in Thread

Hello guys...

When I'm developing a software, many times I need to transform a query in variable, so I do it by hand like below:

Query:
Select field1,
 field2,
 field3
from table1
where condition

Variable:
String myquery = "Select field1,"
+" field2,"
+" field3"
+" from table1"
+" where condition";

This process can be very boring when the query is very large, I want to know if someone have a trick to do this process more easy and fast or a way to avoid this process.

Thanks

 « Return to Thread: Transforming a query in variable and vice-versa