>working with vfp 6.0 on NT 4.0 sp 6.
>
> I am working with a sample I got off an article earlier. I can get the code to work, if I have all the code in the same project. But if I seperate the code out to the two dll and the exe as the article says, the second ADO call does not work.
>
> LPARAMETER miCliente
> local lsSqlstring
> lsSqlstring = "Select cliente.*, EstadoCuenta.saldocuent" ;
> + " from Cliente, EstadoCuenta " ;
> + " where cliente.idcliente = '" + miCliente + "'" ;
> + " and cliente.idcliente = EstadoCuenta.idcliente"
> oREcordCta = CREATEOBJECT("ADODB.REcordset")
> oREcordCta.OPEN(lsSqlstring, ghconnection)
>
> RETURN oREcordCta
>
>I had the lsSqlstring as the actual code in open the first couple times, but it still does not work. Both tables (cliente and EstadoCuenta) are part of a database. I had the tables in a sub-directory from the database, then moved them into the same directory, but still can not get the dll's to work.
>
> Does anyone have ideas on how I can fix this?
>
>Thanks in advance,
>Beth
If this code is from a DLL method the recordset oRecordCta has to be client side, and also try disconnecting the recordset before returning with
oRecordCta.ActiveConnection = Null
HTH