S Stephenz43 Member Licensed User Longtime User Sep 24, 2013 #1 Hello I have a small app that reads data from a off site MS SQL 2008 Server. It works well. I would like to add a feature based on the following SQL statement : Select sum(ototal) from testdb where id = 500 In vb.net i would use cmd.executescalar . I'm a little confused in B4A. Could someone help? Again, I have a valid connection thru the internet to a ms sql server and am reading data.
Hello I have a small app that reads data from a off site MS SQL 2008 Server. It works well. I would like to add a feature based on the following SQL statement : Select sum(ototal) from testdb where id = 500 In vb.net i would use cmd.executescalar . I'm a little confused in B4A. Could someone help? Again, I have a valid connection thru the internet to a ms sql server and am reading data.
Erel B4X founder Staff member Licensed User Longtime User Sep 24, 2013 #2 How are you connecting to the database? ExecuteScalar is similar to a regular query execution. You just need to take the first column in the first row (record). Upvote 0
How are you connecting to the database? ExecuteScalar is similar to a regular query execution. You just need to take the first column in the first row (record).
