General information
Category:
Coding, syntax & commands
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only