Pls help with add, edit, delete using LCSvrScrips/vServer

[Ruslan Zasukhin]

On 3/21/12 2:08 AM, "Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

Hi Barry,

> I'm trying to build scripts that will allow my Android to update a vDBServer
> using LC Server Side Scripting.
> 
> I've successfully tested GET and POST HTTP submits from a LC Android project
> to my LC Scripting Server.
> It's just a quick n dirty Username and Password confimation script:
> http://forums.runrev.com/viewtopic.php?f=15&t=11377#p53537
> 
> And I think i've successfully tested v4Rev from LC Server Side Scripting.
> 
> Now I'd like to POST a Username, Lat, Lng to update the vDBServer.
> something like:
> username=Barry&Lat=1234.123&lng=789.1


> Has anyone got a working script or scripts to get me started?
> i.e. to Add a record, to update a record, to delete a record, and to search
> for and return records.

You want just add record??

Okay so you have connect from RevServer to VSERVER. Yes?

And you have open some db?
    then  you have on hands dbRef of that db

Next just do SQL like with any other db

    Valentina_SqlExecute(
            dbRef, 
            "INSERT INTO T(f1,f2,f3) VALUES( 'Barry', 123, 789 )" )


 
> I don't know where to start on the simplest most direct way of how to
> structure/group the scripts.
> i.e. either in a single script or multiple scripts, etc?
> 
> Or perhaps a single stack to use in the LC Server Side Scripting?
> hmmmmm
> 
> tia
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
> 

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]