Andy Hilton andyh at totallybrilliant.com
Thu Feb 11 19:21:22 UTC 2021


A wild ass guess but did you define your variable as a local variable (convention would say naming it ‘lvxxxxx’ would indicate a local variable) and are trying to reference it in a different method ? ‘Local’ variables are only alive within the scope of that one method, if that is the case change it to an Instance variable to widen its scope (you can drag from local variables list in to the instance variables list)

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870 
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> 
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com

> On Feb 11, 2021, at 2:13 PM, 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