1. Roger
  2. Valentina Database ADK
  3. Freitag, August 07 2020, 03:06 PM
  4.  Abonnieren via E-Mail
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
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Something like this one:


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

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