Tuesday, August 20, 2002 01:22 AM
1. something like
"SELECT * FROM banklist Where ShortName ='" + bankStr + "' and SWIFT = 27"
shd work ok - whether or not there is data in banklist table. (Assuming SWIFT column is of type number otherwise use SWIFT = '27')
2. IMHO this isn't possible within the boundary of JDBC as saved queries is a MSAccess specific feature.