store sql result to a variable 2

[mcginty]

Hi,

Can I store the result of a sql statement to a variable and if so how? eg.

store select max(field) from table to variable

Rgds,
Ted

 

[weedz]

You can store your results into a cursor, a table or an array according to the MSDN.

So if you wish to store your result into a variable, I suggest you use an array.

SELECT * FROM myTable INTO ARRAY MyArray.

HTH,
Weedz (Wietze Veld)

http://www.crowncap.demon.nl

veld4663@exact.nl
The Netherlands

They cling emotionally to code and fix development rather than choosing practices based on analytical assesments of what works best.

After the GoldRush - Steve McConnell

 

[jimstarr]

Hi Ted,

The CALCULATE statement may be what you want. In your example you could say

CALCULATE MAX(field) TO variable

Jim