1. Ruslan Zasukhin
  2. Valentina Database ADK
  3. Saturday, April 22 2017, 12:45 PM
  4.  Subscribe via email
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.
Comment
There are no comments made yet.
Jose Panatti Accepted Answer
Ah ok, thanks
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ruslan Zasukhin Accepted Answer
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
Comment
Done. This info now present in this thread, release notes, WIKI API description.
  1. Ruslan Zasukhin
  2. 6 years ago
we will add note about this into wiki - classes
  1. Ruslan Zasukhin
  2. 6 years ago
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Jose Panatti Accepted Answer
Hi Ruslan, I'm using ADK for Xojo, last version, in Windows, but I don't see VSqlStatement Class and can't instantiate it.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Ruslan Zasukhin Accepted Answer
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?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
Beatrix Willius Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 5
Ruslan Zasukhin Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 6
Beatrix Willius Accepted Answer
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
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 7
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories