It had one line to set @cursor_to_col_id, but now I added some extra logic to clear the textfield when the value of the textfield is the same value as the last stored value in the database. (automatically clear the text that is filled by the 'radiobutton')
Thanks Jasper and Jop!! Spent about an hour yesterday trying to solve this.
No that's not the problem, it just shows the value as if there's no translation object. it shows [fieldname]:
This topic needs to be for Development instead of Deployment. Don't know how to remove it here.
I have changed the layout procedure. Instead of using a field from the form to determine whether another field should be displayed/hidden in the form, I use a field from the database for this. I think that in the mobile app, the fields on the form are not updated between executing a tab task and the layout procedure.
The credits are for Arjan Jonas For the linked server properties on the SQL server, go to "Server options", then set the value "Collation Compatible" to true [img]https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/61ff077d-d5fe-4d2c-a02b-4b0c81cb68f4.jpg[/img]
We still can't update a record by using the linked server via the mobile app, only with the windows app we can. Next week Arjan Jonas will be in our office, hopefully he can help us with this problem. If we find a solution I will post it on this forum.
Yes I checked the authorisation on the linked server and should be ok. I can also use an openquery without any problem. Next thing I'm going to try, is an update by a task.
[quote=Robert Jan de Nie]As Robbert points out, this seems an authorisation issue. But reading this, I do have a further question: are you updating data from a default procedure? Default procedures are meant to retrieve data from the database and/or do calculations in order to show them on the screen (form) the user is editing. When you update data from within a default procedure (it is possible, nothing is stopping you), data will be modified, regardless of if the user actually finishes and saves the action he was doing. To summarise:[list] [*]User enters edit mode (or presses add) [*]Default procedure fires and updates a record (on the linked server) [*]User moves to next field in the form [*]Default procedure fires and updates a record (on the linked server) [*]User presses cancel [*]Changes to the data have not been saved to the database (except for the data that has been modified via the default procedure) [/list]There are edge cases where you would want to save som
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.