While I don't know of a limit off hand there may be one depending on your database (some databases do have a limit to the size of the where clause)
Having the actual error (and what db you are on) would allow someone to give you a definitive answer Fred From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brian Goralczyk Sent: Wednesday, November 27, 2013 11:05 AM To: [email protected] Subject: Re: Table field qualification length restrictions ** Lisa, I could certainly complete the process another way. But since this is an a current issue I am not looking to redesign it unless I have to. That is why I am asking about a limitation in the field length of the qualification rather than how to redesign it. And the error isn't a Remedy telling me the field is too long error. It is more obscure. This request is more to see if anyone else has ran into a length issue and might know what it is. But thank you for the suggestion. Brian Goralczyk -----Original Message----- On Wed, Nov 27, 2013 at 10:12 AM, Kemes, Lisa A DLA CTR INFORMATION OPERATIONS wrote: Can you do this same qualification in a simple search or do you get the same error. Maybe show us the qualification as well. Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Brian Goralczyk Sent: Wednesday, November 27, 2013 10:37 AM To: [email protected]<mailto:[email protected]> Subject: Table field qualification length restrictions ** I have an issue that I am tracking down and I think a possible point of issue is the table field qualification. We are using a text field that is a compilation of data. We are then doing a "contains" qualification check against that field. When we hit a field length of just under 2000 characters ( I know that is a lot ) it seems to give an obscure error. I don't have the error in front of me so I can't include it, which I know might help someone figure out the issue for me, but my real question is, does anyone know of a length limitation on the table field's qualification and does external impact that at all? Any advice or guidance on this would help. It is mostly for us to decide if we have to rewrite that process now (urgently) or later (not the issue). Thanks all, Brian Goralczyk _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
