I resolved it myself by using in the query LEFT JOIN
- Log in to post comments
I resolved it myself by using in the query LEFT JOIN
Thanks very much
Thanks Sean,
I got it.
I have also used
<WIDE CHAR> error occured.
I think it is because of I have 8-bit version of cache and the http response in utf-8. How to solve this?
I meant programmatically
This solution works for me.
Maybe somebody will need it.
Method onloadHandler() is in custom text control class.
ClientMethod onloadHandler() [ Language = javascript ]
{
var comp = this;
var elem = this.findElement('control');
elem.addEventListener('click', function(){
comp.someMethod();
});
}
I have tried to do that in my custom text control class in method
zenThis.doSomeWork();
});
But this code is not working.
Thanks, Amir, for your advice.
I decided to change in old program methods for saving and deleting entries. I changed direct access to global on object access and methods %Save() and %DeleteId(). These methods automatically handle new index global. I also call old methods for old index global and other old code.
I have two different ways for creating new objects because of there are two different interfaces in the program. There is old interface via terminal with direct access to globals and there is new zen web interface with classes.
And some users prefer to work with old terminal interface, so I must to maintain also the old inteface.
Can you give me some example with %FileIndices? I didn't find anything
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.SearchPageZe…
I found what is the problem.
When I have opened new window through
But when I have used
I don't know why, but it is not working for me.
Did you try this callback and it was working?
The problem was, that I did wrong query. When editable property is 1 and we add a parameter to dataCombo, in query it stand second sign of ?. First sign of ? is user's entered search string in dataCombo.
For instance: there is a sql "SELECT id, name FROM table WHERE some = ? AND name = ?"
The parameter value is second sign of ?. I thought earlier that parameter is first.
I tried, in browser it doesn't work.
Browser outputs it as - &#65292; if I use ZConvert("... , ...", "O", "HTML")
and "as is" if I use plane string - "... , ..."
Nothing works.
I have refused of idea to use comma in columnHeaders string. I will be use dash sigh like "House - apartment".
Why did not Intersystems implement such behavior in dataCombo.columnHeaders like in combobox.displayList?
In combobox.displayList we can escape comma "\," and it wirks fine.
My version is - Cache for Windows (x86-64) 2017.1 (Build 792) Mon Mar 20 2017 19:36:11 EDT
I am running 8-bit version, not UNICODE. My old bases in 8-bit encoding.
No, is not working. This comma break string.
DropDown column header breaks on this comma. There is only text till your comma - "Number "
Is not working. If I put this >>> ,<<< to string, and my string looks like "Number >>> ,<<< apartment", then in dropdown
header there is only first part till space - Number >>>
I think, it is impossibe to escape comma in dataCombo columnHeaders. I tried a lot of variants, and nothing
How should I place this html entity to string?
If I do this way "House number, apartment", it is not working.
This solution works when a global has autoincrement subscript. Then the most recent added row subscript always has greater value and after
But my global's subscript is generated on runtime, it depends on input values. And after adding new record to global I call tblPane.executeQuery() and my new row is not last. And I don't know how to find it for selecting.