How do I get NoBlanks in this example?

I can't seem to get the ReportsTo drop field to have no blanks in edit mode. I've added "||NoBlanks" to the X.dbEditDropFlds statement with no change in results. What am I doing wrong?

Thanks!

Set X=Server.CreateObject("AspDB.EP")
X.dbUnit = 101
X.dbDAT = "SERVER, Northwind, sa"
X.dbMode = "Grid"
X.dbSQL = "SELECT EmployeeID,LastName,ReportsTo from Employees"
X.dbNavigationItem = "Next,Prev,Update,Delete"
X.dbEditParams = "TableName=Orders,BookMarkFlds=0"
X.dbEditFlds = "LastName,ReportsTo" ' EditFlds 0&1
X.dbDisplayLookUpList = _
"(;|)ReportsTo||SELECT EmployeeID, LastName FROM Employees"
X.dbEditDropFlds = _
"(;|)ReportsTo||||SELECT EmployeeID, LastName FROM Employees"
' First parameter: taken from dbEditFlds
' Second parameter taken from dbSQL.
X.dbEditLookUpXref = "1,2;" ' dbEditFlds, dbSQL
X.ASPdbEP

John,
It worked fine for me. Maybe you just need to spell "NoBlank" correctly. (No 'S' at the end)
See:
http://www.aspdb.com/docs/aspdbman.htm#dbEditDropFlds
Mark.

------------
John Lynch at 7/18/00 3:25:04 PM

I can't seem to get the ReportsTo drop field to have no blanks in edit mode. I've added "||NoBlanks" to the X.dbEditDropFlds statement with no change in results. What am I doing wrong?

Thanks!

Set X=Server.CreateObject("AspDB.EP")
X.dbUnit = 101
X.dbDAT = "SERVER, Northwind, sa"
X.dbMode = "Grid"
X.dbSQL = "SELECT EmployeeID,LastName,ReportsTo from Employees"
X.dbNavigationItem = "Next,Prev,Update,Delete"
X.dbEditParams = "TableName=Orders,BookMarkFlds=0"
X.dbEditFlds = "LastName,ReportsTo" ' EditFlds 0&1
X.dbDisplayLookUpList = _
"(;|)ReportsTo||SELECT EmployeeID, LastName FROM Employees"
X.dbEditDropFlds = _
"(;|)ReportsTo||||SELECT EmployeeID, LastName FROM Employees"
' First parameter: taken from dbEditFlds
' Second parameter taken from dbSQL.
X.dbEditLookUpXref = "1,2;" ' dbEditFlds, dbSQL
X.ASPdbEP

I knew it was something stupid on my part. Thanks!


------------
Mark at 7/18/00 4:34:33 PM

John,
It worked fine for me. Maybe you just need to spell "NoBlank" correctly. (No 'S' at the end)
See:
http://www.aspdb.com/docs/aspdbman.htm#dbEditDropFlds
Mark.

------------
John Lynch at 7/18/00 3:25:04 PM

I can't seem to get the ReportsTo drop field to have no blanks in edit mode. I've added "||NoBlanks" to the X.dbEditDropFlds statement with no change in results. What am I doing wrong?

Thanks!

Set X=Server.CreateObject("AspDB.EP")
X.dbUnit = 101
X.dbDAT = "SERVER, Northwind, sa"
X.dbMode = "Grid"
X.dbSQL = "SELECT EmployeeID,LastName,ReportsTo from Employees"
X.dbNavigationItem = "Next,Prev,Update,Delete"
X.dbEditParams = "TableName=Orders,BookMarkFlds=0"
X.dbEditFlds = "LastName,ReportsTo" ' EditFlds 0&1
X.dbDisplayLookUpList = _
"(;|)ReportsTo||SELECT EmployeeID, LastName FROM Employees"
X.dbEditDropFlds = _
"(;|)ReportsTo||||SELECT EmployeeID, LastName FROM Employees"
' First parameter: taken from dbEditFlds
' Second parameter taken from dbSQL.
X.dbEditLookUpXref = "1,2;" ' dbEditFlds, dbSQL
X.ASPdbEP