Hi Mark

>In Clipper we have the command
>"set scopetop to " and "set scopebottom to"
>This was to create a table wiht a portion of the original table.

e.g. use year
set order to date
set scopetop to ctod("01/01/2000") && comix command from Foxpro
set scopebottom to ctod ("31/01/2000")

Now we have a table year with only the month january
when i need the whole table again we use the command
set scope to
and everything is as before

>
>select datum, periode, &cID from jaar where jaar.datum = dDatum into table SomeTempTable

This command is correct but now i have only a view
Browse is automatily started i don't need a browse screen

Greetings
Ben