Hi,

I have the nect code:
===
Set conn_clip = server.createobject("adodb.connection")
conn_clip.open "DSN=DBMINE"
set rs_clip = server.createobject("adodb.recordset")

sql_clip="SELECT * FROM MAE_LAL WHERE COD_ALB=1 "
rs_clip.open sql_clip,conn_clip

rs_clip.close
Conn_clip.Close
Set rs_clip=Nothing
Set Conn_clip=Nothing
===

It works fine, but whenever I put the lines of the SQL inside a bucle, like this:

==
Set conn_clip = server.createobject("adodb.connection")
conn_clip.open "DSN=DBMINE"
set rs_clip = server.createobject("adodb.recordset")

FOR counter=1 to 20
sql_clip="SELECT * FROM MAE_LAL WHERE COD_ALB=1 "
rs_clip.open sql_clip,conn_clip

NEXT

rs_clip.close
Conn_clip.Close
Set rs_clip=Nothing
Set Conn_clip=Nothing

====
It gives me an error

"The operation is not poissble if object is open (Translated from spanish, sorry)

So I tried to put the lines
===
rs_clip.close
Conn_clip.Close
===
behind the code
===
rs_clip.open sql_clip,conn_clip
===
So it opens and closes it every time, but it gives me also an error.


What I want to do is to read from a DBF (CLIPPER) files, get some data and write it into an SQL file (other part of code, not written here).


WHAT am I doing wrong?????

Thx,

Johny

Veamos Tio,

El error original te dio porque tratabas de abrir el objeto dos veces y tu correccion fue logica.

Sin embargo, no entiendo porque quieres meter esas instrucciones dentro de un bucle (si siempre es el mismo query string!??!; a menos que nos estes simplificando tu codigo... Asi como esta puesto, yo sacaria el comando Open del bucle...

Si simplificaste el codigo, envianos algo mas del original.

Saludos - Joel