Computing.Net > Forums > Programming > SQL help?

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

SQL help?

Reply to Message Icon

Original Message
Name: Anders
Date: May 14, 2003 at 14:37:21 Pacific
Subject: SQL help?
OS: xp
CPU/Ram: 256
Comment:

Lets say I have 2 tabels. tbl_Customer and tbl_Profile. I have a PK called cust_ID and a FK in tbl_profile called cust_IDRef. A customer may noly have 3 Profiles, if he tries to add another profile he is not allowed.

Hmmm, hope you understood it.

How do I do this???
Thx in advance...


Report Offensive Message For Removal


Response Number 1
Name: Don Arnett
Date: May 15, 2003 at 16:44:42 Pacific
Reply:

I don't think that you can do this (prevent a forth profile being added) strictly thru SQL.

You'd have to write a script or program (maybe a trigger or stored procedure) that checks the number of existing profiles before adding a new profile.


Report Offensive Follow Up For Removal







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home



Results for: SQL help?

SQL Help
    Summary: I have this series of SQL statements could someone please simple explain what each line does. I know what this does but i am not sure about how it is achieved. The SQL statements orders the table in D...
www.computing.net/answers/programming/sql-help/6312.html

SQL Help!
    Summary: Hi, I have a simple SQL problem here. Currently I have 2 tables (A & B, let say) within my SQL database. I want to append all the records (5 fields, 10+ rows, let say) from the table A into table B, ...
www.computing.net/answers/programming/sql-help/10974.html

SQL help plesae
    Summary: Hello helper I need help with the sql code. I need the sql to get information that is unique. For example if i have {1,2,3,4,4,5,6,6,7} in a column. the output should be {1,2,3,5,7}. now i would not...
www.computing.net/answers/programming/sql-help-plesae/12325.html








Which MP3 player do you have?

iPod/iPhone
Zune
Something Else
None


View Results

Poll Finishes In 2 Days.
Discuss in The Lounge
Poll History






Data Recovery Software