ADO: display limited records
- From: saxenavaibhav17@xxxxxxxxx
- Date: 14 May 2007 23:44:17 -0700
Hi all;
qrymillcgetbytype_app ( stored query in MS-Access) in my code :
MS-ACCESS Part:
query defination
PARAMETERS prmMillToolType Long;
SELECT MILLC.ID, MILLC.InsMillBdyID AS [Tool ID], MILLC.SubType,
MILLC.Radius AS [End Radius], MILLC.CuttingDia AS [Tool Dia],
MILLC.EffAxlCutLen AS [Effec Cut Length], MILLC.OverallLen AS [Overall
Length], MILLC.HandOfCut AS [Hand Of Cut], MILLC.NoOfFlutes AS [No Of
Flutes], MILLC.TmcID AS [Tool Class], MILLC.Comment, MILLC.Protrusion,
MILLC.ShankDia, millC.ShoulderLen AS [Shoulder Length]
FROM MILLC
WHERE (((MILLC.[Mill Tool Type])=[prmMillToolType]) AND ((MILLC.
[ON])=True))
ORDER BY MILLC.ID;
C++ PART
bstrSQL contain stored query name "qrymillcgetbytype_app"
hr = piRecordSet->put_Source(bstrSQL);
piRecordSet->Open(vNull, vNull, adOpenKeyset, adLockOptimistic,
adCmdUnknown)
it opens fine
but when bstrSQL contain this query name " qrymillcgetbytype_app
WHERE ID > -1 AND [Tool Dia] >= 0.000000 AND [Tool Dia] <= 5.000000 "
it displays the same output. Where clause won't work?
Pls help me out.
.
- Follow-Ups:
- Re: display limited records
- From: Bob Barrows [MVP]
- Re: display limited records
- Prev by Date: Add/Update database with ADO Data control
- Next by Date: Re: Add/Update database with ADO Data control
- Previous by thread: Add/Update database with ADO Data control
- Next by thread: Re: display limited records
- Index(es):