I would like to count child records for each record in master table. If no
child record should return 0, here is what I did, but gives me 1 for no
child. Any idea what am i missing here?
CREATE CURSOR tmpMast (id N(2), name c(15))

ok, I frequently copy my output data to type xls or xl5 so my users can open
the files up. However, I'm trying to copy one to an excel file now and my
dbf has 20,329 records in it. When I copy, it stops at record 16,383. Is
excel limited to only 16,383 records and if so, is there ...

I have some opened tables in my VFP 6.0.
I want to close some of them, but NOT ALL.
I know, I should write:
SELECT table1

I transferred my .dbc and SQL2000 database (*.mdf and .ldf files) from a
computer with W2000 Server & SQLServer2000 (dual 2.8 GHz, 4GB mem) to a
faster machine with W2005 Server Ent. and SQL2005 (dual 3.4 GHz, 8 GB mem).
The foxpro program creates remote views (using Create SQL ...

Hello.  I have table I use for querying.  What I wish to do is to search for
value in one column.  Problem is the strings searched contain a dash (-) in
the data.  What I wish to do is to strip the (-) from the string then perform
comparison.  The structure the strings are in is ...

I need to copy files for a daily process based on the file date. They are
text files. They are FTP'd to us but I access the ftp folder as a folder, so
I can copy the files easily. The names are not predicable so I can't select
by wildcards. I can't use a WHERE clause with COPY ...

i've created a cursor (curI_ITEM). since has grouping & conditions, how can
i assign con_no into invoice table which satisfy all the conditions? what
will be the easiest/best way to assign con # from alloc_con_no table to the
curI_ITEM and invoice table?

The DIR command will save filenames in a directory to a file. If CONSOLE is
set to ON, it saves in three columns each 61 characters wide so I've been
able to import the filenames into a table without too much manipulation. If
I set CONSOLE to OFF so that I don't have to hit Enter ...

Such an example:
CREATE cursor cr1 (date1 D, income Y)
INSERT INTO cr1 values(DATE()-10,10)
INSERT INTO cr1 values(DATE()-10,20)