Thanks in advance.
william_ross@gensler.com

Here's one way to map your drives using the PC name:

code:

---

BREAK ON CLS
$PCNAME=@WKSTA
SELECT
  CASE INSTR ($PCNAME, "DC")
    USE G: "\\SERVER1\SHARE"
  CASE INSTR ($PCNAME, "VA")
    USE G: "\\SERVER2\SHARE"
  CASE 1
    ? "Non standard PC name.."
ENDSELECT

---

code:

---

select
	case substr(@wksta,1,2) = "DC"
		...
	case substr(@wksta,1,2) = "VA"
		...
	case 1
		...
endselect

---

------------------
kix.isorg.net

[This message has been edited by Bryce (edited 05 April 2001).]

Could you please explain why the SUBSTR command would be a better choise than INSTR ?

Bert.

The INSTR() command searches the entire string looking for those 2 letters.

Take the following code

code:

---

BREAK ON CLS
$PCNAME="VA123DC"
SELECT
  CASE INSTR ($PCNAME, "DC")
    USE G: "\\SERVER1\SHARE"
  CASE INSTR ($PCNAME, "VA")
    USE G: "\\SERVER2\SHARE"
  CASE 1
    ? "Non standard PC name.."
ENDSELECT

---

Even though VA is the first 2 letters, the first case argument is proven true because you preform a INSTR() on the entire string looking for "DC" and $pcname = "VA123DC"

using SUBSTR() removes the chance of that happening.

Bryce

------------------
kix.isorg.net