Thanks Marh

Just something I need to know - again!

In the init :

This.DataSource = sqlstringconnect([Driver={Sql Server};Server=localhost;Database=New32;Int Security;])

Now after CURSORFILL() and before doing a TABLEUPDATE() or REQUERY(), if the connection for any reason is broken to SQLSERVER, This.Datasource stays the same value. When I run this code, the CA returns me nothing other than .F. from CursorFill(). And no cursor is created.

How can I check whether the connection is still good without checking whether
the cursor is created or the return value?


>>One thing I wanted was NoDataOnLoad and there is a custom property for this:
>>lNoDataOnLoad. This sets up the cursor as empty without doing a load of data. But what I discovered is that I then have to set this to .T. before calling the CursorFill method or nothing was loaded.
>
>CursorFill is only needed once. After you set the value of your parameter, just call the CursorRefresh() to fill the cursor. This is equivalent to the REQUERY() function for views. There is no need to worry about NoDataOnLoad or my lNoDataOnLoad property with CursorRefresh().