Session Error Message
goravanis at gmail.com
Mon Jan 31 18:00:26 UTC 2022
Well I figured it out partly.
I got it to work, without a SQL error message.
By switching from a REF to my session object to using the actual session object.
It seems my REF is not quite right.
Here is my LOGON method line:
Do tSessObjPG.$logon('220.127.116.11',iUserName,iUserPassword,'PGSESSION') Returns #F
It establishes a session named PGSESSION
Here is my method line that makes my REF to the session object:
Calculate tSessObjPGRef as $extobjects.PGSQLDAM.$objects.PGSQLSESS.$newref()
It makes a REF OK, but it’s not the one that is logged on?
How do I make a ref from the session that is logged on?
> On Jan 31, 2022, at 12:52 PM, Das Goravani <goravanis at gmail.com> wrote:
> I have the following code:
> Do cvCitiesList.$definefromsqlclass($tables.tccities)
> Do cvCitiesList.$smartlist.$assign(kTrue)
> Do cvCitiesList.$sessionobject.$assign(tSessObjPGRef) Returns #F
> Prepare for import from file Delimited (commas)
> Import data cvCitiesList
> Close import file
> End import
> Do cvCitiesList.$doinserts() Returns #S1
> When I run it on the last line it goes into the SQL error method I have in the table class and the error message text is "Session not logged on" and "Session must be logged on"
> I am logged on to postgres. I have a session showing up under the SQL Browser, so I know I’m connected. I am assigning as you can see the Session Object Ref to the list.
> I don’t get where "The session is not logged on".
> Any ideas?
More information about the omnisdev-en