Link to home
Start Free TrialLog in
Avatar of samstarkey
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 & "~"
   
ASKER CERTIFIED SOLUTION
Avatar of TreyH
TreyH
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of samstarkey
samstarkey

ASKER

Thanks TreyH,

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