hiya guys,

ta for the replies.I don't have the code to hand as it's in the office, but I'll look for potential for non-disposed connections and get back to you.

Many thanks,

yogi

hiya,

I had to upload it from 1 server to another.

When it was too big the web upload would timeout.

cheers,

yogi

hiya,

Worked like treat.

Thanks folks,

yogi

hiya,

Thanks for all the comments.I use an OR mapper, so the client code isn't too hard, just predicates.

I've been informed that the owner / breeder should still be classed as...

hiya,

Yes, but AFTER i have done that, I still have the hassle with tblReturnProducts.

the hassle is that there will be 2x rows of the

same product with the

same productConditionId...

hiya,

Ok, for this to work, I think I need a query that will SUM the products in tblReturnProducts that have productCondtionId = 0.

eg, for a return with an ID of...

ah ok, I think I understand.

I'll give it a go.

ta,

yogi

cheers David,

I'll try that when I get home to my machine.

yogi

hiya,I seem to have the min reqs for XP, according to what you say: "WinXP SP1"

Thta's a good resource you mentioned.I'll have a look there.

Cheers,

yogi

Hiya,

No John, no backup. It was only a few tables that I am working on in my own time.A lesson learned.

Thanks bud,

yogi

hiya,

I have managed to successfully to install it thru trial and error.All very unscientific :-0

thanks anyway,

yogi

hiya,

I suspected as much.having all sorts of hassles getting my MSDn stuff delivered 🙁

many thanks,

yogi

hiya,

Thanks for all the replies folks.The company actually print their own barcodes, but it's good to get input about all the potential barcode pitfalls.

cheers,

yogi

cheers, I'll look into it.I'm just grateful that it's only sandwiches, rather than medical equipment I'm dealing with.

many thanks,

yogi

righto,

cheers bud.I'll use the barCode, that HAS to be unique.It was the size of the thing that was putting me off (8 digits).

I now realise of course that I can...