SQL Statement cannot see pre declared variable?

0 ⤊

SQL Statement cannot see pre declared variable?

studTbl.Open "SELECT * FROM [studlst] where ([no]=i)", pubnew

from the above statement, i is a variable and has an initial value stored which results to an error in a statement, how to solve this proble

2006-11-02 15:04:32 · 2 answers · asked by jcotot 2 in Computers & Internet ➔ Programming & Design

2 answers

If you are in VBA in MS Access? Than you can cut the string and used the variable directly and then finish the string.

studTbl.Open "SELECT * FROM [studlst] where ([no]=" & i &")"

2006-11-02 15:08:19 · answer #1 · answered by Wildjoe182 5 · 0⤊ 0⤋

you have to replace i with the actuall value. otherwise it will look for "i"

2006-11-02 23:05:53 · answer #2 · answered by no one 3 · 0⤊ 0⤋