[Andreas Pfeiffer]

ah – now I see what you mean.

You do not want to turn the grid, you want to turn the data – making rows to columns and vice versa.

You would need to change your data in the list. Depending on the SQL server that you use, check out the pivot SQL function.

Best,

Andreas

[Andreas Pfeiffer]

Sorry, I am still not getting it.

Do you mean to turn the complete grid 90 degrees?

[Andreas Pfeiffer]

Hello Angelo,

Complex grids in windows do have a horizontal header as well as a vertical header. Check out the properties “showhorzheader” and “showvertheader”.

Or do I misinterpret your question?

Best,

Andreas

[Andreas Pfeiffer]

Hi Angelo,

Omnis Studio 11 comes with a new client command “subformpaletteshow” that does this. There is a small sample app in the JS section of the samples in the HUB that demonstrates how to use it.

Hope that helps.

Best,

Andreas

[Andreas Pfeiffer]

Hi Vik,

have a look at the new LDAP worker in Omnis Studio 11: https://www.omnis.net/developers/resources/onlinedocs/ExtendingOmnis/07webcomms.html#ldap-worker-object

Best,

Andreas

• This reply was modified 2 years, 6 months ago by  Andreas Pfeiffer.

[Andreas Pfeiffer]

Hi Angelo,

Are you talking about web forms or window classes?

Best,

Andreas

• This reply was modified 2 years, 6 months ago by  Andreas Pfeiffer.

[Andreas Pfeiffer]

Hi Allan,

You can use $rowcsscol property of the grid. This allows you to specify an extra column in your list that takes the name for a CSS class which can change the color of your list lines.

Check out the „row styles“ section in the documentation: https://www.omnis.net/developers/resources/onlinedocs/WebDev/03jscomps.html#row-styles

Best,

Andreas

• This reply was modified 2 years, 7 months ago by  Andreas Pfeiffer.

[Andreas Pfeiffer]

Thank you for your idea.

This will be integrated in Omnis Studio 11.

Best,

Andreas

[Andreas Pfeiffer]

Hi Uwe,

The problem is that you cannot perform a $remove on the list line. Instead you would need to do this on the entire list.

So if we assume that no line is selected (please note this is different from the current line) then we can simply use the parameter to remove all non selected lines:

Do lList.$search(1=2) ## remove any selection

Do lList.$remove(kListKeepSelected)

Best,

Andreas

[Andreas Pfeiffer]

Hello Angelo,

You can follow this tech note from Omnis: https://www.omnis.net/developers/resources/technotes/tnjs0003.jsp

Best regards,

Andreas

[Andreas Pfeiffer]

Hi Uwe,

Did you try to leave the name empty? i.e something like:

Do $cinst.$objs.mysubform.$classname.$assign(“”)

On the other hand I would probably use an empty form to be displayed when no other form is used. The advantage of this is that you could use any kind of picture or logo that shows the user that no form is chosen.

Note that this only works if $multipleclasses is set to kFalse which I would recommend. Otherwise you would need to close the individual instance.

Hope this helps.

Best,

Andreas

[Andreas Pfeiffer]

Hi Uwe,

There is probably no easy way. And even then somebody would need to extract the problem.

So in some cases it is worth trying to break the part out where the problem is. In some cases that leads to find out what is going wrong if it is a logical error for example. And if the problem still exists then it is easier to present this to the Omnis support team.

Best regards,

Andreas

[Andreas Pfeiffer]

Hello Angelo,

Attached please find a small sample library that contains an object class that you can use to pivot any list. There is also a test window that loads a list of classes from that library to demonstrate how it works.

One word of warning: It is expensive. So I would like to recommend using pivot functions when loading the data via SQL. That will be much quicker if there are many data.

There is also a pitfall when you have a localised Omnis. I made some hard coded commas in there. This will fail if your parameter separator is set to something else, i.e. semicolon.

Hope this helps.

Best regards,

Andreas

pivot.lbs_.zip 7 KB Zip - Click to view

Options

• Copy Download Link

[Andreas Pfeiffer]

For small lists you might be able to do this within Omnis. Give me a little time. I will provide a little sample library.

[Andreas Pfeiffer]

Sorry, I can only see HTM tags. Can you send a picture how it should look like?

Thanks.