Search results for query: *

Mike Yearwood, I have used batch files to remap the drives on reboot in an attempt to do the same, and it was relatively successful and seemed like a shoddy workaround. UNC path wasn't really ideal for certain operations. I wasn't sure whether this could be resolved but.. thanks for the input...

Oops, I can't edit this script.. but I didn't have the problem listed above after that one time. It worked fine, a little slow. I replaced all of the 'scan for's with 'replace all's. Lots of great ideas on here though. Mike, thanks for that last info, unfortunately I'm not actually a...

Lot of good ideas on here. I went with JRB-Bldr's suggestion first, but came across something odd. When it gets to the last line in the file it tells me that the alias does not exist (even though it has been using that alias several cycles already) SET STEP ON close data all set talk on SET...

That's going to be really slow though. It's going to have to sort through probably 50,000 records several hundred times that way.. I suppose I could select just that value to a seperate table then query that instead. Any better ideas/methods? Maybe make a primary key on it then skip if...

I have item numbers which should be unique, and I want to renumber them. However, I want to make sure that when I renumber them, the number is not already in use. It doesn't really matter what they are as long as they are not being used. But I'd rather them be sequential. This is what I have...

My database is made up of free files, no sql backend. Can I add a line like this to my utility?: if exists (select name from table where name = "jim") or if "jim" .not. in (select name from table where name = 'jim') or cnum = 4 if "jim" in (select name from table where number = (cNum))...