Extracting a value from the database.

Hi,

Another newbie question. How can I extract a value from my database and populate a variable with that value. I have tried DatabaseRetrieve but it returns only the number of rows retrieved. I have read the documents and I think I understand the retrieved data has gone into the buffer, but how do I retrieve it from the buffer and populate the variable with it?

Here is the code I have:

Dim new_instance_number, string
DatabaseRetrieve("Select LASTPRCSINSTANCE from PS_PRCSSYSTEM", new_instance_number)

Thanks for any assistance you can offer. I must say I'm quite pleased with the response I receive from this forum.

Steve

After you do DatabaseRetrieve you should do DatabaseGet. DatabaseReteieve can retrieve multiple columns and rows that are placed into database buffer. DatabaseGet is used to get values from that buffer.

DatabaseRetrieve("Select LASTPRCSINSTANCE from PS_PRCSSYSTEM", rows)
DatabaseGet(1, 1, new_instance_number)

: Hi,

: Another newbie question. How can I extract a value from my database and
: populate a variable with that value. I have tried DatabaseRetrieve but it
: returns only the number of rows retrieved. I have read the documents and I
: think I understand the retrieved data has gone into the buffer, but how do
: I retrieve it from the buffer and populate the variable with it?

: Here is the code I have: Dim new_instance_number, string
: DatabaseRetrieve("Select LASTPRCSINSTANCE from PS_PRCSSYSTEM",
: new_instance_number)

: Thanks for any assistance you can offer. I must say I'm quite pleased with
: the response I receive from this forum.

: Steve