Android Question JRDC: delete record server side

marcick

Well-Known Member
Licensed User
Longtime User
Hi everybody and happy new year.

I need to implement some code in JRDC (server side, not client) to do a simple manteinance operation on the database

For example: "DELETE FROM mytable WHERE sdate<"2015-05-01 12:00:00"

No difficult to do it creating the command in config.properties and doing the operation client side, but I need to do it server side in JRDC.
I'm tryng to understand the code but have some difficulties...
Any hints ?


... solved ! what a stupid question, it was so easy ...
 
Last edited:

marcick

Well-Known Member
Licensed User
Longtime User
yep ...

B4X:
    DIM rdcConnector1 As RDCConnector
rdcConnector1.initialize
Dim con As SQL = rdcConnector1.GetConnection
con.ExecNonQuery("DELETE FROM mytable WHERE sdate < " & Chr(34) & "2015-05-01 12:00:00" & Chr(34))
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…