|
| Access to query like an array |
| Iniciado por guest, 31,mar. 2015 18:14 - 2 respuestas |
| |
| | | |
|
| |
| Publicado el 31,marzo 2015 - 18:14 |
Hello all,
Is there a way to access a query like an 2 dimensional array
MyQuery[2,3] -- > should return the thirth column of the second row
I know there are other solutions but making copies consumes time and memory on a server.
Direct acces to each cell could result in faster/simpler programs.
Thanks,
Willy Hermans. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,marzo 2015 - 19:38 |
Hi Willy,
No it is not, but maybe you can use FileToMemoryTable() or FileToArray() depending on your case.
Best regards,
Alexandre Leclerc |
| |
| |
| | | |
|
| | |
| |
| Publicado el 31,marzo 2015 - 19:42 |
Hi Willy
there is no built in function, but you can at first glance do this:
- access any row with a hread(queryname, rownumbner), as in a query, the hrecnum information is equal to the returned row
- create a function that uses indirection to return the item/column n
So you could build it yourself, if you need to... I'm not sure what the use is supposed to be though
Edit... Now that I think about it, there is a SQLCol function available too... so maybe a solution there?
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|