I know, thanks. I threw that together quickly to try to get it working (not as I need it in my app but as a generic test to see if I could get the bins for all printers attached to a workstation) and I had the table open already on my workstation the entire time I was testing so it always worked for me as is of course! In effect I was creating a cursor the entire time that I already had a table open of the same name and structure. Simply because I started out with a table instead of a temporary cursor. It needs a lot more cleaning up: for instance there are more arrays created than necessary, etc because initially when I had problems I was stepping through it and checking values, etc. Old code still exists in it and it can be optimized. Anyway, it is basically simply to test the capability and I wanted to make sure that api works and returns the same information on all OS's so I can use a similar function (not this generic example test) in my app to get the bin numbers for all printers and store them in a table. I have modified it for Esparta to test it too making your and Yuri's changes.


There is also a problem, well not really a problem but poor coding, in the keypress event where I store the value selected if the record pointer is not at the end of file but I do no checks (should just in case of errors,etc throwing things out of whack) before displaying the messagebox. Also in the dblclick method it should be cleaner and verify selection before actually processing, etc... Oh well, that is quick and dirty for testing the function in a quick timeframe for ya... (and laziness on my part, I don't always write clean code for testing purposes only!)

Tracy