Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 359
  • Last Modified:

Access Memo column (RDO)

Hallo..

I use rdo connection to run some query on a microsoft access database,

but when i read a rdoresultset that contain a memo column i receive this error...

Runtime error 40002
S1109:Cursor position not valid, Nothing keyset defined


Someone have a solution ???

Thanks
0
kaiou
Asked:
kaiou
1 Solution
 
DhaestCommented:
Does your recordset return the ID of the record ?
0
 
kaiouAuthor Commented:
What is ID of recordset ???

My error it is on row : rs.rdoColumns("NomeCampo")

When i open recordset i don't have error...
0
 
DhaestCommented:
How is your table declared at access ? How many columns ? What type of columns ? ...
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
kaiouAuthor Commented:
My query is

SELECT Valore, Riga FROM TabVerbali WHERE Colonna='5'


Table structure is
Verbale String (100)
Riga String(2)
Colonna String(2)
Valore Memo

This Query go perfectly if i change column Valore to String, but Memo give me error...
0
 
leonstrykerCommented:
Consider moving to ADO or DAO.
0
 
PSSUserCommented:
Memo columns must appear on the right of all other, none memo fields if I remember correctly.

Try changing your select statement to:

SELECT Riga,Valore FROM TabVerbali WHERE Colonna='5'
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now