0 Replies - 487 Views - Last Post: 05 October 2013 - 10:54 AM Rate Topic: -----

#1 kiad_198  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 128
  • Joined: 19-November 08

Received SMS using GSM Modem and insert into database?

Posted 05 October 2013 - 10:54 AM

Hi Guys,

How can I insert into database the all inbox messages in GSM Modem? I am using Wavecom Fastrack GSM Modem.

Here's my code of display received messages:
Dim buffer
If MSComm1.PortOpen = True Then MSComm1.PortOpen = False
With MSComm1
.CommPort = 1
.Settings = "9600,N,8,1"
.InputLen = 0
.Handshaking = comNone
.PortOpen = True
End With
MSComm1.Output = "AT" & vbCrLf
Do
DoEvents
buffer = MSComm1.Input
Loop Until InStr(buffer, "OK")
buffer = ""
MSComm1.Output = "AT+CMGF=1" & vbCrLf
Do
DoEvents
buffer = MSComm1.Input
Loop Until InStr(buffer, "OK")
buffer = ""
MSComm1.Output = "AT+CMGL=" & Chr(34) & "ALL" & Chr(34) & vbCrLf
Do
DoEvents
buffer = buffer & MSComm1.Input
Loop Until InStr(buffer, "OK")
Text2.Text = buffer



Instead of displaying that data in that code. I want to insert that data into database.
How can I do that?
Also after inserting that data in database, how can I delete the messages in inbox?
Any idea guys!


Thanks guys,

This post has been edited by kiad_198: 05 October 2013 - 10:57 AM


Is This A Good Question/Topic? 0
  • +

Page 1 of 1