Will anyone help me with my project?

[SnakeZ]

Hey guys the list not working so i am taking it of from my program. I got tomorrow morning to hand this up.

Anyhow i have built two programs. Could you guys look at it and tell me which one i should go with.


PROGRAM #1:

DECLARE SUB editvid ()
DECLARE SUB addvid ()
DECLARE SUB delvid ()
DECLARE SUB listvid ()
DECLARE SUB searchvid ()
DECLARE SUB LEAVE ()
DECLARE SUB mainmenu ()
TYPE videotype
id AS INTEGER
vidname AS STRING * 100
vidgenre AS STRING * 100
vidactor AS STRING * 100
vidratin AS STRING * 2

END TYPE
DIM vid AS videotype





CLS
mainmenu

SUB addvid
COLOR 2


DIM vid AS videotype
CLS

OPEN "vid.id" FOR RANDOM AS #1 LEN = LEN(vid)



DO UNTIL response$ = "n"
INPUT "please enter video's barcode number", number
vid.id = number

INPUT "enter name of video", vid.vidname

INPUT "enter main actor of film", vid.vidactor

INPUT "enter rating of video ?/10 ", vid.vidratin

INPUT "enter genre of the movie being borrowed", vid.vidgenre


PRINT "you added a new video"
PUT #1, vid.id, vid


INPUT "do you want to add any another videos? y-Yes, n-No ", response$
LOOP
CLOSE #1

END SUB

SUB delvid
DIM vid AS videotype
CLS
OPEN "vid.id" FOR RANDOM AS #1 LEN = LEN(vid)
DO UNTIL response$ = "n"
INPUT "please enter video's bar code number", number
vid.id = number


GET #1, vid.id, vid


PRINT "This is the video's name", vid.vidname

PRINT " this is the video's main actor", vid.vidactor

PRINT "this is the video's rating", vid.vidratin

PRINT "this is the video's genre", vid.vidgenre

INPUT "do you wish to delete the record?y/n", responset$
IF responset$ = "y" THEN


vid.vidname = ""
vid.vidactor = ""
vid.vidratin = ""
vid.vidgenre = ""
PUT #1, vid.id, vid

PRINT "You deleted the record"

ELSE
PRINT "You cancelled the delete"


END IF

INPUT "do you want to delete any other records?", response$

LOOP
CLOSE #1

END SUB

SUB editvid
DIM vid AS videotype
CLS
OPEN "vid.id" FOR RANDOM AS #1 LEN = LEN(vid)
DO UNTIL response$ = "n"
INPUT "please enter video's bar code number", number
vid.id = number

GET #1, vid.id, vid


PRINT "This is the video's name", vid.vidname
PRINT " this is the video's main actor", vid.vidactor
PRINT "this is the video's rating", vid.vidratin
PRINT "this is the video's genre", vid.vidgenre


INPUT "do you wish to edit the record?y/n", responset$
IF responset$ = "y" THEN


vid.vidname = ""
vid.vidactor = ""
vid.vidratin = ""
vid.vidgenre = ""
PUT #1, vid.id, vid
INPUT "edit the name of video", vid.vidname
INPUT "edit the actor of the video", vid.vidactor
INPUT "edit the rating of the video", vid.vidratin
INPUT "edit the genre of the video", vid.vidgenre
PUT #1, vid.id, vid

ELSE
PRINT "You decided not to edit the record"

END IF

INPUT "do you want to edit any other records?", response$

LOOP
CLOSE #1

END SUB

SUB LEAVE
COLOR 9
PRINT "Goodbye user!!!!!"
PRINT "Come Back Soon"

END SUB

SUB listvid


END SUB

SUB mainmenu
COLOR 10


20 PRINT "WELCOME TO VIDEOTRONICS V1.0 DATABASE"
PRINT "Please Select an Option from below"
PRINT "1 - Add a new video"
PRINT "2 - Delete a video that was lent to the customer"
PRINT "3 - List all videos in stock"
PRINT "4 - search a video"
PRINT "5 - Edit video details"
PRINT "6 - EXIT DATABASE "
100 INPUT C
SELECT CASE C
CASE IS = 1
addvid
CLS
GOTO 20
CASE IS = 2
delvid
CLS
GOTO 20
CASE IS = 3
listvid
CLS
GOTO 20
CASE IS = 4
searchvid
CLS
GOTO 20
CASE IS = 5
editvid
CLS
GOTO 20
CASE IS = 6
LEAVE
CASE ELSE
PRINT "You inserted an invalid option"
GOTO 100
260 END SELECT


END SUB

SUB searchvid
DIM vid AS videotype
CLS
DO UNTIL response$ = "n"
INPUT "please enter video's bar code number", number
vid.id = number

OPEN "vid.id" FOR RANDOM AS #1 LEN = LEN(vid)
GET #1, vid.id, vid
CLOSE #1


PRINT "This is the video's name", vid.vidname
PRINT " this is the video's main actor", vid.vidactor
PRINT "this is the video's rating", vid.vidratin
PRINT "this is the video's genre", vid.vidgenre

INPUT " Do you wish to search for another record?", response$
LOOP
CLOSE #1

END SUB

Thats the one i have been showing you all here.



HERE IS PROGRAM #2


DECLARE SUB editvid ()
DECLARE SUB addvid ()
DECLARE SUB delvid ()
DECLARE SUB listvid ()
DECLARE SUB searchvid ()
DECLARE SUB LEAVE ()
DECLARE SUB mainmenu ()
TYPE videotype
id AS INTEGER
vidname AS STRING * 100
vidgenre AS STRING * 25
vidactor AS STRING * 50
vidratin AS STRING * 2
END TYPE
DIM vid AS videotype
CLS
mainmenu

SUB addvid
COLOR 2
DIM videos AS videotype
CLS
OPEN "videos.dat" FOR RANDOM AS #1 LEN = LEN(videos)
DO UNTIL response$ = "n"
INPUT "please enter video's barcode number", number
videos.id = number

INPUT "Enter name of video", videos.vidname
INPUT "Enter main actor of film", videos.vidactor
INPUT "Enter rating of the video ?/10", videos.vidratin
INPUT "Enter genre of the video", videos.vidgenre
PRINT "You added a record"
PUT #1, videos.id, videos
INPUT "do you want to add another videos? y-Yes, n-No", response$
LOOP
CLOSE #1

END SUB

SUB delvid
DIM videos AS videotype
CLS
OPEN "videos.dat" FOR RANDOM AS #1 LEN = LEN(videos)
DO UNTIL response$ = "n"
INPUT "Please enter video's barcode number", number
videos.id = number
GET #1, videos.id, videos

PRINT "This is the video's name", videos.vidname
PRINT "This is the video's main actor", videos.vidactor
PRINT "This is the video's rating", videos.vidratin
PRINT "This is the video's genre", videos.vidgenre

INPUT "do you wish to delete the record? y/n", responset$
IF responset$ = "y" THEN

videos.vidname = ""
videos.vidactor = ""
videos.vidratin = ""
videos.vidgenre = ""
PUT #1, videos.id, videos
PRINT "You deleted the record"
ELSE
PRINT "you cancelled the delete"
END IF

INPUT " do you wish to delete any other records?", response$
LOOP
CLOSE #1

END SUB

SUB editvid
DIM videos AS videotype
CLS
OPEN "videos.dat" FOR RANDOM AS #1 LEN = LEN(videos)
DO UNTIL response$ = "n"
INPUT "Please enter video's barcode number", number
videos.id = number
GET #1, videos.id, videos

PRINT "This is the video's name", videos.vidname
PRINT "This is the video's main actor", videos.vidactor
PRINT "This is the video's rating", videos.vidratin
PRINT "This is the video's genre", videos.vidgenre

INPUT "do you wish to edit the record? y/n", responset$
IF responset$ = "y" THEN

videos.vidname = ""
videos.vidactor = ""
videos.vidratin = ""
videos.vidgenre = ""
PUT #1, videos.id, videos
INPUT "Enter the name of the video", videos.vidname
INPUT "Enter the main actor of the video", videos.vidname
INPUT "Enter the rating of the video", videos.vidratin
INPUT "Enter the genre of the video", videos.vidgenre
PUT #1, videos.id, videos
ELSE
PRINT "You decided not to edit the record"
END IF
INPUT "Do you want to edit any other records? y/n", response$
LOOP
CLOSE #1

END SUB

SUB LEAVE
COLOR 9
PRINT "Goodbye User"
PRINT "Come back soon"
END SUB

SUB listvid
END SUB

