1. Roger
  2. Valentina Database ADK
  3. 金, 8月 07 2020, 03:06 PM
  4.  メールで購読

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
There are no comments made yet.
Ivan Smahin 承諾済みの回答
Something like this one:

Dim VPreparedStatement stmt
stmt = db.Prepare( "Select ** FROM myTable WHERE RecID = :1" )
stmt.BindUInt32( 0, aRecIDVariable )
cursor = stmt.SqlSelect()
There are no comments made yet.
Ruslan Zasukhin 承諾済みの回答
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.
  1. https://valentina-db.com/docs/dokuwiki/v10/doku.php?id=valentina:products:adk:api:vsqlstatement_class:vsqlstatement_class
There are no comments made yet.
Roger 承諾済みの回答
Many thanks Ivan, many thanks Ruslan.

Now I am more an more familiar with Valentina and I like it. :D
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.


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