1. Roger
  2. Valentina Database ADK
  3. Пятница, Август 07 2020, 03:06 PM
  4.  Подписаться через 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
Комментарий
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.

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