samstarkey
asked on
Database update via winsock control
Experts,
I am using the winsock control to connect a PDA to an Access database. This works by :-
The PDA sending the SQL command to the Winsock Server
The Winsock server then processes the command
The Winsock server then returns the records back to the PDA.
This process is working fine.
However I now need the ability to perform such functions as record set UPDATE / ADD NEW etc.
Does anyone have any ideas on how to accomplish this???
Example of sending the Records to the Client
Dim buff As String
Dim x As Integer
Dim iRecords As Long
Dim iFields As Integer
Rs.MoveFirst
While Not Rs.EOF
iFields = Rs.Fields.Count
For x = 0 To Rs.Fields.Count - 2
buff = buff & Rs.Fields(x).Value & "|"
Next x
buff = buff & Rs.Fields(x).Value & "|"
iRecords = iRecords + 1
Rs.MoveNext
Wend
Rs.Close
Set Rs = Nothing
buff = buff & "~"
Sbuff = "DATAOK" & Format(iRecords, "000000") & "," & Format(iFields, "0000") & "," & buff & "~"
I am using the winsock control to connect a PDA to an Access database. This works by :-
The PDA sending the SQL command to the Winsock Server
The Winsock server then processes the command
The Winsock server then returns the records back to the PDA.
This process is working fine.
However I now need the ability to perform such functions as record set UPDATE / ADD NEW etc.
Does anyone have any ideas on how to accomplish this???
Example of sending the Records to the Client
Dim buff As String
Dim x As Integer
Dim iRecords As Long
Dim iFields As Integer
Rs.MoveFirst
While Not Rs.EOF
iFields = Rs.Fields.Count
For x = 0 To Rs.Fields.Count - 2
buff = buff & Rs.Fields(x).Value & "|"
Next x
buff = buff & Rs.Fields(x).Value & "|"
iRecords = iRecords + 1
Rs.MoveNext
Wend
Rs.Close
Set Rs = Nothing
buff = buff & "~"
Sbuff = "DATAOK" & Format(iRecords, "000000") & "," & Format(iFields, "0000") & "," & buff & "~"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Didn't do my research very well. Standard SQL statements... I generally work by DAO and record sets so rarely dulge into core SQL
Thanks anyway, pointed me in the dircetion i needed