# how to get info from DbConn.SQLExecute(SqlStr)

**URL:** <https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139>\
**Category:** Databases\
**Created:** [April 7, 2020, 5:07pm UTC](https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139 "2020-04-07T17:07:19Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alexis\_Colon\_Lugo](https://forum.xojo.com/user_avatar/forum.xojo.com/alexis_colon_lugo/32/572_2.png) [@Alexis\_Colon\_Lugo](https://forum.xojo.com/u/Alexis_Colon_Lugo)\
**Post date:** [April 7, 2020, 5:07pm UTC](https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139/1 "2020-04-07T17:07:19Z")

</div>

My Code  
Dim SqlStr As String

SqlStr=“Delete From Clientes Where ID=’” + TxtID.text.trim + "’ and balance=0 "  
Session.DbConn.SQLExecute(SqlStr)  
if Session.DbConn.Error Then  
MsgBox " \*\*\* Error on Add Customer \*\* " + Session.DbConn.ErrorMessage  
end if

how i can get how many rows affect when run delete

---

<div class="post-metadata">

**Author:** ![Hector\_Marroquin](https://forum.xojo.com/letter_avatar_proxy/v4/letter/h/cdc98d/32.png) [@Hector\_Marroquin](https://forum.xojo.com/u/Hector_Marroquin)\
**Post date:** [April 7, 2020, 5:36pm UTC](https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139/2 "2020-04-07T17:36:09Z")

</div>

What DB? In MySQL and Maria I believe there is a Row\_Count function you can query

---

<div class="post-metadata">

**Author:** ![Alexis\_Colon\_Lugo](https://forum.xojo.com/user_avatar/forum.xojo.com/alexis_colon_lugo/32/572_2.png) [@Alexis\_Colon\_Lugo](https://forum.xojo.com/u/Alexis_Colon_Lugo)\
**Post date:** [April 7, 2020, 7:20pm UTC](https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139/3 "2020-04-07T19:20:46Z")

</div>

SQLITE

---

<div class="post-metadata">

**Author:** ![Hector\_Marroquin](https://forum.xojo.com/letter_avatar_proxy/v4/letter/h/cdc98d/32.png) [@Hector\_Marroquin](https://forum.xojo.com/u/Hector_Marroquin)\
**Post date:** [April 7, 2020, 7:33pm UTC](https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139/4 "2020-04-07T19:33:21Z")

</div>

SELECT CHANGES() ;

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [April 29, 2021, 4:20pm UTC](https://forum.xojo.com/t/how-to-get-info-from-dbconn-sqlexecute-sqlstr/53139/5 "2021-04-29T16:20:59Z")

</div>