1. Alex Lindsay
  2. Valentina Database ADK
  3. Saturday, February 16 2019, 06:08 PM
  4.  Subscribe via email
I have some questions about the Cursor options when used with a local embedded Database with Xojo V4RB on Mac OS.

1. What is the difference between cursors on the client compared to the cursors on the server for embedded Database?
2. I got an error saying client cursors can't be read-write for an embedded Database, is this expected?
3. What is the preferred way for using cursors in an embedded database for Read-Only?
4. What is the preferred way for using cursors in an embedded database for Read-Write?
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
2. yes.

* Client-side cursor means a COPY of records moved into RAM of a client computer.
In such way (and only) work e.g. MySQL, PostgreSQL.

When you need to update a record, you should build and execute UPDATE command.

I think this described in the second link pointed in the prev my answer.
Comment
There are no comments made yet.
Alex Lindsay Accepted Answer
Thanks Ruskin. I think I understand how the cursors work in a client/server configuration. Does it matter if it is an embedded DB using the ADK instead? Both the DB and the client are in the same process in that scenario.
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
With embedded - local DB you have no overhead of network.

So you can easy use Server-side cursors to have read-write access to their records.

This is much more comfortable and more effective, comparing to
- create a SQL string with UPDATE and execute it
- re-build cursor using the same SELECT command, to see changes.
Comment
There are no comments made yet.
Alex Lindsay Accepted Answer
Thanks Ruslan,

That's what I needed to know. I'll use Server cursors on any embedded embedded systems for read/write.
Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories