Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using ADO in ntier
Message
From
16/09/2002 09:40:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Using ADO in ntier
Miscellaneous
Thread ID:
00700771
Message ID:
00700771
Views:
59
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
Map
View

Click here to load this message in the networking platform