Hi

Thanks for your help with this.

I have decided to writ ethe result to a file. it is not much quicker for processing but the saving is a big difference

Thanks...

Thanks for the advice.

I will give it a go

Regards

martin

Hi Chris,

I have a VB program that attches to a table in SQl server.

I loop through this table getting an X-Y coordinate.

I find the nearest map object to this coordinate...

Hi

Thanks for your help. this worked fine.

I accept what you say about the method and found the links interesting reading

Regards

Martin

Hi Remi,

Thanks for your input.

I am accessing the database from Visual basic 6. I need to generate perhaps up to 50 sets of results changing two paramters in the stored...

It is a bit of a long story - but I need to create a number of result tables for comaprision.

it is quicker to do on the server rather than...