Andreas Pfeiffer
Forum Replies Created
-
Hi Christoph,
check out the new Omnis Studio 11 JS File upload / download sample in the HUB.
Best,
Andreas
-
This reply was modified 2 years, 11 months ago by Andreas Pfeiffer.
-
This reply was modified 2 years, 11 months ago by
-
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
-
Sorry, I am still not getting it.
Do you mean to turn the complete grid 90 degrees?
-
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
-
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
-
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, 11 months ago by Andreas Pfeiffer.
-
This reply was modified 2 years, 11 months ago by
-
Hi Angelo,
Are you talking about web forms or window classes?
Best,
Andreas
-
This reply was modified 2 years, 11 months ago by Andreas Pfeiffer.
-
This reply was modified 2 years, 11 months ago by
-
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, 12 months ago by Andreas Pfeiffer.
-
This reply was modified 2 years, 12 months ago by
-
Thank you for your idea.
This will be integrated in Omnis Studio 11.
Best,
Andreas
-
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
-
Hi Angelo,
I noticed there is still a glitch. It startet to fail if the list has much more lines because the Do command could not handle the length of the argument. Therefore I changed it using a row variable for adding the line which seems to work much better.
Please see attached lib.
Best,
Andreas
-
now – also works for other language settings. Please see attached.
-
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
-
For small lists you might be able to do this within Omnis. Give me a little time. I will provide a little sample library.
-
Sorry, I can only see HTM tags. Can you send a picture how it should look like?
Thanks.