Andreas Pfeiffer
Forum Replies Created
-
Hi John,
I hope you recovered well.
There is a documentation available on the databridge download page that should give you some more information.
Make sure that all clients use the databridge. It is important that no client accesses the database directly.
I hope this gets you going.
Best regards,
Andreas
-
Hi Uwe,
The simplest way is just to assume that you have a certain amount of columns max. Even if you have more it is likely not necessary to include the very last columns. But even if you add unnecessary columns to your sort command it would not hurt. For example:
Do iDataList.$sort($ref.c1,kFalse,$ref.c2,kFalse,$ref.c3,kFalse,$ref.c4,kFalse,$ref.c5)
will work – even if your list has only two columns.
However, if you want to have it precise, you can always create a string that can then be performed in square brackets. For example:
#get a string suitable for the $sort function
Do iDataList.$cols.$sendall(lString.$assign(con(lString,'$ref.',$sendallref.$name,',kFalse,')))
#get rid of the last comma
Calculate lString as trim(lString,kFalse,kTrue,',')
#now create the entire command
Calculate lString as con(iDataList.$name,'.$sort(',lString,')')
#finally perform it
Do [lString]I will attach the Omnis Studio 11.2 test library.
Hope this helps.
Best, Andreas
-
This reply was modified 1 week, 5 days ago by Andreas Pfeiffer.
-
This reply was modified 1 week, 5 days ago by Andreas Pfeiffer.
-
This reply was modified 1 week, 5 days ago by
-
Uwe,
On the other hand instead of using the real column names you could also do something like this. So if you know the list has two columns you could do this:
Do myList.$search($ref.c1,kFalse,$ref.c2,kFalse)
Best,
Andreas
-
Hi Uwe,
The $sort requires a reference to the list column, not just the name of the list column. Only if using a list that is defined from other variables it might work like this.
Do the normal syntax would be something like this:
Do myList.$sort($ref.myColumn,kFalse,$ref.anotherColumn,kFalse)
or
Do myList.$sort(myList.myColumn,kFalse,myList.anotherColumn,kFalse)
I personally prefer $ref.
This said you would be able to create your string including the “$ref.” part. But when executing you would need to make sure that the string is executed.
Not tested though but I guess something of this might work:
Do myList.$search([mySearchArgument])
or maybe
Do myList.$search(eval(mySearchArgument))
Hope this helps.
Best,
Andreas
-
Hi Uwe,
this works after the client has changed the display order. Switch on $::candragdisplayorder and then before using the test button, drag any of the columns so that you get a different display order. Then your test button will display the new display order.
I think the $::displayorder was meant to either assign a different display order or to read it after it has been changed.
The initial display order is determined by the order of the columns within the list that is assigned to the grid.
I hope that makes sense.
Best,
Andreas
-
Hello Martin,
I can see two issues here.
1. When using a reference across libraries you would need to ensure that the class in the target library can be found from the service library. You can achieve this either setting the $external property of the class in question or – and I think this is what the service library might want to have – set the $ignoreexternal property of the service library to kTrue.
2. You actually want to have the $cvardefs rather $cvars. That group contains the definition of the class variables.
Hope this helps.
Best,
Andreas
-
Uwe,
If the method is not called I would think that there is no record where the status is kRowInserted. Check $status of an inserted row.
Best,
Andreas
-
Hi Uwe,
Happy New Year.
You could override $doinsert (note – without the ‘s’) and see if you are able to track the error there. $doinserts calls $doinsert for every row where the $status is set to kRowInserted.
Hope that helps.
Best,
Andreas
-
Hi Ivan,
Maybe check out Götz’ reply on this topic:
omnis.net
Tab order not working on window component droplist - Omnis Forum
Hi, I can't get my window component droplist to work in the tab order, it seams there is no way to get it to focus,…
-
Sam,
I think you would need to filter the list on the server before you can print it in a report.
All the component does is to filter it on the client I assume.
What exactly do you mean when you say “print”? Just display or create a PDF report? In the latter case it would need to be filtered on the server. You can do this by making the list become a smart list, set $smartlist of the list to kTrue. Then you can filter the list using the $filter method of the list. Finally you can pass this list to the report class to create a PDF report out of it.
I hope this helps.
Best,
Andreas
-
Hi Sam,
So you do not want to print it then?
Or am I missing something here?
Best,
Andreas
-
Hi Sam,
You would need to create a report class that defines what is going to be printed. I recommend using an instance variable of type list inside the report. Assign this list as a $listname for the report. Then declare a parameter of type list in the $construct method of the report class and copy the data from the parameter to the instance variable.
Finally in your remote form you can use the command “print report” with an argument of the list that you have in your remote form. This content will then be transferred into the parameter of the report class.
I hope this helps.
Best,
Andreas
-
Hi Ron,
make sure you follow the technical note: https://www.omnis.net/developers/resources/technotes/tnjs0003.jsp
To me it looks like there are some missing resources in the html root.
Best,
Andreas
-
Hi Uwe,
I am glad that it works for you!
Thanks for the feedback.
Best,
Andreas
-
Hi Martin,
I am glad it helped!
Have a nice day 🙂
Best,
Andreas