Re: Enforcing Data Format

> I'd go the other way and use a trigger to validate the data, and roll > back the transaction if it isn't in valid format (assuming you are using > transactions). This way, ANY app that puts data in that field gets the > validation. An error in an application or typing by someone who has > dire

Re: Enforcing Data Format

I'd go the other way and use a trigger to validate the data, and roll back the transaction if it isn't in valid format (assuming you are using transactions). This way, ANY app that puts data in that field gets the validation. An error in an application or typing by someone who has direct table

Re: Enforcing Data Format

> > > > Is it possible to enforce data formatting in fields using > > something like > > > a regular expression? > > > varchar is great but does not stop someone putting in the wrong > > > reference number. > > > > Dates should be in a DATE column, not a varchar. > > The OP says 'data' not 'date'

RE: Enforcing Data Format

> > Is it possible to enforce data formatting in fields using > something like > > a regular expression? > > varchar is great but does not stop someone putting in the wrong > > reference number. > > Dates should be in a DATE column, not a varchar. The OP says 'data' not 'date' :) He is talking ab

Re: Enforcing Data Format

On Thu, May 3, 2007 12:56, Tim Milstead wrote: > Hello, > > Is it possible to enforce data formatting in fields using something like > a regular expression? > varchar is great but does not stop someone putting in the wrong > reference number. > I suspect the answer is no, you have to do it at a hi

Re: Enforcing Data Format

> Is it possible to enforce data formatting in fields using something like > a regular expression? > varchar is great but does not stop someone putting in the wrong > reference number. Dates should be in a DATE column, not a varchar. > I suspect the answer is no, you have to do it at a higher

Re: Enforcing Data Format

Baron Schwartz wrote: Hi, Tim Milstead wrote: Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher le

Re: Enforcing Data Format

Hi, Tim Milstead wrote: Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher level. What aprroach would

Enforcing Data Format

Hello, Is it possible to enforce data formatting in fields using something like a regular expression? varchar is great but does not stop someone putting in the wrong reference number. I suspect the answer is no, you have to do it at a higher level. What aprroach would people suggest? Perhaps