| Author |
Message |
Ricardo Alfredo
Joined: 04 Apr 2004 Posts: 8
|
Posted: Thu Mar 03, 2005 10:51 pm Post subject: load dblookupcombobox with a stored procedure |
|
|
as I can execute a stored procedure that recovers result Seth. try to execute from a TSqlQuery happening parametro, but profit not to call it the instruction that
I put is "select * from tel_datos_trabajador (:ficha)"
tel_datos_trabajador is a stored procedure that recovers several rows to load one dblookupcombobox |
|
| Back to top |
|
 |
VISOCO Support VISOCO Software Support
Joined: 16 Jul 2002 Posts: 96
|
Posted: Thu Mar 03, 2005 11:53 pm Post subject: |
|
|
Hi,
do you want to build the query dynamically?
If you want to pass the part of the query as a string parameter and generate a query like
| Code: | | select * from tel_datos_trabajador where ... order by ... |
you have to search for another solution - it will not work. |
|
| Back to top |
|
 |
VISOCO Support VISOCO Software Support
Joined: 16 Jul 2002 Posts: 96
|
Posted: Sat Mar 05, 2005 1:39 am Post subject: |
|
|
We are sorry,
we didn't understand you exactly first time.
You have to use TSQLStoredProc to open the resultset that stored procedure returns. (use Open method)
Select from stored procedure isn't a correct query. |
|
| Back to top |
|
 |
|