|
You are designing a students database, make it a school database software something you can install in any school, easier to think that way.
Important to think about the structure, to avoid start from the begining, I am not sure about yours it seems ok, i don´t understand very well french
forget the code, talk a little more about the database, maybe i can help.
Good luck
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
thanks a lot nelsonpaixao merci bcp;
My database:
VALIDATION_MODULE (CODE_VALIDATION_MODULE ,........)
VALIDATION_SEMESTRE (CODE_VALIDATION_SEMESTRE ,........)
AVERAGE (NOTE_MODULE, CODE_MODULE #, # NUM_student, # CODE_VALIDATION_MODUE ,........)
final_average (NOTE_SEMESTRE, NUM_INSCRIPTION #, # CODE_SEMESTRE, # CODE_VALIDATION_semestre .......)
REVIEW (review, NUM_student #, # CODE_MATIERE)
STUDENT (NUM_student. .....)
FIELD [CODE_MATIERE, COEFFICIENT, # CODE_MODULE ........)
MODULE (CODE_MODULE, .. # CODE_SEMESTRE.)
semestre (CODE_SEMESTRE ,...)
i don't understand make it a school database software something you can install .
merci encore
|
|
|
|
|
i don´t know i can assist you here, try invest in the database structure to avoid you to start from the beginning later, you will get easier sp also.
i builted a videoclub (movie rental) project, i knew the structure i needed(major table was 'rents' that got who rented and what rented, 75% of store procedures feeded from that table), in your case i imagine but no sure of structure, they did gave you a check list, right?
For exemple i am accountant i can easely built a accountant software and give suggestions because i know the algorhitms, if it is of other kind i need assistance i needed a ckeck list of what they want and i will keep asking question all the time!!!
i mean school database software, didn´t you seen a videoclub, library, or other software? i mean that because you didn´t show no info besides students and grades, nothing of teachers or rooms etc, but it may be all you need you know.
Good luck, sorry couldn´t help
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi..
I have paradox database files I opened it using Access but the arabic text looks unreadable I changed the font to arabic but this was no use.Do you have any suggestion?
I am too late but i will never give up
|
|
|
|
|
It's probably the cultureinfo of the database rather than the font, fixing it - no idea sorry.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I set the collation for the database to arabic before migrating the database using DTS and the data still unreadable.I tried and copy the data to an email and send it to another employee in the company.In outlook He set the encoding to Arabic(Windows) and it becomes readeable.So I think I have two choices to solve the problem:
1-Set the Encoding in Access to Arabic(Windows):I couldn't find any Encoding settings in Access.
2-Set the Encoding in code for that field in the dataset.
Please if any one knows how to reach one of these solutions tell me about it.
I am too late but i will never give up
|
|
|
|
|
|
Here is google translator.[^]
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
"An error occurred connecting to SQL server 2005. Unable to accept remote connections."
What you need to do is run the SQL Server Configuration Manager and make sure that protocol TCP/IP is enabled. Try that.
|
|
|
|
|
an error as occurred when connection to the server.
while connecting sql server 2005, this error is likely to be caused by, according to sql server setting, remote connections are not allowed
(provider: ... -there was not possible to connect to sql server
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hi!
I had upgraded Visual Studio 2005 to 2008 and then upgraded SQL EXPRESS 2005 to SQL EXPRESS 2008. However, When I try to add a new "mdf" file under APP_Data directory. I am getting the following error message. How can I solve the problem? The Microsoft.Net Framework Version 3.5 SP1 and Microsoft SQL Server compact SP1 has been already installed.
ERROR MESSAGE
"Connections to SQL Server files (*.mdf) require SQL Server Express 2005"
Thanks.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
Did you try to search on google[^]before post here?
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Of course I did so that is why I decided to post the problem right here. You don't expect one to go and spend hours and hours the find the correct link related to problem in google right?
If you don't know the answer, please do not reply to my message.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
I know answer i am sure 100% but i wont give it to you.
Same problem i had too and i solved, so keep searching dude.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
I will keep searching and you will mess up the forums. (DUDE!)
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
No,you are messing up forum with your beginners questions.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Where does it indicated that the forums are not for beginners? show me the link!
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
The link is with this subject on question:
"How can I solve SQL EXPRESS 2005 problem in Visual Studio 2008?"
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Your aim is not to help the others in this forum, therefore do not post any more messages. Take a long walk. I think you are experiencing some sortf of behaviour problems.
What a curious mind needs to discover knowledge is noting else than a pin-hole.
|
|
|
|
|
|
if i use varchar(max) instead of varchar(50), and use "chandra" only , then will both give the same performance.
“You will never be a leader unless you first learn to follow and be led.”
–Tiorio
"Coming together is a beginning, staying together is progress, and working together is success." Henry Ford
|
|
|
|
|
I assume your question is 'will they give the same performance?' - if so the answer is yes.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
well,
i use varchar(max) for very long strings, that i don´t know the size
i use varchar(50) if i know the string never goes of that border
var means variable, so is from 0 to 50.
if you know you only need 3 chars you use char(3)
if you need 0,1,2 or 3 chars you use varchar(3)
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I just joined a company that uses SQL 7.0,which am not that much used too.
i can view 'code' for views with 'INFORMATION_SCHEMA.VIEWS
and can view triggers and other objects with 'sysobjects'
i want to view the code for the triggers in a particular table...
PLEASE HELP ME...THANKS
|
|
|
|
|
OK, so I have a table of businesses. Then I have a table of contacts. So, I have many contacts for the one business. I want to do a search, and use a contact name as a possible search. However, I don't ever want to return the same business more than once. So, I want to return each business that matches at least one contact, with any contact that matches. I've tried putting in a subquery so that I select the top 1 contact for a business, but I can't find a way to write SQL that works.
select
c.IDClient, c.Company, con.LastName + ', ' + con.FirstName as Contact, c.Phone, c.Fax
from tbl_client c
inner join tbl_client_contacts cc on cc.IDClient = c.IDClient
inner join tbl_contact con on con.IDContact = cc.IDContact
where con.IDContact = (select top 1 IDContact from tbl_client_contacts ccc where ccc.IDClient = c.IDClient)
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|