Hi for all
Is there any way to do this once?, for example, I do it in Delphi:
INSERT INTO Table Select * field1,field2,....... from Table2
And in Reverse mode? Local->Server RDC?
Thanks and regards
B4X:
Sub JobDone(Job As HttpJob)
If Job.Success = False Then
Log("Error: " & Job.ErrorMessage)
Else
ToastMessageShow("Espere a que salga cartel FINALIZADO", True)
Dim i As Int
Dim t, s, ss As String
Dim n, z As Int
sql1.ExecNonQuery("DELETE From Instalacion")
lblOp.Text="Instalaciones Borradas"
If Job.JobName = "DBRequest" Then
Dim result As DBResult = reqManager.HandleJob(Job)
For Each records() As Object In result.Rows
i=records(0)
t=records(1)
n=records(2)
s=records(3)
z=records(4)
sql1.ExecNonQuery("INSERT INTO Instalacion (ID,Tipo,Numero,Situacion,Zona) VALUES('"&i&"','" & t & "','" & n & "','" & s & "','" & z & "')")
Log("Insertando tipo: "&t&" y número: "&n)
Next
'reqManager.PrintTable(result)
End If
End If
lblOp.Text="FINALIZADO"
Job.Release
End SubIs there any way to do this once?, for example, I do it in Delphi:
INSERT INTO Table Select * field1,field2,....... from Table2
And in Reverse mode? Local->Server RDC?
Thanks and regards