$fetch data into row variable

[Das Goravani]

I’ve never seen a list or row put into fetch like that.
It fetches into $cinst
Then do Calculate idatarow as $cinst perhaps?

> On Sep 30, 2022, at 12:43 PM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi $OSListers,
> I have searched through the list archives for the fetch command.
> I have not found a closer answer to the problem I have.
> I have this method below in a tableclass to fetch data from postgresql.
> 
> If $cinst.$type=kRow
> 
> Do $cinst.$select("WHERE ",iPrimaryKey," =",pFetchID)
> Do $cinst.$fetch(iDataRow) Returns lFetchOk
> End If
> Quit method lFetchOk=kFetchOk
> If I loop through the lines and check the variables:
> iPrimaryKey has a value
> pFetchID has a value
> lFetchOk returns flag True
> But iDataRow is empty
> What is the correct syntax to fetch data into a row variable with a where clause?
> Grateful as always for all your kind helps.
> Obongita
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com