| View previous topic :: View next topic |
| Author |
Message |
Sorin Guest
|
Posted: Tue Mar 20, 2007 9:53 pm Post subject: Sql view with parameters |
|
|
I want to use the bde local sql view emulation
so i save the TQuery sql statement on txt file and the call it
select * from "saved.sql"
The problem occurred when the saved sql has parameters
Is there a way to assign a value to this parameters?
Thanks sorin |
|
| Back to top |
|
 |
Bill Todd Guest
|
Posted: Wed Mar 21, 2007 8:11 am Post subject: Re: Sql view with parameters |
|
|
Sorin wrote:
| Quote: | Is there a way to assign a value to this parameters?
|
No.
--
Bill Todd (TeamB) |
|
| Back to top |
|
 |
Leslie Milburn Guest
|
Posted: Thu Mar 22, 2007 4:22 pm Post subject: Re: Sql view with parameters |
|
|
"Sorin" <sorinh (AT) zahav (DOT) net.il> wrote in message
news:46001112 (AT) newsgroups (DOT) borland.com...
| Quote: | I want to use the bde local sql view emulation
so i save the TQuery sql statement on txt file and the call it
select * from "saved.sql"
The problem occurred when the saved sql has parameters
Is there a way to assign a value to this parameters?
Thanks sorin
|
Hi Sorin,
You would have to parse the text file yourself and textually substitute for
the parameter value.
Leslie. |
|
| Back to top |
|
 |
|