Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2004
    Northeast US

    Question Unanswered: "Domains" and "Types"

    I am trying to set up a database that seems cut out for an SQL "DOMAIN" -- fields that have a restricted syntax for validity and occur in several tables. So, I set the database up and all the CREATE WHATEVER commands appear to work. But, if I try entering any actual data into the tables I get rejected because some type -- generally named like the domain but cased differently or with '_' chars added -- doesn't exist.

    Obviously, I'm missing some critical aspect of DOMAINS! Casting functions seems likely, but mine would all be just an assign.

    Has anyone actually used domains or user-defined types?

    Has anyone even seen a decent tutorial or explanation of the durned things?
    Last edited by Superbiskit; 11-02-04 at 10:05.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts