1. Roger
  2. Valentina Database ADK
  3. Friday, August 07 2020, 03:06 PM
  4.  Subscribe via email
Hello

I try a simple select with a parameter like a preparedStatemanet like this with the result in a vCursor.


stmt = db.CreateSqlStatement( "Select ** FROM myTable WHERE RecID = :1" )
stmt.Bind_UInt32(0, aRecIDVariable)


VSqlStatement is unknow in Xojo ADK





What is the best/correct way with parameter out of the string variable? (with a binding)

Regards Roger
Comment
There are no comments made yet.
Roger Accepted Answer
Many thanks Ivan, many thanks Ruslan.

Now I am more an more familiar with Valentina and I like it. :D
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Ruslan Zasukhin Accepted Answer
Please notice that on WIKI page it is mentioned
In “Valentina for Xojo” ADK this class has name VPreparedStatement

Right now, we have check wiki pages, adding more mentioned of this difference in Valentina for Xojo ADK to other ADKs.
References
  1. https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentina:products:adk:api:vsqlstatement_class:vsqlstatement_class
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Ivan Smahin Accepted Answer
Something like this one:


Dim VPreparedStatement stmt
stmt = db.Prepare( "Select ** FROM myTable WHERE RecID = :1" )
stmt.BindUInt32( 0, aRecIDVariable )
cursor = stmt.SqlSelect()
...
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
  • 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