Hello there,

I have some problem with inserting date to table using dynamic sql.

I have Country class. This table has relationship with class Continent as parent and child. In addition I have another statistic class where property Country has type of Country class. I get ID such as "1||1" next I execute dynamic sql INSERT INTO Stats(Country) VALUES("_CountryId_"). Then I select Stats table and see that value of Country column is "11") As a result a can't get Country object.

Please advice solution of this problem

Thank you

0 2
0 337
Question
· Nov 23, 2017
Indexing null value

Dear community!

I have problem with index NULL value. Unique index doesn't work for this case. If I use insert and one of parameter is "NULL". Message of constraint doesn't appear and row is inserted into table successfully. How Can I use index with NULL?

1 3
0 632

Hello,

I work with trigger and I need afeter update make INSERT into LogTable value of prorerty of saved class. This is what i have in this monent.

S className = ..%ClassName(1)
S cls=##class(%Dictionary.CompiledClass).%OpenId(className)
F i = 1:1:cls.Properties.Count() {
S prop = cls.Properties.GetAt(i)
S propName = prop.Name
S value={propName*N}
}

How Can I get value given "prop".

0 8
0 548
Question
· Apr 17, 2017
Overide trigger

Hello everyone.

I have some issue with trigger. I have class where I defined 3 triggers (UPDATE, INSERT, DELETE). These triggers are Foreach = row/object. In my currently task, I need overide this triggers in children class. is It possible to do it?

Thank you for your help.

1 4
0 308

Hello everyone. I have some problem with selecting my own globals from namespace. My task is select only globals created by me. Follow my code, I get all globals from given namespace.

0 2
0 296