Quest for a generic update statement

[Das Goravani]

I’m having trouble writing a generic update statement that works.

Right now what I have is this

Do tstaobj.$execdirect(con('UPDATE ',iFileClass,' ',tsessobj.$updatenames([irowname]),' WHERE [iindexfield] = @[irowname].[iindexfield]')) Returns #F


iFileClass is the name of the table.. they’re the same names
irowname   is obviously the row
iinkdexfield   is an indexed column in the table

irowname      and   iindexfield   are both values that are a row name and an indexed columns name

So they can’t share the same square brackets as far as I understand

Anyways I tried it with them individually plus collectively, and just collectively and this as shown, none worked per se to solve the riddle

I hope I can work out this syntax and I dont have to go further, learn some other way, to pull this off

I’m going by the flag, it should return 1 if it’s working, oddly the SQLERROR trap method isn’t popping up for this though it’s not working, odd