Transfer recordset to variable (SQL)

**Jollyfrog** · 10-21-2010, 06:55 AM

hi,

i'm trying to copy a recordset into a variable. i can copy it to an excel cell with the

Please Login or Register  to view this content.

command, but as soon as i try to copy the value to a variable using:

Please Login or Register  to view this content.

it returns a null value...
i need to perform some calculations using another value i've grabbed from a table so what would be the best way to get my value into a variable?

the value returned is a single digit btw

thanks

Jonathan

**DonkeyOte** · 10-21-2010, 07:01 AM

[removed - nonsense I'm afraid...]

**DonkeyOte** · 10-21-2010, 07:14 AM

Jonathan, earlier post was nonsense, apologies!

Please Login or Register  to view this content.

**Jollyfrog** · 10-21-2010, 07:25 AM

hmm i've tried this and it seems to think the EOF is true.. i copy the recordset into a cell just to see whats going on... and that returns the correct value, 27...

vtemp doesn't return any value as nothing is parsed into it

thanks

**romperstomper** · 10-21-2010, 07:34 AM

rst already is a variable, so I don't really see what it is you want to do?

**Jollyfrog** · 10-21-2010, 07:46 AM

i wan't to perform an arithmetic operation on it.

Please Login or Register  to view this content.

like that only a bit more complicated...

currently code like that returns type mismatch error

**Jollyfrog** · 10-21-2010, 08:02 AM

To clarify what i want to do:

Please Login or Register  to view this content.

i'm ok with getting balues from tables (thanks to some help

)
however recording values returned from the tables is presenting a difficulty.

thanks

Jonathan

**romperstomper** · 10-21-2010, 08:17 AM

Wouldn't it be easier to do all that in the query (or queries)?
You can't simply multiply a recordset by 5 as a recordset can contain many records and many fields per record. If you only have one field and one record, then you need to refer to that field specifically:

Please Login or Register  to view this content.

for example.

**Jollyfrog** · 10-21-2010, 08:46 AM

i wanted to parse the record to a variable (integer) so i could then perform mathematical operations upon it. I also need to use the result of a query to form the paremeters for the next query, i thought the best was to do this would be to use a variable set from a recordset.

I'm not really sure how to the whole process as a single query, i assumed combining 3 separate queries was better.

however

when i use the code

Please Login or Register  to view this content.

range g5 returns the correct value (27)

but temp does not accept a value

**romperstomper** · 10-21-2010, 08:56 AM

Put the temp line before the CopyFromRecordset line.

**Jollyfrog** · 10-21-2010, 09:06 AM

wait whaat!.. that works hmm.. well thankyou very much :-)

does copyfromrecordset delete the record then?

thanks again

**romperstomper** · 10-21-2010, 09:18 AM

No, it doesn't delete it, but it does move to the end of the recordset, so there is no current record for you to read.

Transfer recordset to variable (SQL)

LinkBack

Thread Tools

Rate This Thread

Display

Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Re: Transfer recordset to variable (SQL)

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions