Posted 30 July 2011 - 08:55 PM
I'm creating a text based RPG game as a school project, and im having difficulties calling data from an mdb file.
I've set it all up as a data connection, and what I need to do is be able to do is retrieve a certain entity from the database according to a predefined variable. I can't find any tutorials that will let me retrieve a single field, only whole rows, or whole databases into data grids.
There'd be no writing to the database, only extraction of data. I'd assume it could be done using SQL in vb, but im not sure.
So theoretically, what i'd like to be able to do is:
-i set an id number as a variable, say 17 for example.
-the routine then searches down the "id" field till it finds "17"
-The routine goes across the record to the "script" field, withdraws that data and puts it into a string, and does so for a few other fields also.
Any advice as to how i'd go abouts doing this?
KIRBY <3's YOU :D
(>*.*)> ♥ <(*.*<)