Page 1 of 1
database
Posted: Thu Jul 07, 2005 2:47 am
by sid6.7
does anyone know where an example of a database program
made in qb is? to look at it for examples of input, search
edit?
Posted: Thu Jul 07, 2005 6:11 am
by MystikShadows
Hi sid,
if you go here:
http://www.petesqbsite.com/sections/exp ... index.html
and click on my tutorial on file manipulation random access file I wrote a small database program there, a contact manager. I think you'll find it's a good start to what you want to do
Hope this helps
hmmm
Posted: Thu Jul 07, 2005 7:11 am
by guest-sid6.7
ah i think i see what i am not understanding well...
when something gets written or extracted from a file
you dont grab/write each piece of a record...I.E
put/get rec#,x, y, z, a, b, c, d
what you want to do is grab/put the WHOLE thing....I.E
put/get rec#,xyzabcd ?
if you want to do compares or editing of your data
you break it up after that with your variables then
work on it..
am i following you correctly?
thanks mystik...
oops
Posted: Thu Jul 07, 2005 7:15 am
by sid6.7-guest
oh lord my brain may be actually working...
i think im gonna have to re-write a game i've been working
on for 2 years....if the above is true...SHEEP!!!
Posted: Thu Jul 07, 2005 9:46 am
by {Nathan}
A quote from my dad: "nothing on the internet is true"
Now I will prove him wronge...
TWO PLUS TWO EQUALS FOUR!!!!
Posted: Thu Jul 07, 2005 11:03 am
by MystikShadows
LOL anthan.
Sid, if you read my tutor then if you use a TYPE definition instead of individual fields it will make your coding life much easier

. Juust follow my example and you'll see it works great that way

Re: database
Posted: Thu Jul 07, 2005 6:59 pm
by moneo
sid6.7 wrote:does anyone know where an example of a database program
made in qb is? to look at it for examples of input, search
edit?
Maybe you don't need a database approach at all.
How many records do you have or expect to have as a maximum for this file?
What is the largest record that you need to use?
What is the size of the key that you'll be using?
Do you have multiple keys per record?
Can you have duplicate keys? That is, the same key for different records?
The answer to these questions will determine whether you need to use a database. Answer them and I'll do an analysis for you.
*****