How to return a value from a SELECT SQL to a variable 1

[Soundsmith]

Sorry, folks, here I go again!
In FoxPro, all I needed to do was say something like:

myVar=SELECT myField from MyTable WHERE keyfield=100

I'm trying to do a lot of background processing in a module (no form involved) and trying to avoid repeatedly creating recordsets just to get these single values.

Is there a simple, easy solution?

Thanks... David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com

 

[Maquis]

Use the DLookup command.

myvar = Dlookup([Field],<table>,&quot;where blahblahblah&quot Maq B-)
<insert witty signature here>

 

[Soundsmith]

Thanks, Maq - exactly what I was looking for! :-0 David 'Dasher' Kempton
The Soundsmith

http://www.thesoundsmith.com