A regular update statement

[Das Goravani]

I know I’m asking for the fish.. 

It would take so long to trial and error it out.. 

I’ve been on this table for days

Just wondering how to do an update statement the simplest way

I know there is $createnames and select names I think there’s an update names

But how to syntax it correctly

I have 300 columns, generic central code, want to keep it that way

I will fork for this one table as all others work OK with $update

For this one it returns no errors and flag true but doesn’t update the data actually

How to do a generic whole table update statement?

> On Aug 2, 2020, at 11:00 AM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> Help me out quick here.. in order to get around my problem with $update on one table I have
> 
> I want to construct a regular SQL update statement and don’t know how
> 
> I could look online but I might not find the wildcard character
> 
> Is update done like this:
> 
> $execdirect(UPDATE * FROM tablename)
> 
> Can I do it that simply?
> 
> Asterisk standing for “all columns”.. is that possible?
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com