🚀 go-pugleaf

Gerald,

You can use the SET FIELDS TO to set a calculated field. For example, to
get a field called theMonth from InvoicDate (which is of type DATE), you
could do this:

SET FIELDS TO ALL    && to get all existing fields
SET FIELDS TO myMonth=MONTH( InvoicDate )    && use the dBASE expression

However, the SQL SELECT statement cannot work on this table directly
since it (being non-procedural) is going to open its own view of the
data you tell it to work with. So you would have to save this to a temp
file. I would apply your "WHERE" clause criteria as much as possible to
make the temp as small as possible.

So you could...

COPY TO tempTable FOR myMonth = 4 WITH PRODUCTION
&& keep indexes for SQL

SELECT * FROM tempTable && etc.

This is not a 100% SQL solution like your were seeking, but it should
run just as fast and give you the results you need.


--
Geoff Wass
Kuala Lumpur, Malaysia


== In news groups use a reply (not e-mail) so all can help and learn!
==
== Report Inprise/Borland bugs...
== http://www.inprise.com/devsupport/bugs/bug_reports.html
== dBASE Archives http://forumsearch.borland.com:88/
== or http://www.dejanews.com
== Alan Katz's Visual dBASE Magazine http://www.ksoftinc.com/vdb/