[Gambas-user] Send data back to SQLite3 Table??

[Fabien Bodard]

+qLe 3 sept. 2012 05:53, "rocko" <sunblaster5 at ...626...> a écrit :
>
> After retrieving data and modifying it , I need to send it back to the
> table.
> I am tried the following:
>

sResult = DB.Edit("inventory", id = &1, ID)

>              $date1 = sResult!endDate
>              $date2 = Now
>              Print $date2 'debuging print statements
>              Print $date1
>              $left = sResult!daysLeft
>              $left = DateDiff($date2, $date1, gb.Day)
>              Print $left

>              sResult!endDate = $left
>              sresult.Update

>
> But sResult is read only and I also tried rTable but that adds a new
> record, I need to update the daysLeft field only.
>
> --
> rocko <sunblaster5 at ...626...>
>
>
>
------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user