Hi John, Thanks for your reply... But I would like to create this in a AR Sytem Form... (like Alert Events, AR System Email Messages) Could I create new Fields in these kind of forms without any worry about modify AR System Forms??? Att, Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I.
________________________________ De: Action Request System discussion list(ARSList) em nome de john rosquist Enviada: seg 7/4/2008 11:24 Para: arslist@ARSLIST.ORG Assunto: Re: How to know when a table is full ?? ** On a test form create a filter or esc. select form name firing conditions ... if action->set fields->Read value->direct SQL "select count(*) from t..." Name "field to put the result into" <- SQL result col "1" Good luck, John Rosquist Windward ----- Original Message ---- From: Tadeu Augusto Dutra Pinto <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, April 3, 2008 2:00:46 PM Subject: How to know when a table is full ?? ** Hi All. How could I execute a command to get the quantity of records in a table? Our test environment has not license ... and because of this we have a limit of 2k records for each table... I'd like to know when my table is full (i.e. if there is with 2k records).... Is there some way for me obtain this feature through an workflow object (Filter , AL , etc...) ??? P.S.: I've thought in to execute a Direct SQL command ... but this action doesn't return nothing... Can somebody help me? Thankx-in-advance! Tadeu Augusto Dutra Pinto ----------------------------------------------------------------- IT Web Services ATM Cinq Technologies http://www.cinq.com.br <https://webmail.cinq.com.br/exchweb/bin/redir.asp?URL=http://www.cinq.com.br/> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing ----------------------------------------------------------------- Confiabilidade, Inovação e Qualidade em T.I. __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ ________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access <http://us.rd.yahoo.com/evt=47523/*http://tc.deals.yahoo.com/tc/blockbuster/text5.com> , No Cost. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"