Importing straight to SQL

Das Goravani goravanis at gmail.com
Mon Jan 31 18:01:56 UTC 2022


I figured out a way to do this that works and is less code and probably faster.

It is to make my list a SmartList and then $doinserts()

It works, so I’m going to go with that. 




> On Jan 30, 2022, at 6:53 PM, Das Goravani <goravanis at gmail.com> wrote:
> 
> 
> 
> I tried the code I posted and it didn’t work.
> 
> So I tried defining a SQL ROW from a table class connected to the SCCITIES schema, and did this
> 
> Calculate tvfccitiesrow as cvCitiesList
> Do tvfccitiesrow.$insert() Returns #F
> 
> I calculate the ROW as the list. This assigns #L’s values to the row. I checked that that is going on.
> 
> I then use the ROW to do the insert.. wondering if $insert just doesn’t work on lists.
> 
> But it didn’t work on the row either.
> 
> I am familiar with using the row to do inserts, so I was surprised it didn’t work. 
> 
> When I define the row from SQL Class the connected table class runs the construct of the master table class and there I have the session object being assigned to $cinst which is the row…so that is being done.
> 
> Any idea why this wouldn’t work?
> 
> Should it work from the list instead?
> 
> 



More information about the omnisdev-en mailing list