VISOCO Software  Home | Products | Services | Download | Order | Support | Forum | Resources | Search | About
  RSS feedRSS Feed  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  RegisterRegister   ProfileProfile    Log inLog in 
load dblookupcombobox with a stored procedure

 
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE
Author Message
Ricardo Alfredo



Joined: 04 Apr 2004
Posts: 8

PostPosted: Thu Mar 03, 2005 10:51 pm    Post subject: load dblookupcombobox with a stored procedure Reply with quote

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
View user's profile Send private message
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Thu Mar 03, 2005 11:53 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
VISOCO Support
VISOCO Software Support


Joined: 16 Jul 2002
Posts: 96

PostPosted: Sat Mar 05, 2005 1:39 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    VISOCO Software Forum Index -> VISOCO dbExpress driver for Sybase ASE All times are GMT + 2 Hours
Page 1 of 1

 


©VISOCO Software. phpBB by phpBB Group