Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Other Discussions
  3. The Weird and The Wonderful
  4. When to check for null ?

When to check for null ?

Scheduled Pinned Locked Moved The Weird and The Wonderful
csharplinqasp-netdatabasearchitecture
32 Posts 10 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Sasha Laurel

    PEBKAC ! I had forgotten about that one, thanks for reminding me. Yes, I would say that is usually a problem with computers. Also, thanks for reading my rant it makes me feel like at least someone listened. As for the C# vs. VB debates, I don't really mind. It really gets so funny at times (people will argue the silliest things based on ideas that aren't even true). There is no problem with VB.Net especially for those of us who code using 'Option Strict On' (I'm really biased towards static typing). I find VB preferable because of the way you can easily tell where each block begins and ends. Doing so with this is hard for me: {{{{{{{{{{}}}}}}}}}} :confused:

    B Offline
    B Offline
    Brisingr Aerowing
    wrote on last edited by
    #8

    I always have Option Strict On, and a lot of VB projects I download from different sites won't compile with it on, so I modify them to compile.

    Bill Gates is a very rich man today... and do you want to know why? The answer is one word: versions. Dave Barry Read more at [BrainyQuote](http://www.brainyquote.com/quotes/topics topic_technology.html#yAfSEbrfumitrteO.99)[^]

    1 Reply Last reply
    0
    • L Lost User

      You are wrong. VB is the problem. It was always sold as sooooo easy to learn and use and then remained the safe harbor for all the horror coders they had picked up. A kind of Jurassic Park for coders. Give a user a program and he can work for a day. Show the user how to program and you have work for the rest of your life.

      At least artificial intelligence already is superior to natural stupidity

      S Offline
      S Offline
      Sasha Laurel
      wrote on last edited by
      #9

      Quote:

      You are wrong. VB is the problem.

      I'm afraid not. Go ahead and open your mouth and insert your shoe. In this case it is a combination of ignorance and arrogance that is the problem (something that you also seem to be displaying by this comment). Since you know so much about the culture of my workplace, why don't you expound upon that?

      L 1 Reply Last reply
      0
      • L Lost User

        You are wrong. VB is the problem. It was always sold as sooooo easy to learn and use and then remained the safe harbor for all the horror coders they had picked up. A kind of Jurassic Park for coders. Give a user a program and he can work for a day. Show the user how to program and you have work for the rest of your life.

        At least artificial intelligence already is superior to natural stupidity

        A Offline
        A Offline
        Andrei Straut
        wrote on last edited by
        #10

        CDP1802 wrote:

        You are wrong. VB PHP is the problem

        FTFY :laugh: On a more serious note, I don't think any language is the problem. The problem is the people using them...

        L 1 Reply Last reply
        0
        • S Sasha Laurel

          Another project from our "star" developer who is apparently beyond contempt in every way. I was given this website (an ASP.Net Webforms project written in VB10) to add some additional metrics. To my horror I found that even though written very recently (within the last 2-3 years) and then updated to use a new Linq-to-Entities data source, there was no regard for architecture, and all of the data access code was written directly in the code behind of the aspx pages. That's not even the real horror. I was getting (seemingly) random errors while trying to run it/understand it, and found that through-out all of the loads of Linq statements that all of the nullable types (e.g. Integer?, Double?, DateTime?, etc.) were being treated as if they were not nullable at all! Here is an example to help you understand (table/field names changed slightly to protect the guilty):

          Dim partTransactionTypeThingsQuery As IQueryable(Of SomeTransactionRelatedItem) = \_
                      From t In baseQuery
                      Join tji In dataContext.OtherTransactionItems \_
                          On tji.SomeTransactionID Equals t.ID
                      Where (t.LastUpdatedDate >= startDate \_
                             And t.LastUpdatedDate < endDate) \_
                          And (tji.Type = "Part") \_
                          And (tji.TotalDue <> 0)
                      Select tji
          

          LastUpdatedDate is a Nullable(Of Date) and TotalDue is a Nullable(Of Double) and when it translates to SQL it will work just fine.. The problems come about when the context switches from Linq-To-Entities to Linq-To-Objects (I have to watch closely for a .ToArray() or .ToList() or anything else that executes the SQL and fetches results) and much of the aggregation is doing exactly that. I don't even know how many of these problems there are... Anyways, thanks for letting me rant a bit. Any suggestions? Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

          J Offline
          J Offline
          Jasmine2501
          wrote on last edited by
          #11

          Just fix your stored procedures so they don't return nulls.

          S 1 Reply Last reply
          0
          • J Jasmine2501

            Just fix your stored procedures so they don't return nulls.

            S Offline
            S Offline
            Sasha Laurel
            wrote on last edited by
            #12

            That's a great idea. Now if only I had the access to do that...

            A 1 Reply Last reply
            0
            • A Andrei Straut

              CDP1802 wrote:

              You are wrong. VB PHP is the problem

              FTFY :laugh: On a more serious note, I don't think any language is the problem. The problem is the people using them...

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #13

              PHP? That's Triassic Park! :) Every language may have a share of bad coders, but some have been advertised to them as being especially 'easy to learn'. They were called and they came. The languages may have evolved over time, but many of the coders have not.

              At least artificial intelligence already is superior to natural stupidity

              1 Reply Last reply
              0
              • S Sasha Laurel

                That's a great idea. Now if only I had the access to do that...

                A Offline
                A Offline
                Andrei Straut
                wrote on last edited by
                #14

                Sasha Laurel wrote:

                That's a great idea. Now if only I had the access to do that...

                In this case, yes, suicide is a very tempting alternative. Homicide, on the other hand, mmm... ;) ;)...sweet I've found a nice way to punish the original coders when I come across stuff like this. Ask them what they intended to do in that portion(s) of the code, and WHY they did it so. It's not offensive, and it's perfectly justifiable. Now, one of two things may happen: - You, made to look like a fool if they can come up with a good explanation why they did what they did (which is ok with me, 'cause at least I can understand, and I don't mind admitting sometimes I'm just plain dumb), or - The 'WTF-did-I-do-here-can't-remember-can't-justify look on their faces, which is purely priceless (it may not help in untangling that code, but my ego will feel a really nice tickle-tingle) Now, in your specific case, I have no idea what would help, short of modifying the whole codebase :( :(

                1 Reply Last reply
                0
                • S Sasha Laurel

                  Another project from our "star" developer who is apparently beyond contempt in every way. I was given this website (an ASP.Net Webforms project written in VB10) to add some additional metrics. To my horror I found that even though written very recently (within the last 2-3 years) and then updated to use a new Linq-to-Entities data source, there was no regard for architecture, and all of the data access code was written directly in the code behind of the aspx pages. That's not even the real horror. I was getting (seemingly) random errors while trying to run it/understand it, and found that through-out all of the loads of Linq statements that all of the nullable types (e.g. Integer?, Double?, DateTime?, etc.) were being treated as if they were not nullable at all! Here is an example to help you understand (table/field names changed slightly to protect the guilty):

                  Dim partTransactionTypeThingsQuery As IQueryable(Of SomeTransactionRelatedItem) = \_
                              From t In baseQuery
                              Join tji In dataContext.OtherTransactionItems \_
                                  On tji.SomeTransactionID Equals t.ID
                              Where (t.LastUpdatedDate >= startDate \_
                                     And t.LastUpdatedDate < endDate) \_
                                  And (tji.Type = "Part") \_
                                  And (tji.TotalDue <> 0)
                              Select tji
                  

                  LastUpdatedDate is a Nullable(Of Date) and TotalDue is a Nullable(Of Double) and when it translates to SQL it will work just fine.. The problems come about when the context switches from Linq-To-Entities to Linq-To-Objects (I have to watch closely for a .ToArray() or .ToList() or anything else that executes the SQL and fetches results) and much of the aggregation is doing exactly that. I don't even know how many of these problems there are... Anyways, thanks for letting me rant a bit. Any suggestions? Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                  B Offline
                  B Offline
                  BobJanova
                  wrote on last edited by
                  #15

                  This is probably actually Microsoft's fault: a Linq query should work the same for a query against the database, or a query against an in-memory object that was created by evaluating a Linq query on that same database.

                  S 1 Reply Last reply
                  0
                  • B BobJanova

                    This is probably actually Microsoft's fault: a Linq query should work the same for a query against the database, or a query against an in-memory object that was created by evaluating a Linq query on that same database.

                    S Offline
                    S Offline
                    Sasha Laurel
                    wrote on last edited by
                    #16

                    Interesting idea! I wonder what the implications would be for an IQueryable provider. Oh well, I'm mostly just wanting to piss and moan at the moment.. ;)

                    1 Reply Last reply
                    0
                    • S Sasha Laurel

                      Another project from our "star" developer who is apparently beyond contempt in every way. I was given this website (an ASP.Net Webforms project written in VB10) to add some additional metrics. To my horror I found that even though written very recently (within the last 2-3 years) and then updated to use a new Linq-to-Entities data source, there was no regard for architecture, and all of the data access code was written directly in the code behind of the aspx pages. That's not even the real horror. I was getting (seemingly) random errors while trying to run it/understand it, and found that through-out all of the loads of Linq statements that all of the nullable types (e.g. Integer?, Double?, DateTime?, etc.) were being treated as if they were not nullable at all! Here is an example to help you understand (table/field names changed slightly to protect the guilty):

                      Dim partTransactionTypeThingsQuery As IQueryable(Of SomeTransactionRelatedItem) = \_
                                  From t In baseQuery
                                  Join tji In dataContext.OtherTransactionItems \_
                                      On tji.SomeTransactionID Equals t.ID
                                  Where (t.LastUpdatedDate >= startDate \_
                                         And t.LastUpdatedDate < endDate) \_
                                      And (tji.Type = "Part") \_
                                      And (tji.TotalDue <> 0)
                                  Select tji
                      

                      LastUpdatedDate is a Nullable(Of Date) and TotalDue is a Nullable(Of Double) and when it translates to SQL it will work just fine.. The problems come about when the context switches from Linq-To-Entities to Linq-To-Objects (I have to watch closely for a .ToArray() or .ToList() or anything else that executes the SQL and fetches results) and much of the aggregation is doing exactly that. I don't even know how many of these problems there are... Anyways, thanks for letting me rant a bit. Any suggestions? Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                      P Offline
                      P Offline
                      Paul Conrad
                      wrote on last edited by
                      #17

                      Sasha Laurel wrote:

                      Any suggestions? Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                      No, just consider it job security :rolleyes:

                      "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                      S 1 Reply Last reply
                      0
                      • P Paul Conrad

                        Sasha Laurel wrote:

                        Any suggestions? Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                        No, just consider it job security :rolleyes:

                        "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                        S Offline
                        S Offline
                        Sasha Laurel
                        wrote on last edited by
                        #18

                        Job Security! Just the positive spin that I needed. Thank you sir!

                        P K 2 Replies Last reply
                        0
                        • S Sasha Laurel

                          Job Security! Just the positive spin that I needed. Thank you sir!

                          P Offline
                          P Offline
                          Paul Conrad
                          wrote on last edited by
                          #19

                          Sasha, you might have to keep reminding higher up management that it will take time to eventually get it all taken care of if they start playing whiny games about it taking time.

                          "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

                          1 Reply Last reply
                          0
                          • S Sasha Laurel

                            Another project from our "star" developer who is apparently beyond contempt in every way. I was given this website (an ASP.Net Webforms project written in VB10) to add some additional metrics. To my horror I found that even though written very recently (within the last 2-3 years) and then updated to use a new Linq-to-Entities data source, there was no regard for architecture, and all of the data access code was written directly in the code behind of the aspx pages. That's not even the real horror. I was getting (seemingly) random errors while trying to run it/understand it, and found that through-out all of the loads of Linq statements that all of the nullable types (e.g. Integer?, Double?, DateTime?, etc.) were being treated as if they were not nullable at all! Here is an example to help you understand (table/field names changed slightly to protect the guilty):

                            Dim partTransactionTypeThingsQuery As IQueryable(Of SomeTransactionRelatedItem) = \_
                                        From t In baseQuery
                                        Join tji In dataContext.OtherTransactionItems \_
                                            On tji.SomeTransactionID Equals t.ID
                                        Where (t.LastUpdatedDate >= startDate \_
                                               And t.LastUpdatedDate < endDate) \_
                                            And (tji.Type = "Part") \_
                                            And (tji.TotalDue <> 0)
                                        Select tji
                            

                            LastUpdatedDate is a Nullable(Of Date) and TotalDue is a Nullable(Of Double) and when it translates to SQL it will work just fine.. The problems come about when the context switches from Linq-To-Entities to Linq-To-Objects (I have to watch closely for a .ToArray() or .ToList() or anything else that executes the SQL and fetches results) and much of the aggregation is doing exactly that. I don't even know how many of these problems there are... Anyways, thanks for letting me rant a bit. Any suggestions? Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                            K Offline
                            K Offline
                            KP Lee
                            wrote on last edited by
                            #20

                            Sasha Laurel wrote:

                            Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                            Depends on what you call viable. If you want to get out of this problem as quickly as possible, no matter the cost, then yes. Personally, I'd say the cost is too high to consider it. :-D (That's disregarding the subsequent funeral costs you'll impose on someone else.) PS your quote had really weird markups that I haven't seen code project do before. I stripped the verbose "span" markup surrounding every lower-case "i" in your note.

                            S 1 Reply Last reply
                            0
                            • S Sasha Laurel

                              Job Security! Just the positive spin that I needed. Thank you sir!

                              K Offline
                              K Offline
                              KP Lee
                              wrote on last edited by
                              #21

                              The problem with Job Security is: There isn't a reliable method found, that does so. (At least any that I know of.) Just ask the tons of unemployed programmers who wrote unreadable code to get it.

                              S 1 Reply Last reply
                              0
                              • S Sasha Laurel

                                Quote:

                                You are wrong. VB is the problem.

                                I'm afraid not. Go ahead and open your mouth and insert your shoe. In this case it is a combination of ignorance and arrogance that is the problem (something that you also seem to be displaying by this comment). Since you know so much about the culture of my workplace, why don't you expound upon that?

                                L Offline
                                L Offline
                                Lost User
                                wrote on last edited by
                                #22

                                Sasha Laurel wrote:

                                Go ahead and open your mouth and insert your shoe

                                No, thank you. But I would like to test Newton's third law. How would you like it? Shall I take that shoe and let it collide with your rear side or shall I just keep writing? What I did say was, that VB was always advertised as 'easy to learn' and 'ideal for beginners'. If I may translate that: If you are too lazy to learn or too dumb for anything else, then use VB. What I did not say was that all people who use VB are of that kind. Anyway, what you call arrogance is what I call self defense. I do not think that I can stop an army of the lazy and the dumb from doing vtheir evil, and therefore I do not preach. What I do is to stay away from them and not allow them to drag me into their desasters. It's remarkable how often things turned ugly when I did not manage to avoid VB. Indeed I just have to look into source control, my bosses' chamber of horrors, to find 10+ years of madness. It was of course the bosses' pointy-hairedness that got them into this in the first place. It took some years for them to realize that it might help if they hire developers that actually learned their job. It's amazing how many of those failures were written in VB, or perfectly good projects converted to VB and then mercilessly butchered. Or former VB 'developers' who had turned 'professional' and looked for new places to commit the same old sins. The only projects that showed a better quality were programmed in C++, which does not have the reputation to be 'easy to learn' or 'ideal for beginners'. What a coincidence.

                                Sasha Laurel wrote:

                                Since you know so much about the culture of my workplace, why don't you expound upon that?

                                For your sake, I hope that this is the culture of your workspace. For my part, I prefer to be called ignorant and arrogant before voluntarily getting myself into such a mess. At least that helped me to get together a longer list of projects that did not fail, which I can arrogantly point to. The irony is , that VB has evolved to a point where it had become usable, but less so its greatest users and supporters.

                                At least artificial intelligence already is superior to natural stupidity

                                S 1 Reply Last reply
                                0
                                • K KP Lee

                                  The problem with Job Security is: There isn't a reliable method found, that does so. (At least any that I know of.) Just ask the tons of unemployed programmers who wrote unreadable code to get it.

                                  S Offline
                                  S Offline
                                  SortaCore
                                  wrote on last edited by
                                  #23

                                  If you want job security, be an ninja. You can pretend you were nowhere near any bad incidents or right in the middle of good ones.

                                  1 Reply Last reply
                                  0
                                  • L Lost User

                                    Sasha Laurel wrote:

                                    Go ahead and open your mouth and insert your shoe

                                    No, thank you. But I would like to test Newton's third law. How would you like it? Shall I take that shoe and let it collide with your rear side or shall I just keep writing? What I did say was, that VB was always advertised as 'easy to learn' and 'ideal for beginners'. If I may translate that: If you are too lazy to learn or too dumb for anything else, then use VB. What I did not say was that all people who use VB are of that kind. Anyway, what you call arrogance is what I call self defense. I do not think that I can stop an army of the lazy and the dumb from doing vtheir evil, and therefore I do not preach. What I do is to stay away from them and not allow them to drag me into their desasters. It's remarkable how often things turned ugly when I did not manage to avoid VB. Indeed I just have to look into source control, my bosses' chamber of horrors, to find 10+ years of madness. It was of course the bosses' pointy-hairedness that got them into this in the first place. It took some years for them to realize that it might help if they hire developers that actually learned their job. It's amazing how many of those failures were written in VB, or perfectly good projects converted to VB and then mercilessly butchered. Or former VB 'developers' who had turned 'professional' and looked for new places to commit the same old sins. The only projects that showed a better quality were programmed in C++, which does not have the reputation to be 'easy to learn' or 'ideal for beginners'. What a coincidence.

                                    Sasha Laurel wrote:

                                    Since you know so much about the culture of my workplace, why don't you expound upon that?

                                    For your sake, I hope that this is the culture of your workspace. For my part, I prefer to be called ignorant and arrogant before voluntarily getting myself into such a mess. At least that helped me to get together a longer list of projects that did not fail, which I can arrogantly point to. The irony is , that VB has evolved to a point where it had become usable, but less so its greatest users and supporters.

                                    At least artificial intelligence already is superior to natural stupidity

                                    S Offline
                                    S Offline
                                    Sasha Laurel
                                    wrote on last edited by
                                    #24

                                    Quote:

                                    Shall I take that shoe and let it collide with your rear side

                                    The "foot in mouth" thing is figurative, but since you seem to be speaking literally, I would hate to deprive you of the opportunity. I live in Salt Lake City, UT near Liberty Park. We can meet at that park at any time of your choosing where we can test Newton's third law to your hearts content. As long as we can agree that you've conceded your point that "VB is the problem" by saying that the real problem is the devs who never get past it, then I don't think we are in disagreement at all. As a side note, you can attack VB6 and prior all you want, I don't even care if you make silly blanket statements about those versions.

                                    Quote:

                                    For your sake, I hope that this is the culture of your workspace.

                                    In my defense, I didn't really have any better options at the time. I would prefer to work in an environment that "separates the men from the boys" so to speak, but for now, that will just have to wait. Even still, we have plenty of very successful products, all written in some form of VB (mostly .Net). You come across as very angry and mean, so if I offended you please accept my apologies. I'll rescind my comment about you being ignorant and arrogant, as long as it is fully obvious that you are neither.

                                    L 1 Reply Last reply
                                    0
                                    • K KP Lee

                                      Sasha Laurel wrote:

                                      Is suicide a viable alternative to fixing thousands of lines of VB Linq statements of this nature?

                                      Depends on what you call viable. If you want to get out of this problem as quickly as possible, no matter the cost, then yes. Personally, I'd say the cost is too high to consider it. :-D (That's disregarding the subsequent funeral costs you'll impose on someone else.) PS your quote had really weird markups that I haven't seen code project do before. I stripped the verbose "span" markup surrounding every lower-case "i" in your note.

                                      S Offline
                                      S Offline
                                      Sasha Laurel
                                      wrote on last edited by
                                      #25

                                      You make me realize that I sound extremely insensitive to people you who really are suicidal. OOPS! No offense intended. As for the weird markup, my company targets IE as our main browser, so a lot of the time I'm in IE tab for chrome. I wonder if it has something to do with that?

                                      K 1 Reply Last reply
                                      0
                                      • S Sasha Laurel

                                        Quote:

                                        Shall I take that shoe and let it collide with your rear side

                                        The "foot in mouth" thing is figurative, but since you seem to be speaking literally, I would hate to deprive you of the opportunity. I live in Salt Lake City, UT near Liberty Park. We can meet at that park at any time of your choosing where we can test Newton's third law to your hearts content. As long as we can agree that you've conceded your point that "VB is the problem" by saying that the real problem is the devs who never get past it, then I don't think we are in disagreement at all. As a side note, you can attack VB6 and prior all you want, I don't even care if you make silly blanket statements about those versions.

                                        Quote:

                                        For your sake, I hope that this is the culture of your workspace.

                                        In my defense, I didn't really have any better options at the time. I would prefer to work in an environment that "separates the men from the boys" so to speak, but for now, that will just have to wait. Even still, we have plenty of very successful products, all written in some form of VB (mostly .Net). You come across as very angry and mean, so if I offended you please accept my apologies. I'll rescind my comment about you being ignorant and arrogant, as long as it is fully obvious that you are neither.

                                        L Offline
                                        L Offline
                                        Lost User
                                        wrote on last edited by
                                        #26

                                        You are right. Time to stop. It's been 32 years since I have been in Salt Lake City and if I hop into a plane to fly half way around the world, then I would hopefully come up with a better reason. And no, you did not offend me. When somebody has a problem, he can come right in. Then we close the door and we will never lose a word again about anything that will be said in the next ten minutes. It may be unfair and certainly impolite, but that does not matter. With those things out of the way it's usually no big deal anymore to figure out what to do.

                                        Sasha Laurel wrote:

                                        As long as we can agree that you've conceded your point that "VB is the problem" by saying that the real problem is the devs who never get past it, then I don't think we are in disagreement at all.

                                        Ok, lets agree on that.

                                        Sasha Laurel wrote:

                                        As a side note, you can attack VB6 and prior all you want, I don't even care if you make silly blanket statements about those versions.

                                        No need for that. I don't like to make a religion out of my work and don't want to participate in any holy war over it.

                                        Sasha Laurel wrote:

                                        You come across as very angry and mean

                                        Angry, yes, but not at you. I did not really notice that I had built up so much steam, but now I'm back on my way to change this.

                                        At least artificial intelligence already is superior to natural stupidity

                                        S 1 Reply Last reply
                                        0
                                        • S Sasha Laurel

                                          You make me realize that I sound extremely insensitive to people you who really are suicidal. OOPS! No offense intended. As for the weird markup, my company targets IE as our main browser, so a lot of the time I'm in IE tab for chrome. I wonder if it has something to do with that?

                                          K Offline
                                          K Offline
                                          KP Lee
                                          wrote on last edited by
                                          #27

                                          Sasha Laurel wrote:

                                          you really are suicidal

                                          That threw me for a bit. What did I say to make you think I was suicidal? Then because of context I realized "you" should have been "who". :) Today I'm following a bug, no real detail on how to get there so I "best guess" it. This it a multiple pull-down app. Pick something at random. Code blows up, try-catch retrieves the error. Tried to retrieve a value from a nullable datetime field. Threw the error because the field was null. Looks like 94% of the choices leads to that. Start a SQL trace, it goes there when it starts up, but doesn't when I make my pick and blows up. So the code should be able to know what it can allow and modify the pull-downs to match. It's doing it elsewhere in the same pull-downs. Just one more area where the code isn't helpful. (Especially when I'm fairly new and don't really know what is meant by "2012-01-23-D2302-Private-Repro-Attempt-7-v-brleon") OK, it's dated, by a specific person, created while looking into something. But what's really important is that I've picked a type of report that should have allowed me to pick 26 of the 428 selections that should work. That or replace the null date with today's date in the other 400 possibles.

                                          S 2 Replies Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups