>Hi, folks...
>
>I heard recently (I haven't checked it out myself) that SQL Server 2000 has a new data type that's actually a function...in other words, you can write code (I'm guessing it's similar to SQL/VB syntax).
>
>The person I heard it from was actually positioning this as an alterative to writing components/business objects in the middle tier...that there would be advantages to doing it this way.
>
>I find it hard to believe...our current 'fat' app has the infamous 'ton' of VFP/procedural code in the way of validations, and it just seems better to me to put that stuff in the middle tier using VFP than try to fit it in the manner I heard about.
>
>Any comments?
>
>Thanks,
>Kevin
SQL 2000 has all of the "standard" data types and a couple of "oddities" (CURSOR and TABLE) but nothing like what you describe. It does have the ability to create user-defined functions, which can serve as default values for columns - maybe that was what they were thinking of?
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.