A form in my vb.net program needs to know if the LocInv table has any records. I have been using this code:
sSQL = "SELECT COUNT(*) FROM LocInv" 'check to see if this file is in use...
sSQLresult = RunSQL_Select(sSQL, True)
If Val(sSQLresult) > 0 Then
pbC1_UseInv = True
pbC1_UseInv = False
The problem is that LocInv has almost 100,000 records, and that is taking a few seconds to 'count' on my (slow) portable device. So I need to know if there is an easy way to code this to more quickly determine whether or not the LocInv table has any records in it--without having to do a 'count' command. Note that this is the compact framework environment, meaning I have a limited number of commands available to me. TIA