1. Alex Lindsay
  2. Valentina Database ADK
  3. Суббота, Февраль 16 2019, 06:08 PM
  4.  Подписаться через 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?
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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.
Комментарий
There are no comments made yet.
Alex Lindsay Ответ принят
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.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
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.
Комментарий
There are no comments made yet.
Alex Lindsay Ответ принят
Thanks Ruslan,

That's what I needed to know. I'll use Server cursors on any embedded embedded systems for read/write.
Комментарий
There are no comments made yet.
  • Страница :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories