Member Avatar for cybour

can some one help me with the CursorType

i try to use

Connect.Open "DSN=vault; uid=colu; pwd=colu;"

strSQL = "select CusId,CusName from Customer ORDER BY CusName"

rstdpt.Open strSQL, connect, 3, 1, 1

now some times this code works and some time

PrintRec.Open strsql, connect, 3,3

this works

some times when i use adOpenStatic instead of 3 works some times it doesnt

can some one guide me

  • 3 Contributors
  • 2 Replies
  • 199 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by RobUK
Member Avatar for Drew

If PrintRec.Open strsql, connect, 3,3 works why not just use that?

Member Avatar for RobUK

I presume you included adovbs.inc ?

You need that file to use the named ADO constants

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.