I am trying to execute SQL commands from VB6
...
strSQL = "SELECT Count([Stores].[StoreID]) AS iTotStore FROM Stores;"
rsStores.Open strSQL, dbConn
cmdSQL.CommandText = strSQL
cmdSQL.Execute
...
This command is executing ok but it is not assigning correctly to iTotStore variable.
What am I doing wrong here ???
Thanks
np3il
...
strSQL = "SELECT Count([Stores].[StoreID]) AS iTotStore FROM Stores;"
rsStores.Open strSQL, dbConn
cmdSQL.CommandText = strSQL
cmdSQL.Execute
...
This command is executing ok but it is not assigning correctly to iTotStore variable.
What am I doing wrong here ???
Thanks
np3il