Hi,
I need to develop a script to automatically record signal strength information into a Pocket Access table on my iPaq.
I created a table using the following SQL command :
sqlcmd = "CREATE TABLE siteSurvey (position int, MAC1_signal Integer, MAC1_noise int)"
As you can see, the MAC1_signal column is of type Integer and MAC1_noise is of type int. Now, I'm trying to insert a row into this table through the following script..
Sub OnScanResult(SSID, BSSID, CapFlags, Signal, Noise, LastSeen)
rs.Open "INSERT into siteSurvey (position, MAC1_signal, MAC1_noise) VALUES (1,Signal,Noise)"
End Sub
But for both fields I get the error, "A literal value in the command could not be converted to the correct type due to a reason other than data overflow SCode : 80040E07"
I understand the Signal and Noise fields in the OnScanResult Sub are integer values. What could the reason for the error be?
Is there a better way to populate the table with Signal strength info?
Thanks,
Shikha