For example, lets say I have an SQLite database running and it has a table called Users and in that table are 3 columns called UID, Name, Active and UID is the primary
auto incremented key.
Again forgive my newbishness with programming SQL here put Im looking for something that will allow me to just execute querys and get a response.
Something like this....
- Code: Select all
Dim result as string
result = Run("select * from Name where UID = 2") 'this would return the name associated with UID 2
The problem for me is that I cannot seem to understand what the language needs in order to do this. My database will be simple, nothing over the top, it will store nutritional information (Item Name, Calories, Fat, Carbs, Protein and such with a UID for each and a session number) However the process to get data seems convoluted to me, but perhaps its because I'm simply not understanding. Can someone give me a very simple example of executing a query and retrieving the string or integer data?