Does the task of find the duplicate rows of 1,3 in the table below REALLY
have to be done with two separate select statements?
Table Test:    one, two: 1, 2; 1, 3; 1, 3
SELECT one, two, COUNT(two) ;

I'm having problems getting ODBC set up with SS 2005. I believe I need MDAC
2.8, but the latest ODBC for FoxPro is 2.6. I tried to upgrade to 2.8 but it
says it won't work with this OS (XP). Any ideas?
Thanks in advance,

I hope Im posting in the right newsgroup.  I am trying to insert the result
of the below SQL query in my Access 2003 table.  All the fields in this table
are of type Number.  I'm picking up the value of a dropdownlist box and
insert the relevant values in one row of the table.  

I have a table 'purchases' as follows:
customerid (Number)
trackid (text)
date (date/time)

 I just find out my table become read-only after i open a local view,
i only can access and make amendment after close it, is that so ? then
what happen to multiuser environment ? if i open the view, is it mean
that other user cannot open the table at all ? then i try to change the

We use a DBC to store remote views.  The database connection
information in the DBC is relatively easy to see, even with Notepad.
Does anyone have any suggestions for providing some security for the
connection information?

ok, I'm doing a calc between a few fields and I don't want the answer to
display decimals so I created the output field as numeric with no decimals.
So, VFP rounds everything up. Is there a way to allow it to round but to
round down if the decimal is .49 or less and up if it is  ...

Hi, I am having a problem with my application nTier
I have a tier that do sqlexec() for remote date or execscript for local data
(VFP Tables)
my SqlExecute is working fine for SELECT with ?var parameters, but If I try