مشكله تصميم قاعده بيانات

مغلق

بدأه محمد عبدالحليم المغربى في 23 مايو 2007 · 2 رد · 627 مشاهدة · في قواعد بيانات Microsoft SQL Server

#123 مايو 2007 في 14:27 صاحب الموضوع

Good morning

In messages system i have table to store messages and another table to contain the links which the message is posted through

Now i want to delete a link but i don't want to delete the message sent through this link

The problem:

When displaying the message sent what will be fount in the link field (i.e for the deleted link)

I tried to move the deleted link data to separate table (EX: deletedLink) but if the user added new link with the same name as the deleted link? The problem mainly in when displaying the message sent i will have the same link twice one for the deleted and the other for the added one.

If any one has a good idea for doing that please reply to me

I don’t want the sql code

I want just the idea

Thanks

thanks

Kind Regards

Mohammed Al maghraby

Software Developer

Mobile : 016 333 658 1

#223 مايو 2007 في 22:21

make inner join between messages and links

the deleted links will not be in the table links so they will not return messages in the result

this solution depends on the design of your database i.e there must be a relation between the two tables

if this does not solve the problem try to post the tables design

مدونتي

استضافة مواقع asp.net :.Net 3.5,4,4.5, MVC2 & 3,SQL server 2008 R2, Crystal reports

#324 مايو 2007 في 09:59

شكرا على الاهتمام

لو انا مسحت link و هناك رسائل تستخدم هذا ال link المفروض ان انا لما اظهر تقرير عن الرسائل اللى اتبعتت يظهر لى اللينك اللى اتبعت عليه الرساله فا السؤال ........................ منين اقدر اجيب الداتا بتاعت ال link اللى انا مسحته

و شكرا