SQL ERROR

Dan Ridinger dlr at futurechalk.com
Thu Feb 11 23:29:49 UTC 2021


If I remember correctly you would have to prepare the text before it can be executed when put directly into $sqltext. Just a thought.


> On Feb 11, 2021, at 11:13 AM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hi $all,
> I have successfully logged on to an omnis database using OMSQLDAM
> I have a remote form with a button "load" which I use to select and fetch data.In the $event method, I have defined a variable:lvCustomerList variable of type tCustomers
> "tCustomer" table class "tSuper" super class
> In the "tSuper" table class I have defined a variable:lvStatementObjRef Variable of Type Item Reference
> In the class method "$sqlerror" I have the following statement:Set reference lvStatementObjRef to $cinst.$statementobjectCalculate iScript as lvStatementObjRef.$sqltextCalculate iErrotText as lvStatementObjRef.$nativeerrortext
> When I execute the load method, I get the error below:e125207 Problem with notation unnamed_value.$sqltextinstance error: SQL DAM not supported
> Any assistance is highly appreciated.
> Martin.
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list