Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

docmd.close 2585, WWWXXXAPC, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text, WWWXXXAPC., XXXCNZZZ

Links

XODOX
Impressum

#1: The expression contains undefined function call isdate()

Posted on 2008-04-23 17:57:42 by nlulla

Hi I am trying to get all rows from a datatable where the first column
F1 is a date, as this datatable is created of excel, i only want to
deal with rows where the first column is having a date in it.

For Each drow As DataRow In dt.Select("isdate(F1)")
.....code here stripped off , but was to loop through all columns
NEXT

but i get following error when i run the above code
"The expression contains undefined function call isdate()"

So the datatables select method cannot recognize isdate function, but
then what is the other way to do the same?

Any help greatly appreciated
Regards

Report this message

#2: Re: The expression contains undefined function call isdate()

Posted on 2008-04-23 19:29:52 by sloan

DataSet .Select does not contain the full gammit of functions like in Sql
Server or even Access.


http://msdn2.microsoft.com/en-us/magazine/cc188790.aspx
might help a little with what is available.


You'll need to go to LINQ if you want more advanced control like that.





"nlulla" <nirav.lulla@gmail.com> wrote in message
news:2c976696-8799-4a97-a36e-83715a76d53c@x35g2000hsb.google groups.com...
> Hi I am trying to get all rows from a datatable where the first column
> F1 is a date, as this datatable is created of excel, i only want to
> deal with rows where the first column is having a date in it.
>
> For Each drow As DataRow In dt.Select("isdate(F1)")
> .....code here stripped off , but was to loop through all columns
> NEXT
>
> but i get following error when i run the above code
> "The expression contains undefined function call isdate()"
>
> So the datatables select method cannot recognize isdate function, but
> then what is the other way to do the same?
>
> Any help greatly appreciated
> Regards

Report this message