>I've got a view based off a SQL table to return the next ID for that table. The remote view is based off a SQL table, and has a gcTableName as the parameter. In my code, I open the view and then select it, then issue a requery('IDLISTVIEW'). I was checking to see if _tally was < 1, if so I created a new record. Problem was, _tally was always returning 0. I put in a browse right after the if _tally statment and it showed the records. I've changed my code to check reccount() vice _tally. Is there something I don't know about _tally and remote views?
>
>Kirk

_Tally is only updated for functions done on VFP tables. Use reccount(), eof(), etc.