ADOQuery problem

[MLNorton]

I am trying to set the SQL Query. The following is my code:

SELECT LastName, FirstName, ExpYearMonDay, UserName, Password

FROM Membership
WHERE UserName IS NOT NULL
ORDER BY UserName

When I try to set the ADOQuery1 to true, I get the following error message.

Parameter UserName has no default value.

 

[DjangMan]

I'm guessing that UserName isn't in your table. Or that UserName is a reserved word in your database.

 

[djjd47130]

What engine are you using? Could it be case sensitivity in the column names? I'm used to MSSQL without case sensitivity.

JD Solutions

 

[djjd47130]

Going on with what DjangMan said, if it is reserved, enclose it in [] so make it [UserName]

JD Solutions