Datatable.Select Statement Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am developing a windows app the includes data access from an Access 2000 Database. I am getting the following error:

'Filter expression 'sum(Per)' does not evaluate to a Boolean term.

From the very simplistic code snippet below.

With DataTable1
Try
SelectedRows = .Select("sum(Per)")
Catch ex As Exception
Console.WriteLine(Err.Description)
End Try
End With
According to the help, this is supposed to work. This is a single datatable with no child tables.There are no null values in the table. Anyone have any suggestions.
 
Mike Z said:
I am developing a windows app the includes data access from an Access 2000 Database. I am getting the following error:

'Filter expression 'sum(Per)' does not evaluate to a Boolean term.

From the very simplistic code snippet below.

With DataTable1
Try
SelectedRows = .Select("sum(Per)")
Catch ex As Exception
Console.WriteLine(Err.Description)
End Try
End With
According to the help, this is supposed to work. This is a single datatable with no child tables.There are no null values in the table. Anyone have any suggestions.
Click to expand...
 
Back
Top