Click to See Complete Forum and Search --> : DataView exception error... Please help


ilk
February 15th, 2003, 11:39 AM
Hi I'm getting the below error message when i try to initialize dataview object

An unhandled exception of type 'System.Data.SyntaxErrorException' occurred in system.data.dll

Additional information: Syntax error: Missing operand after 's' operator.

I use the following code

Dim dv As New DataView(ds.Tables("Files"), "URL = '" & strFile & "'", "ID", DataViewRowState.CurrentRows)

ilk
February 15th, 2003, 11:56 AM
don't worry got it,

I had a single quote in filename....