1. Ruslan Zasukhin
  2. Valentina Database ADK
  3. 土, 4月 22 2017, 12:45 PM
  4.  メールで購読
Hi Valentina DB Developers,

I want to expose this feature of Valentina DB 7.0.

Xojo developers could see it in other DBs, also SQLite developers know it.
In 7.0 of Valentina DB we have got it also.

From this point, this should be the most preferable way to work with SQL binding commands.
It is faster of older mechanism - automatic caching of SQL commands with binding.

If you have questions about this feature - please ask them in this thread.
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
That's a really interesting feature. What about some examples or a link to the documentation?

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Hi Beatrix,

Docs exists in wiki:

Examples:
For Xojo there is no yet special example for this feature. But you can see how it is used in
* Tests
* Benches of KeyValue


ATTENTION:
In V4RB / Xojo, we have used other names, because we need correspond to Xojo names, so
* Database.Prepare() instead of VDatabase.CreateSqlStatement()
* VPreparedStatement class instead of VSqlStatement class
コメント
There are no comments made yet.
Beatrix Willius 承諾済みの回答
Hi Ruslan,

thanks for the links.

The documentation for this feature is okay. The release notes have too much and not enough information. Did anyone read and understand those? I doubt it. For your key/value thing you made a nice blog post. For your other new stuff I would like to see at least a paragraph. What is it? What is the benefit? How do I use it?

Our friends from Xojo added line numbering in the code editor. They mentioned it only in the release notes. I didn't even see the new icon in the code editor. As a result the new feature is now rather buggy.

Valentina needs more documentation and more examples!!!

Mit freundlichen Grüßen/Regards

Beatrix Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Well, of course the more docs the better. :)

About SqlStatement I do not see what describe too much, than more for Xojo developers,
because this is described in Xojo docs itself.

Do you have any special questions about it?
コメント
There are no comments made yet.
Jose Panatti 承諾済みの回答
Hi Ruslan, I'm using ADK for Xojo, last version, in Windows, but I don't see VSqlStatement Class and can't instantiate it.
コメント
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
Hi Jose,

indeed, for Xojo classes has names that correspond to Xojo

Code from Examples / Benches / KeyValue


dim stmt as VPreparedStatement = mVDB.Prepare( "KEYVALUE kv1 INSERT (? : ?)" )

dim i as integer
for i = 1 to kRecordCount
dim istr as string = str( i )

stmt.BindText( 0, "key_" + istr )
stmt.BindInt32( 1, i )

call stmt.SqlExecute()
next
コメント
Done. This info now present in this thread, release notes, WIKI API description.
  1. Ruslan Zasukhin
  2. 2 年前
we will add note about this into wiki - classes
  1. Ruslan Zasukhin
  2. 2 年前
There are no comments made yet.
Jose Panatti 承諾済みの回答
Ah ok, thanks
コメント
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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories