Syntax for WHERE ID = IntegerProperty

Databases
1

I’m new to DB coding and this is probably an amateur question. What is the sql syntax to use an integer property RowID in the WHERE ID Column. All the code examples I could find use a number.

[code]RowID As Integer

RowID = PopupMenu.ListIndex

Dim sql As String = “SELECT * FROM dbTable WHERE ID = RowID” // <— ?

Dim rs As RecordSet
rs = db.SQLSelect(sql) [/code]

2

It’s like any string.

sql  = "... WHERE ID  = " + str( RowID )
3

It was the fix. Thanks Kem & Happy New Years