smartlist dowork

[TBS]

Martin

The one thing I would *not* do is give up on smartlists !

Once you have it working it makes coding ***so easy***…...

There will be an answer and it’ll probably be something stupid that we will al kick ourselves about - like I have said before the essence of what smart lists do is not complicated - maybe try a manual delete/update/insert just to make sure your data is ok first and then add the smartlist side once you know your basics are working ???

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, 12:47 PM -0400, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com>, wrote:
> Hi Das,
> I am building a variable smartlist from a schema class already partially filled with data.So, $excludefromupdate might not help.Omnis support have tried to assist but have given up.This forum remains my last stop before I also give up on working with smartlists.
> Rgds Martin.
>
> On Tuesday, April 12, 2022, 07:29:02 PM GMT+3, Das Goravani <goravanis at gmail.com> wrote:
>
>
> Normally with Postgres and Omnis you would want to $excludefromupdates() and $excludefrominserts() on your primary key. Postgres needs them excluded from the insert and update commands.
>
> This is one quandary I have.
>
> They don’t seem to work for $dowork()
>
> I had a smartest, was doing $dowork() and couldn’t get $excludefromupdates() and $excludefrominserts() to work. The column was still in the SQL generated.
>
> Curious what others feel about this. Is it true what I experienced or not?
>
> Or was I just jammed somehow, not seeing the truth?
> _____________________________________________________________
> 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