smartlist dowork

[TBS]

Martin

In its simplest form the call $dowork() should ‘just do it’ (deletes, updates  and inserts) however - as I believe you were trying - you would normally want to use a table class to override the methods here and add your own custom stuff…..

In your example were you able to find the relevant method which was failing and add a breakpoint so you could see the error being returned ? I am wondering if your issue may be data related as opposed to code related - as essentially your code is very simple (I don’t mean that in any derogatory manner - simply in respect of the example you showed doesn’t really look like it would have anything that should go wrong !)

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com
On Apr 12, 2022, 11:50 AM -0400, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com>, wrote:
> Hi all,        I have looked in the hub for sample libraries that could show how to insert or update a smartlist.        I didn't seem to find any.        Does anyone here have a snippet on how to insert and/or update a smartlist?        Kind regards, Martin O.
>
>
> On Monday, April 11, 2022, 10:58:58 PM GMT+3, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
>
> Hi Das,
> Thanks for your ideas.
> I have a remote task rtMonirot that logs to postgres server and then creates a session.An error is returned if the session is null.
> How do I check that the session is still logged on when I am updating a smartlist?
> Rgds,
>
>     On Monday, April 11, 2022, 08:39:08 PM GMT+3, Das Goravani <goravanis at gmail.com> wrote:
>
> The fact that your button event returns flag true is not relevant given you’re not returning the flag out of your save method, and that last .$next() may return a flag and thus mislead you. So forget that flag.
>
> Not updating database… your code is pretty simple, so the suspect part is clear to see..
>
> Have you stepped through it with good sample data in list with some changes or inserts
>
> Did if fork to your save method like it’s supposed to
>
> Did it surely step over the update and insert commands?
>
> If it did and no data was update/inserted then you have to wonder about your connection
>
> Which goes to are you surely logged on
> Do you have thus your log on objects, statement and other...
> And you’re putting other into this list
> Thus blessing it with abilities to update data
> Blessing it with connection to the data
>
> If those things aren’t in place and active then data won’t update
>
> Sorry I temporarily forgot the names of things, I haven’t coded lately..
>
> I don’t know why but I found sometimes $cinst didn’t work right, and I had to go to putting in the list name in a variable in square brackets where $cinst goes, but I hope that is not the case for you and that it works as it should
>
>
> > On Apr 11, 2022, at 8:08 AM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> >
> > Hi All
> > I am trying to update a smartlist with the following methods:
> > btnUpdate: $event
> > Do iOrgGeneralPrefList.$dowork() Returns #F
> >
> > taSuperTable: $dowork
> > Do $cinst.$first()
> >
> > While $cinst.$line>0
> >
> > Switch $cinst.$status
> >
> > Case kRowDeleted
> >
> > Do $cinst.$delete()
> >
> > Case kRowInserted,kRowUpdated
> >
> > Do $cinst.$save()
> >
> > End Switch
> >
> > Do $cinst.$next()
> >
> > End While
> >
> > Quit method #F
> >
> > taSuperTable: $save
> > If $cinst.[iPrimaryKeyName]>0 ## already primary key value
> >
> > Do $cinst.$update($cinst) Returns #F
> >
> > Else
> >
> > Do $cinst.$insert() Returns #F
> >
> > End If
> >
> > The flag in the btnUpdate $event returns kTrue.        But the changes in the smartlist are not updating the table in the database.
> > Where in my code am I going off the rails?
> > As always, I appreciate all your kind helps.
> > Martin.
> > _____________________________________________________________
> > Manage your list subscriptions at https://lists.omnis-dev.com
> > Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com