1. Roger
  2. Valentina Database ADK
  3. Пятница, Август 07 2020, 03:06 PM
  4.  Подписаться через email

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.