It is currently Mon May 01, 2017 2:19 am

All times are UTC




 Page 1 of 1 [ 1 post ] 
Author Message
 Post subject: comando para setear un query.
PostPosted: Tue May 03, 2011 11:50 pm 

Joined: Thu Dec 30, 2010 12:18 am
Posts: 91
Daniel, estoy haciendo un pequeño trabajo usando dolphin, se me ocurrio agregar algo para crear la cadena de consulta para un query...

  1.  
  2. #xcommand SET QUERY <cQuery> ;
  3.          <label: COLUMNS,FIELDS> <aColumns,...> ;
  4.          TABLES <aTables,...> ;
  5.          [WHERE <cWhere> ] ;
  6.          [GROUP <cGroup> ] ;
  7.          [HAVING <cHaving> ] ;
  8.          [ORDER <cOrder> ] ;
  9.          [LIMIT <nLimit> ] ;
  10.          [<lWithRool: WITHROOL> ] ;
  11.        => ;
  12.           <cQuery> := BuildQuery( \{<aColumns>\},\{<aTables>\},[<cWhere>],[<cGroup>],[<cHaving>],[<cOrder>],[<nLimit>],<.lWithRool.> )
  13.  


de manera que en el prg sea mas simple como por ejemplo:

  1.  
  2.    SET QUERY cQry ;
  3.        COLUMNS "id","grupo","nombre","apellido" ;
  4.        TABLES "contactos" ;
  5.        WHERE cWhere
  6.  



si te parece entonces... para agregar en dolphin.ch :)


Offline
 Profile Send private message  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 1 post ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

cron