>Hello everyone,
>
>I am doing the following :
>
>
>IF !USED('euc_database_view')
> USE euc_database_view IN 0
> SELECT euc_database_view
>ELSE
> SELECT euc_database_view
>ENDIF
>SELECT Sales_Transaction
>APPEND FROM DBF('euc_database_view')
>
>The problem is that the above code only append 100 records instead of 600.
>
>Could it be that I have to give more time to the remote view to open before I append???.
>
>Any help would be appreciated.
>
>
>Sergio Ortiz

Sound like the Records To Fetch is set to 100. You could try:

DBSetProp('euc_database_view', 'View', 'MaxRecords', -1)

which will retrieve all records.