Variable in SQL statement

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Don Starkey (imdonnie_at_msn.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 14:03:11 -0700

I have a SQL statement:

deSVLG.rscmdIGArpt.Open "SELECT Address, City, FirstName, IGADate, IGAFee,
LastName, MemberNo, StateZip, Remarks FROM SvlgMain WHERE MemberNo >= (
MemNo)

Where (MemNo) at the end is a variable integer

I can operate the program OK by using MemNo as a Parameter in the data
designer, but would prefer to use the variable in the text recordset
opening.

Can a variable be used in a SQL statement, and if so, how?

Thanks

Relevant Pages

  • Re: Variable in SQL statement
    ... No, variable cannot be used inside of the SQL statement directly, but there ... Dim loParameter as ADODB.Parameter ... IGAFee, LastName, MemberNo, StateZip, Remarks FROM SvlgMain WHERE ... > Where (MemNo) at the end is a variable integer ...
    (microsoft.public.vb.database.ado)
  • Re: Variable in SQL statement
    ... deSVLG.rscmdIGArpt.Open "SELECT Address, City, FirstName, IGADate, IGAFee, ... > Where (MemNo) at the end is a variable integer ... > Can a variable be used in a SQL statement, and if so, how? ...
    (microsoft.public.vb.database.ado)