HI there a newbie here in Visual Basic i just wanted to ask something, on how can compare records in a particular field in my table... I'am develop a time scheduling system, its like for example i have a table name called RECORDS that has a 5 fields namely, TIME START, TIME END ,DAYS,ROOM. i want to compare all records that has been save in the RECORDS to be able to test if there a conflict on it,,, first hing i wanted to is to test if there equal values of records.
Example, the first record that has been saved has the follwing:
TIME START: 7:00 AM, TIME END 8:00 AM, DAYS: MWF, ROOM: 101.
then the second record that has been save is exactly equal to the first record.
the question how i can prevent this sql statement, what is advisable to use LIKE or COMPARE...
Can somebody tell me or site some ideas on how to solve this problem:
And lastly
am using this code:
Select * from RECORDS where TIME START, TIME END, DAYS, ROOM (this is the part i dont know).. i hope someone here can help me.
Thank you very much.... and God Bless...
Example, the first record that has been saved has the follwing:
TIME START: 7:00 AM, TIME END 8:00 AM, DAYS: MWF, ROOM: 101.
then the second record that has been save is exactly equal to the first record.
the question how i can prevent this sql statement, what is advisable to use LIKE or COMPARE...
Can somebody tell me or site some ideas on how to solve this problem:
And lastly
am using this code:
Select * from RECORDS where TIME START, TIME END, DAYS, ROOM (this is the part i dont know).. i hope someone here can help me.
Thank you very much.... and God Bless...
Comment