How to return a single value from a table?

[Decker87]

Hello. I have a table in OOo Base which has two columns, veh_make and veh_make_id. It looks something like this:
veh_make: Dodge, Mitsubishi, Honda, Toyota, Chevrolet
veh_make_id: 0, 1, 2, 3, 4

I want to set a variable equal to veh_make_id when given veh_make.
In other words, my macro can figure out that veh_make is "Toyota", but from this info I want to set another variable equal to 4. How can this be done?

In other words, I want to return the result of

[TerryE]

There are quite a few examples on this. Rather than me giving you specific ones, why not try searching for "SQL AND select" from this forum and from the Code Snippets forum and look at te examples discussed?
_________________
Terry
WinXPSP3, OOo 2.4.1, Ubunto 8.04 for development
Also try the Official OOo Community Forum where I mainly post now.

[Decker87]

I do not think it can be done with a select statement. These statements return result sets, not individual strings or numbers.

[Decker87]

A little update. The key seems to be the getString and getInt methods. But, how in the world are these used? I have a resultset stored in a variable, but I don't know how to return a value from this set using those methods.

[TerryE]

D, I am not sure exactly what you are talking about here. When we talk about Base, we are really talking about two things. The first is a database platform implemented in Java and called HSQL that is bundled in OOo, but in fact is separately available from http://hsqldb.org/. This site also includes a lot of documentation, specifications, FAQs, etc. that are light in the OOo bundle. If you run windows then you will also have the Jet Engine installed. This is the low end database platform that is bundled with al MS OSs and is used by Access and many system utilities. There are also many other mor powerful databases that are freely downloadable, such as MySQL. OOo supports any database that provides an JDBC connector, and section 12 of the SDK describes how to use the UNO API to access and use these. OK the examples are in C++ and Java, but they map back into Basic quite easily.

The second thing s a GUI and builder package that sites over the database and provides a user environment to build applications much in the same way that Access does over the Jet Engine. To me a major difference between Base and Access is that whilst VBA is fully integrated into Access, the UNO API and macro languages sit uncomfortably alongside Base. The getXXXX methods are part of the UNO API.

The stickies at the head of this forum explain how to biuld applications using Base and related tips and techniques in developing a database application. The really isn't any painfree quick start here other than reading these stickies and the resources they point to. Sorry.
_________________
Terry
WinXPSP3, OOo 2.4.1, Ubunto 8.04 for development
Also try the Official OOo Community Forum where I mainly post now.

[Decker87]

Terry, I am not new to databases. I am just asking how to use the getString() and getInt() methods because there is no documentation on it.

What I am saying is, I have a result set which looks like this:

This is what a select statement returns, a result set. It does not return a string, integer, etc.

What I am asking, is how do I return the string "ENGLISH" from that result set?