Andreas Pfeiffer
Forum Replies Created
-
Is it $horzscroll?
-
Hi Martin,
Yes – this is possible within Omnis.
Check out the pictconv… functions. Here is a link to the documentation: https://www.omnis.net/developers/resources/onlinedocs/FunctionRef/Functions_A-Z/pictconvfrom.html#pictconvfrom
There is also a function to find out what format the picture is: https://www.omnis.net/developers/resources/onlinedocs/FunctionRef/Functions_A-Z/pictformat.html#pictformat
Hope this helps.
Best,
Andreas
-
Awesome Uwe, well done!
We love to see our customers happy!
Best regards,
Andreas
-
Martin,
Do not use a server side timer.
Instead use the timer control and run the timer on the client side.
Best,
Andreas
-
Hi Uwe,
You might want to check out the JS Preferences sample library in the HUB. It allows to store a secret key in the local storage of the browser.
However doesn’t the browser support to store the credentials? It should work automatically to load the credentials from the password manager when visiting the site.
Best,
Andreas
-
Martin,
I think it is because you are joining the list. That might destroy the $smartlist. I wonder why you are not simply using the import list instead?
Alternatively you could use a $sendall instead:
Do iDataList.$clear()
Do iDataList.$smartlist.$assign(kTrue)
Do iImportList.$sendall(iDataList.$add().$assignrow($sendallref))
Do iDataList.$dowork()
But – it is confusing for me that you are actually calling this method from the popup form – but you are not passing the list as a parameter from the popup form into the method that suppose to store this. Why not saving the data directly within the popup form instead calling a method in the main form?
Best,
Andreas
-
Martin,
after thinking about that issue when you pass in a parameter from the UI which of the columns need to be checked – it is still not OO. The task to control the business rules – in that case which columns are unique should be encapsulated in the list not in the remote form instance.
But this is easy to achieve. Each inherited table class that uses a schema class and therefore the method in the super table class can also access any of the column properties of the attached schema class.
So what you can do is to set a marker in the columns in question in the schema class. I used a “{u}” – so open curly brackets, u (unique) and close curly brackets.
Here is the change in $showduplicates
Set reference lSchemaRef to $schemas.[$cinst.$sqlclassname] ## this is the schema class that is attached to the concrete table class - remember this code would normally be in your super table class
If lSchemaRef
Do lSchemaRef.$objs.$sendall($cinst.$hidenonduplicates($ref.$name),contains($ref.$desc,'{u}'))
Calculate lHasDuplicates as $cinst.$linecount>0
Else
Send to trace log 'instance does not have a schema when running $showduplicates'
End If
So instead of using a parameter we now use the description property of the columns in the attached schema class.
And we assume that the code that we have written will be in the super table class and hence it will work on all inherited table classes.
From now on you do not even need to remember this when you design the UI part.
I hope this makes sense. Library attached.
Best,
Andreas
-
This reply was modified 1 year ago by Andreas Pfeiffer.
-
This reply was modified 1 year ago by
-
Awesome!
Have a great day!
Best,
Andreas
-
Great! It will good to see you again!
Best,
Andreas
-
Hello Rainer,
You are welcome. I am glad you found my technical note.
Also there is a sample library in the HUB that shows how to import or export when using a remote form: jsFileUploadDownload
Best,
Andreas
-
Hi Uwe,
I did a quick test with the sample library from the HUB copying the following into the $init method of the remote form:
Do lPrefRow.$define(lPrefName,lPrefValue)
Do lPrefRow.$assigncols('omnis_pref1','iPref1')
Do $cinst.$clientcommand("loadpreference",lPrefRow) Returns #F
Do method process (iPref1)
The “process” method is a server executed method and will receive the loaded content. Note that iPref1 needs to be an instance variable though.
You can then use this information to make a $changeform or assign a specific subform if you wish.
I hope this helps.
Best,
Andreas
-
This reply was modified 11 months, 2 weeks ago by Andreas Pfeiffer.
-
This reply was modified 11 months, 2 weeks ago by
-
Martin,
Talking about importing data you might be interested in those technical notes:
https://www.omnis.net/developers/resources/technotes/tnls0002.jsp
https://www.omnis.net/developers/resources/technotes/tnjs0011.jsp
Best and Happy New Year!
Andreas
omnis.net
Omnis Technical Notes - Importing a CSV file into a list
Omnis Technical Notes - Importing a CSV file into a list
-
Martin,
You are very welcome!
Thanks for your feedback.
Have a great day.
Best,
Andreas
-
Ok – so this would normally be part of the database responsibility. When you set up a unique index on that column the insert should fail and you could return a proper error message when inserting the data. But maybe you want this before hitting the “save” button I assume.
Best,
Andreas
-
Yes – you could make your argument longer in the $sendall as well as in the $filter by using the ampercent “&” sign or the pipe symbol “|”. The ampercent is the logical “AND” and the pipe symbol is the “OR”. You can also use parentheses to group logical expressions.
That said a $sendall can become very long horizontally and therefore un-readable and hard to maintain. I would avoid too many logical arguments. What would you do if you would need to search for 100 columns?
That is the reason I broke it up into two separate methods (see the post below) but still using the $sendall to call the sub routine from the main method.
I hope this makes sense.
Best,
Andreas