-
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
-
How do I get NoBlanks in this example? (reply)
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
-
How do I get NoBlanks in this example? (reply)
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|