Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Select SQL without Data
- Thread starter astech
- Start date
torturedmind
Programmer
you may want to try this:
SELECT SQL * ;
FROM MyTable ;
WHERE CMONTH(MyTable.HireDate) = "XXXXXXXXXX" ;
INTO CURSOR NoData
this will result in a cursor called NoData with no resulting records.
kilroy![[trooper]](/data/assets/smilies/trooper.gif "[trooper] [trooper]")
philippines
"and that's what we call creativity..."
SELECT SQL * ;
FROM MyTable ;
WHERE CMONTH(MyTable.HireDate) = "XXXXXXXXXX" ;
INTO CURSOR NoData
this will result in a cursor called NoData with no resulting records.
kilroy
philippines
"and that's what we call creativity..."
Mike Lewis
Programmer
Astech,
Or, a more general approach:
SELECT <fields> FROM <table> WHERE .F. INTO CURSOR <cursor>
That will give you a cursor with the desired structure but with no records.
Mike
Mike Lewis
Edinburgh, Scotland
Or, a more general approach:
SELECT <fields> FROM <table> WHERE .F. INTO CURSOR <cursor>
That will give you a cursor with the desired structure but with no records.
Mike
Mike Lewis
Edinburgh, Scotland
- Status
