[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference abbott::visual_basic

Title:Microsoft Visual Basic
Moderator:TAMARA::DFEDOR::fedor
Created:Thu May 02 1991
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2565
Total number of notes:10453

2564.0. "QueryDef: Parameter for ORDER BY clause ?" by GLRMAI::tunsrv2-tunnel.imc.das.dec.com::NEIL () Thu Jun 05 1997 23:05

Hello,

I'm trying to set up a general QueryDef (from within VB4 and Access V7) 
that takes an ORDER BY Parameter.

Here is the VB code I'm using.

  sSql = "PARAMETERS [OrderByField] TEXT; "
  sSql = sSql & "Select * from MainMailList WHERE ActiveFlag = True"
  sSql = sSql & " ORDER BY [OrderByField];"
  Set qryMainMailList = dbCPIDatabase.CreateQueryDef("SortedList", sSql)

It's accepted and even executes without error.  The only problem is
that no sort is apparent (even when I try and debug it directly in Access).

Any ideas ?

Thanks,

Peter.
T.RTitleUserPersonal
Name		DateLines