oledbcommand

where alltrim(cocode) = ?
.Parameters.Add(New OleDbParameter("@dotnet.itags.org.oacode", OleDbType.VarChar, 10)).Value
= strName
When the strName is blank, (it return all the record)
How can I correct it '
I am using vfpoledb.dll2 ways
1. do a check in stored proc or query to return nothing
when empty or null
2. send "-1" or some const value whenever it is empty from the bo layer
itself.
--
Y2KPRABU, MCP, INDIA
WEB APPS
"Agnes" wrote:

> where alltrim(cocode) = ?
> ..Parameters.Add(New OleDbParameter("@.oacode", OleDbType.VarChar, 10)).Val
ue
> = strName
> When the strName is blank, (it return all the record)
> How can I correct it '
> I am using vfpoledb.dll
>
>