I get a DB/table name to open from another DB/table full of DB/table names.
Code looks something like this:
dbnam = mydb.dbnames && Get DB name from list of DB names
SELECT &dbnam && Select DB/table that came from list
SEEKID = &dbnam.field1 && Get Seek ID value
SEEK SEEKID && Seek the record
IF FOUND()
.....
.....
ENDIF
But whenever I run the program and it encounters the SEEKID =
&dbnam.field1 command, I get an error that &dbnam is not an object. I thought I had used a Macro substitution in the past just like this without error. Any ideas? Is there a better way to do it?
I have read that one may use SELECT (dbnam) instead, but I get the same error, but better performance? Thanks.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.