>Hi all,
> I use vb.net and visual foxpro to database(.dbf). I want to write a function and return row no.
>for example, table and 5 record ( sysid sysname )
> 001 add
> 002 update
> 005 delete
> 009 save
> 100 print
>
>How can i do, Thank you ~~~
>
>

>
>select    ???    from systable where sysname='delete'
>
>I want to return 3 (row 3 in table )
>


Hi
You can use CTE.
http://msdn.microsoft.com/en-us/library/ms190766.aspx

Help others is first think you must do.