Recent content by HotHand

To select members in table1 that are also in table2 select memberid, tdate from table1 where memberid in (select memberid from table2) To select members in table1 that are NOT in table2 select memberid, tdate from table1 where memberid not in (select memberid from table2) NOTE: "select...

Here is what I use: SELECT * FROM table1 WHERE col1 IN (SELECT col1 FROM table2) any dups will show in cursor.

I made a mistake... I was trying to save some typing. the command that works is use table1 copy all to table1_1 WITH CDX [or WITH PRODUCTION] Sorry about that. I seem to always get my best ideas after I've clicked the SEND button.

I could not get select * from table1 to table1_1 to work at all. select * from table1 INto TABLE table1_1 works. The best way to also reproduce the indexes select * from table1 INto TABLE table1_1 WITH CDX [or WITH PRODUCTION (if you like to type more characters)] Marc marcmorris@attbi.com

To chpicker. Thanks. Apparently comm98.chm is not included with Windows 2000 Professional. I could not find it on a Windows 95 machine either. Would you email it to me? marcmorris@attbi.com

I don't believe there is any way to dump a table to a .csv file except from within FoxPro. To do it from a command prompt you could create a small prog and compile it into a .exe to be run from a batch file. The documentation says 'COPY TO myfile.csv type CSV DELIMITED WITH ","', but...

Does anyone know where to locate the help files for activex controls? I am particularly interested in MScomm32.ocx. The name of the file (I believe) is comm98.chm. A search for a file of that name only turns up 3 files that contain that string.