Hi Peter, thanks for this tutorial. I am getting an error when extending the NumberSeqApplicationModule class, can you suggest what I might be missing? I am a beginner so any help would be much appreciated! Thanks again!
Hi Peter, Thank for you for showing the Number sequence concept. When we deploy the changes to a new server how will the Number sequence will get set in the ‘Number sequence’ tab.
This is a good question. I believe as part of promoting the code to a new server, Microsoft is going to run certain code every time, such as this, to ensure that new number sequences get added to the tab. So it should happen automatically when you promote code. No action needed.
thanks Peter for this video ,, actually u have a question .. if i do same step and didn't save the record for CarId .. i mean i pressed New that will call Create method .. number seq will populate in CarId field ,, then i didn't save and delete the record ,, next time will get the next number seq although i didn't save it ,, how can i handle it ?
Usually it really isn’t a problem that the system keeps incrementing you the next number. As long as the format of you number is enough # symbols you should not run out of numbers. You can check the continuous flag and the system would then later go back and try to use those un-used values. But checking the continuous flag isn’t actually recommended. Just let the system skip the number. If you really need a value that is always incremental you shouldn’t use a number sequence. Instead you can use a method to calculate the next number based on first finding the previously highest number and adding 1 to that value.
Thank you Peter for this video, its very helpful. Actually i have a question, when i test my number sequence and when i click new, the system set up the next number sequence but it doesnt add a row, it just stays at one row. And i have no idea how can i fix this problem
Check and make sure that the datasource property is set on the grid control on your form. You can also put a breakpoint in the ‘create’ method of the datasource and make sure it is getting called by the system when you push the new button.
Typically you will want the number sequence to be set and populated when you first create the record and not when you are saving the record. It would be a little confusing if you had a field that was a key identifier field, but you left it blank, and only when you went to save it did the system populate it. Functionally it makes more sense if the field gets populated as soon as the user clicks the “new” button.
Peter, We have different types of items which will require its own number sequence. Similar to the Fixed Asset type, how do I get started? Any help will be greatly appreciated.
I get an error message when I open the Trial balance form, this is a standard form of the system what should I do to fix this Stack trace: Call to TTSCOMMIT without first calling TTSBEGIN.
This error occurs when there are not the same number of calls to ttsbegin as ttscommit. This can happen if you forget one of these statements. Or if you have one, but not both inside of an if statement. I recommend you debug the kind and go like by line of what code runs. And keep track of when the code calls ttsbegin and ttscommit. And figure out which ttscommit is missing a corresponding ttsbegin.
Thanks Peter for making such an informative video. Greetings from Pakistan
Thank you! Greetings!
Thank you Piotr for your work! Greetings from Poland. You are always helpful :)
Thanks!
this is fantastic man! Thank you very much! Greetings from Mexico
You are most welcome! De nada!
good work
Thanks
Hi Peter, thanks for this tutorial. I am getting an error when extending the NumberSeqApplicationModule class, can you suggest what I might be missing? I am a beginner so any help would be much appreciated!
Thanks again!
I would be happy to try to help. Can you tell me what the error message is? And perhaps share the code?
Hi Peter, Thank for you for showing the Number sequence concept. When we deploy the changes to a new server how will the Number sequence will get set in the ‘Number sequence’ tab.
This is a good question. I believe as part of promoting the code to a new server, Microsoft is going to run certain code every time, such as this, to ensure that new number sequences get added to the tab. So it should happen automatically when you promote code. No action needed.
Awesome tutorial !! Helped a lot
thanks Peter for this video ,, actually u have a question .. if i do same step and didn't save the record for CarId .. i mean i pressed New that will call Create method .. number seq will populate in CarId field ,, then i didn't save and delete the record
,, next time will get the next number seq although i didn't save it ,, how can i handle it ?
Usually it really isn’t a problem that the system keeps incrementing you the next number. As long as the format of you number is enough # symbols you should not run out of numbers. You can check the continuous flag and the system would then later go back and try to use those un-used values. But checking the continuous flag isn’t actually recommended. Just let the system skip the number. If you really need a value that is always incremental you shouldn’t use a number sequence. Instead you can use a method to calculate the next number based on first finding the previously highest number and adding 1 to that value.
Thank you Peter for this video, its very helpful. Actually i have a question, when i test my number sequence and when i click new, the system set up the next number sequence but it doesnt add a row, it just stays at one row. And i have no idea how can i fix this problem
Check and make sure that the datasource property is set on the grid control on your form. You can also put a breakpoint in the ‘create’ method of the datasource and make sure it is getting called by the system when you push the new button.
why only create method is used for it. why other methods are not used for creating number sequence like validate write, write or any other methods
Typically you will want the number sequence to be set and populated when you first create the record and not when you are saving the record. It would be a little confusing if you had a field that was a key identifier field, but you left it blank, and only when you went to save it did the system populate it. Functionally it makes more sense if the field gets populated as soon as the user clicks the “new” button.
Peter, We have different types of items which will require its own number sequence. Similar to the Fixed Asset type, how do I get started? Any help will be greatly appreciated.
I meant to say similar to Fixed Asset Group.
I get an error message when I open the Trial balance form, this is a standard form of the system what should I do to fix this
Stack trace: Call to TTSCOMMIT without first calling TTSBEGIN.
This error occurs when there are not the same number of calls to ttsbegin as ttscommit. This can happen if you forget one of these statements. Or if you have one, but not both inside of an if statement. I recommend you debug the kind and go like by line of what code runs. And keep track of when the code calls ttsbegin and ttscommit. And figure out which ttscommit is missing a corresponding ttsbegin.