December 4, 2019 at 4:27 am
Hi,
In my application I am fetching data from a View which internally having multiple select qurries combined using Union. It's near about 500 lines of query.
When i fire Select on view it takes some time and then throws Datatype coversion error. To find the source of the error I execute available queries on View one by one. After that only I come to know which select statement giving me the error.
Could you please tell me best feasible solution to handle such a type of issue?
Thanks in advance.
December 4, 2019 at 6:17 am
Tracing the error :
Recently I wrote an article on How to Implement the Batch Processing using WHILE LOOP. I've also depicted the use of TRY..CATCH which you can refer as a sample/example
Avoiding the error :
Data Modelling is very important and is occasionally ignored. I've started a series of article Does it matter ? that talks about most important but least focused areas in Database Design and Development. You can spend few minutes reading it. I hope it will give you some insights.
December 4, 2019 at 9:33 am
At table level:
The data kind for this discipline need to enable decimals. So: Single, Double or (not sure) Currency.
If you desire you also can set the Format property to Percent but this is now not important.
At structure level:
Set the Format property for the bounded control to Percent.
December 4, 2019 at 10:21 am
hi - is this a datetime conversion error?
2nd question - if it is, is it stored in a varchar field
MVDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy