>Having had difficulty solving that I thought would be fairly simple, Deleting the current record. Of course, there is no currenty record. From the client side, you can insert and update, but you can't delete a record.
>
>First of all, how do you get a hold of a record set. Using ADO, you can build the record set when still on the server side using script language or an ASP page, but once the page is created the record set is no longer available.
>
>I believe with both RDO and ADC( advanced data control ), you can access the cursor client side, though I have to admit that I am not that familiar with the process.
>
>Using ADC, I did not see any way to issue execute another sql query against the control.
>
>I was told the only way to delete the records would be to call another ASP page, which you could then using ADO and passing the ID of the record you wanted to delete would delete the record on the next page. The reason for this is you have to issue the new SQL statement at the server side.
>
>But what if you don't want to leave the page.
>
>I've heard that RDO is very similar to ADO. I've just starting working with RDO, so I do not know if it is incapable of doing what I want to do.
>
>I suppose if I really wanted to delete the record from the client side, I could use an ADC and have an additional lDelete field with a field level rule that would delete the record if the value of ldelete was .t.
>
>I'm trying to get a better understanding of this. If anyone can help me clarify or correct some of my misconceptions, that would be greatly appreciated.
>
>Dan
You may be able to do it with an ADO disconnected recordset. I don't have any experience with ASP, but I have done it with Access and VFP. If you have a client side recordset (CursorLocation=adUseClient) you can make changes (like delete) and then return the recordset back to the server for processing. This implies having a server-side component that will receive the recordset and batch-update the changes to the database. Again, I couldn't give you any details about ASP, but I don't see any reason why you wouldn't be able to use ADO's Delete method of in a client-side recordset.
BTW, the ADC is now called (and/or superseded) the RDS data control.