Hi Kevin,
to my low english:
>going to pull out around 5 to 6 records
means the result is 5 to 6 records (IOW _Tally=)?
How many records are used to create those records? SELECT SQL generates temporary cursors within the select. If temp space is low it may fail. Remeber that WHERE / ORDER / GROUP and the like will happen after all joins are done.
HTH
Agnes
>Hi
>
>One of our users has just recieved this message, this is the first time it's happened.
>
>All the program is doing, is a SQL SELECT and then running out of memory, the actual query is only going to pull out around 5 to 6 records, it doesn't error all the time, it is intermittent, the SQL is run from a timer every 1 minute, it is selecting into an array.
>
>Any ideas? I'm pretty sure it's not actually "out of memory"!
>
>Thanks
>Kev
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]