My problem is solved I used a view instead of SP.
Many thanks to all and for advises too and sorry for my many posts
The sample I posted is selecting from a view which join four tables no problem
I can call it directly without the SP. But my real problem is in another query
which is complex and that I could not build a simply view. I meet problem
when I build it in a only a view so I had to build firstly
On 6-1-2018 15:19, m_brahi...@yahoo.fr [firebird-support] wrote:
>
>
> Heres is a sample code of the SP
>
> BEGIN
> FOR SELECT O.ORDRE_ID, O.UNITE_ID, O.NUM_ORDRE, O.PREFIXE, O.DATE_ORDRE,
> O.MOTIF_ORDRE, O.STRUCTURE_ID, O.PROJET_ID, O.BESOIN_NECESSAIRE,
> O.COMMANDE_TRANSMISE, O.UTILISATEUR,
06.01.2018 15:19, m_brahi...@yahoo.fr [firebird-support] wrote:
> Heres is a sample code of the SP
There is no point in such SP. You'll get only bad performance and no
advantages.
--
WBR, SD.
Heres is a sample code of the SP
BEGIN
FOR SELECT O.ORDRE_ID, O.UNITE_ID, O.NUM_ORDRE, O.PREFIXE, O.DATE_ORDRE,
O.MOTIF_ORDRE, O.STRUCTURE_ID, O.PROJET_ID, O.BESOIN_NECESSAIRE,
O.COMMANDE_TRANSMISE, O.UTILISATEUR, O.LAST_UPDATE, O.INTITULE_UNITE,
O.INTITULE_STRUCTURE, O.NOM_PROJET,
On 6-1-2018 14:30, m_brahi...@yahoo.fr [firebird-support] wrote:
> Selecting fields of stored procedure build with FOR SELECT from a
> delphi app with where clause is not bad a a method ? Thanks
I think you need to illustrate this with a small example.
Mark
--
Mark Rotteveel
