1. Ruslan Zasukhin
  2. Valentina Database ADK
  3. Samstag, April 22 2017, 12:45 PM
  4.  Abonnieren via E-Mail
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.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
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?
Kommentar
There are no comments made yet.
Jose Panatti Akzeptierte Antwort
Hi Ruslan, I'm using ADK for Xojo, last version, in Windows, but I don't see VSqlStatement Class and can't instantiate it.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
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
Kommentar
Done. This info now present in this thread, release notes, WIKI API description.
  1. Ruslan Zasukhin
  2. vor etwa 6 Jahren
we will add note about this into wiki - classes
  1. Ruslan Zasukhin
  2. vor etwa 6 Jahren
There are no comments made yet.
Jose Panatti Akzeptierte Antwort
Ah ok, thanks
Kommentar
There are no comments made yet.
  • Seite :
  • 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