SUB mainmenu
COLOR 10
20 PRINT "WELCOME TO VIDEOTRONICS V1.0 DATABSE"
PRINT "Please select an option from below"
PRINT "1 - Add a new video"
PRINT "2 - Delete a video"
PRINT "3 - List all videos in stock"
PRINT "4 - Search a video"
PRINT "5 - Edit video details"
PRINT "6 - Exit Database"
100 INPUT c
SELECT CASE c
CASE IS = 1
addvid
CLS
GOTO 20
CASE IS = 2
delvid
CLS
GOTO 20
CASE IS = 3
listvid
CLS
GOTO 20
CASE IS = 4
searchvid
CLS
GOTO 20
CASE IS = 5
editvid
CLS
GOTO 20
CASE IS = 6
LEAVE
CASE ELSE
PRINT "You inserted an invalid option"
GOTO 100
260 END SELECT

END SUB

SUB searchvid
DIM videos AS videotype
CLS
OPEN "videos.dat" FOR RANDOM AS #1 LEN = LEN(videos)
DO UNTIL response$ = "n"
INPUT "Please enter video's barcode number", number
videos.id = number
GET #1, videos.id, videos
PRINT "This is the video's name", videos.vidname
PRINT "this is the video's main actor", videos.vidactor
PRINT "This is the video's rating", videos.vidratin
PRINT "This is the video's genre", videos.vidgenre
INPUT "Would you like to search for another record", response$
LOOP
CLOSE #1


END SUB





which one has less chance of crashing on me.
Please reply ASAP and tell me which one i should go with!!!!

I like the second one.

Meg thanks for all your help.

[Meg]

I've said this at least three times already. This is the last time I'll mention it. After that, you're on your own:

BAD BAD BAD BAD BAD BAD BAD BAD

Code:

DO
OPEN
LOOP
CLOSE

BAD BAD BAD BAD BAD BAD BAD BAD

GOOD GOOD GOOD GOOD GOOD GOOD

Code:

DO
OPEN
CLOSE
LOOP

GOOD GOOD GOOD GOOD GOOD GOOD

or...

GOOD GOOD GOOD GOOD GOOD GOOD

Code:

OPEN
DO
LOOP
CLOSE

GOOD GOOD GOOD GOOD GOOD GOOD

*peace*

Meg.

[Meg]

Soo.. how'd the project turn out?

*peace*

Meg.

[SnakeZ]

Well it turned out really well.

I got the full 5 marks for my program and i got 37/40 in the entire project.

I forgot to do the dataflow diagram. (blasted 3 marks, i had total marks!!!)

It was the highest in the class.

Meg thank you for all of your help. I don't think i could have one it without your hints.

Hey now that the project is over, would you be willing to teach me some more stuff at Q-Basic?? I would really love to learn everything about it.

[Rattrapmax6]

Why not FB, its the next and newest basic language,. very nice... :wink:

[SnakeZ]

Okay i will look into it.

But there is one thing i wish to know. Could you all help me do out the last sub, the list sub. Could you give me a tip on how to do it??
I wanna make sure i can do that as well so i can knwo to myself i know how to make a database.

[dumbledore]

lol some people never learn...

Code:

SUB listvid

DIM vid AS videotype
boxnumber = 1
OPEN "vid.id" FOR RANDOM AS #1 LEN = LEN(vid)
DO UNTIL EOF(1)
GET #1, boxnumber, vid
IF vid.vidname <> "" THEN
PRINT "This is the video's barcode number", vid.id
PRINT "this is the video's name", vid.vidname
END IF
boxnumber = boxnumber + 1
LOOP
CLOSE #1


END SUB

you gotta put your open statement outside the do loop.

either move the OPEN command above the DO command, or move the CLOSE command above the LOOP command. Otherwise, [...] your program will crash.

[SnakeZ]

With that boxnumber i keep getting erros.

It is listing everything i store but the problem here is that it is not allowing me to stop. i Have tried several things and it still doesn't work. How should i update it. I cant seem to get it.

[Pyrokid]

Well it turned out really well.

I got the full 5 marks for my program and i got 37/40 in the entire project.

I forgot to do the dataflow diagram. (blasted 3 marks, i had total marks!!!)

It was the highest in the class.

Ha thats kinda funny because i couldve wrote that in an hour
damn i wish they had that class where i am... i feel deprived

[SnakeZ]

Please note that the program was only for five marks. I got marks for the other contents.

Hey guys on May 24TH i got my GCE exam coming. Any tips??