Cursor options when used with a local embedded Database

Sign In

Sign in to your account

If you are new here please register for an account

Username:

Password:

ログインを記憶

パスワードを忘れましたか？

返信を追加返信を表示 (5)

解決済み Cursor options when used with a local embedded Database

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.

返信 (5)

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.

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 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 承諾済みの回答

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.

Ruslan Zasukhin 承諾済みの回答

Hi Alex,

1) You can read about this in our Valentina WIKI

* http://valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:vcomponents:vclient:cursor_location
* http://valentina-db.com/docs/dokuwiki/v9/doku.php?id=valentina:vreasons:vdb:server-side_cursors

コメント

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

0 subcategories

Valentina Studio

2 subcategories

Valentina Server

4 subcategories

Valentina Database ADK

0 subcategories

Valentina Reports ADK

0 subcategories

Other Discussions

2 subcategories

BETA Testing

0 subcategories

Education & Research

0 subcategories