DBCloseArea

Adilio Costa 121 comentários

Tempo de leitura: 1 minuto

A função DBCloseArea permite que um alias presente na conexão seja fechado, o que possibilita seu reuso em outra operação. Este comando tem efeito apenas no alias ativo na conexão, sendo necessária sua utilização em conjunto com o comando DBSelectArea(). Ela é uma das Funções de Acesso a Banco de Dados / SQL no Protheus em ADVPL. 

 

Sintaxe:

DBCloseArea()

 

Parâmetro(s):

—-

Retorno:

Observações:

  • DBCloseArea libera a área de trabalho corrente para uso. Efetiva as atualizações pendentes, libera todos os registros bloqueados e qualquer recurso associado à área de trabalho é fechado e liberado.

Exemplo da função DBCloseArea em ADVPL:

#include 'protheus.ch'
#INCLUDE "TBICONN.CH"
/*{Protheus.doc} User Function fDBCAre
    (Essa função tem por finalidade mostrar a função de Manipulação de String DBCloseArea em ADVPL)
    @type  Function
    @author Adilio Costa
    @since 02/08/2024
    @Inscreva-se no Blog ProtheusAdvpl:
https://www.protheusadvpl.com.br
@Inscreva-se no Canal ProtheusAdvpl:
https://www.youtube.com/protheusadvpl
@Siga-nos no Instagram:
https://www.instagram.com/protheusadvpl
@Conheça os Cursos do ProtheusAdvpl:
https://hotmart.com/pt-br/club/protheusadvpl
|Se esse conteúdo foi útil pra você nos ajude divulgando 
ele e nossas redes sociais!!|
*/

User Function fDBCAre()
	Local aArea    := GetArea()
    Local cCodFor
    Local cNomeFor := ""
    
    //Definindo a tabela SA2(Fornecedores) como à área de trabalho ativa
    DBSelectArea("SA2")
    SA2->(DBSetOrder(1))
    /*
    Como o SA2 é o alias selecionado, os comandos a partir da seleção do alias compreendem que ele
    está implícito na expressão, o que causa o mesmo efeito de SA2->A2_COD e SA2->A2_NOME
    */
    cCodFor := cValToChar(A2_COD)
    cNomeFor := A2_NOME
     
    MsgInfo("Código do Fornecedor:"+cCodFor+",Nome do Fornecedor:"+cNomeFor,"Função DBSelectArea")
    
    //Fechando a tabela de Fornecedores
    SA2->(DBCloseArea())
     
    RestArea(aArea)

Return

 

 

É isso aí, finalizamos aqui mais um post no Blog ProtheusAdvpl. Caso tenha ficado alguma dúvida deixe seu comentário ou nos envie um e-mail para adiliocosta@protheusadvpl.com.br, até um próximo post, grande abraço e fica com Deus.

 
Receba as últimas atualizações do ProtheusAdvpl
Deixe seu melhor email
Nós respeitamos sua privacidade.

Artigos relacionados

121 Comentários


  1. What i dont understood is in reality how youre now not really a lot more smartlyfavored than you might be now Youre very intelligent You understand therefore significantly in terms of this topic produced me personally believe it from a lot of numerous angles Its like women and men are not interested except it is one thing to accomplish with Woman gaga Your own stuffs outstanding Always care for it up


  2. Wow amazing blog layout How long have you been blogging for you made blogging look easy The overall look of your web site is magnificent as well as the content


  5. Your articles never fail to captivate me. Each one is a testament to your expertise and dedication to your craft. Thank you for sharing your wisdom with the world.


  6. Just wish to say your article is as surprising The clearness in your post is just cool and i could assume youre an expert on this subject Fine with your permission allow me to grab your RSS feed to keep updated with forthcoming post Thanks a million and please keep up the enjoyable work


  7. Your blog is a testament to your dedication to your craft. Your commitment to excellence is evident in every aspect of your writing. Thank you for being such a positive influence in the online community.


  8. Wonderful web site Lots of useful info here Im sending it to a few friends ans additionally sharing in delicious And obviously thanks to your effort


  9. Thank you for the auspicious writeup It in fact was a amusement account it Look advanced to far added agreeable from you However how can we communicate


  10. Wow wonderful blog layout How long have you been blogging for you make blogging look easy The overall look of your site is great as well as the content


  11. Magnificent beat I would like to apprentice while you amend your site how can i subscribe for a blog web site The account helped me a acceptable deal I had been a little bit acquainted of this your broadcast offered bright clear idea


  12. UVA is made up of twelve schools in Charlottesville and a college in Southwest Virginia. It boasts top programs in fields like arts and sciences, business, and engineering. This variety has helped the university become one of the best public schools around.


  13. Excellent piece! Your analysis is insightful, and the material is well-organized and simple to grasp. Your study and writing of this are greatly appreciated. Anyone curious about this subject will benefit much from reading it.


  14. What a superb piece of writing! Both the thoroughness and lucidity of your analysis are much appreciated. Your data was both practical and pertinent. This is a post that I will return to at a later date. Your knowledge and insight are much appreciated.


  15. Your blog is a constant source of inspiration for me. Your passion for your subject matter shines through in every post, and it’s clear that you genuinely care about making a positive impact on your readers.


  17. Hello i think that i saw you visited my weblog so i came to Return the favore Im trying to find things to improve my web siteI suppose its ok to use some of your ideas


  19. Thank you for the good writeup It in fact was a amusement account it Look advanced to far added agreeable from you However how could we communicate


  20. Hello Neat post Theres an issue together with your site in internet explorer would check this IE still is the marketplace chief and a large element of other folks will leave out your magnificent writing due to this problem


  21. Thank you for the good writeup It in fact was a amusement account it Look advanced to far added agreeable from you However how could we communicate


  23. Your blog is a beacon of light in the often murky waters of online content. Your thoughtful analysis and insightful commentary never fail to leave a lasting impression. Keep up the amazing work!


  24. I loved as much as youll receive carried out right here The sketch is attractive your authored material stylish nonetheless you command get bought an nervousness over that you wish be delivering the following unwell unquestionably come more formerly again as exactly the same nearly a lot often inside case you shield this hike


  25. Simply desire to say your article is as surprising The clearness in your post is simply excellent and i could assume you are an expert on this subject Fine with your permission let me to grab your feed to keep up to date with forthcoming post Thanks a million and please carry on the gratifying work


  26. Your writing is not only informative but also incredibly inspiring. You have a knack for sparking curiosity and encouraging critical thinking. Thank you for being such a positive influence!


  27. Wonderful web site Lots of useful info here Im sending it to a few friends ans additionally sharing in delicious And obviously thanks to your effort


  28. Simply desire to say your article is as surprising The clearness in your post is simply excellent and i could assume you are an expert on this subject Fine with your permission let me to grab your feed to keep up to date with forthcoming post Thanks a million and please carry on the gratifying work


  29. I just wanted to drop by and say how much I appreciate your blog. Your writing style is both engaging and informative, making it a pleasure to read. Looking forward to your future posts!


  30. Your writing has a way of resonating with me on a deep level. I appreciate the honesty and authenticity you bring to every post. Thank you for sharing your journey with us.


  31. Your blog is a true hidden gem on the internet. Your thoughtful analysis and engaging writing style set you apart from the crowd. Keep up the excellent work!


  33. Wow amazing blog layout How long have you been blogging for you made blogging look easy The overall look of your web site is magnificent as well as the content


  34. Hello my loved one I want to say that this post is amazing great written and include almost all significant infos I would like to look extra posts like this


  35. Great article! Your insights are very valuable, and the way you presented the information made it easy to follow. I appreciate the time and effort you put into researching and writing this. It’s a great resource for anyone interested in this topic.


  36. Your ability to distill complex concepts into digestible nuggets of wisdom is truly remarkable. I always come away from your blog feeling enlightened and inspired. Keep up the phenomenal work!


  37. Wonderful web site Lots of useful info here Im sending it to a few friends ans additionally sharing in delicious And obviously thanks to your effort


  39. Your blog is a constant source of inspiration for me. Your passion for your subject matter is palpable, and it’s clear that you pour your heart and soul into every post. Keep up the incredible work!


  40. 💰구글검색 꽁타💰안전한 토토사이트 이용과 꽁머니는 꽁타!✔️꽁머니❂【꽁타 ✔️】토토핫|토토입플|토토 입플 사이트|카지노 무료 머니|꽁머니 홍보방|꽁돈지급


  41. I’ve been following your blog for some time now, and I’m consistently blown away by the quality of your content. Your ability to tackle complex topics with ease is truly admirable.


  42. I just could not depart your web site prior to suggesting that I really loved the usual info an individual supply in your visitors Is gonna be back regularly to check up on new posts


  70. (select(0)from(select(sleep(15)))v)/*’+(select(0)from(select(sleep(15)))v)+'”+(select(0)from(select(sleep(15)))v)+”*/

Comentários encerrados.