I know there's a way to do this via insert SQL, but my brain is too addled to
function... I must add rows where the values in those rows are not already
present in a table. It's something like:
insert into <table1> (field1, field2) from <table2> where not exist (select

Is there a way to turn off the 'navigation' sound w/ automation code.?
This is the clicking sound when IE page loads. I know I can turn this
off on my own computer
thru Control Panel - but I need to do this in my application.

Group,
Is there any way to get around a trigger when trying to remove a duplicate
record? I get 'trigger failed' , of course. Would I have to delete the
procedures (i.e modify procedures) and redo them after the delete?

I am in Montreal looking to hire a VFP developer.  The application is
human resources and payroll. Knowledge of West Wind WebConnect would
be an asset. Bilingual French-English also.
(Is this the right place to post this?)

I am using COPY TO command copy a file with a long file name which
containing space from a windows XP to a Windows 2003 Server. Originally the
file name is in large capitalize. But after copy to the 2003 server, the
file name becomes small captialize.

VFP8 SP1 on XP Pro SP2
I have some code that was running a bit slowly:
 SELECT DISTINCT colToFix ;
 INTO ARRAY colArray ;

I am looking for a function that returns all the administrators of a given
workstation. Does somebody know?

Is it possible to turn a date to an integer?
jm*

I've been developing in Foxpro for about 10 years now.
With the news from Microsoft that development has now ceased and it's
exclusion from the Visual Studio framework I've been considering moving away
to something with more longjevity?

I am trying to display an information form whilst other processing continues.
I cannot use WAIT as it won't accept a text variable (required) or
MESSAGEBOX as it always waits for user acknowledgement. I want to display a
window which has text coming from a variable but continue ...

hy,
i need programming code, i trying select foto from mysql into client program
FoxPro,but nothing.

I am trying to use the My object in a program.  When I run it on my
computer, it works fine, but when I run it on another computer, it
fails.  Here is the code:
My = newobject('My', 'my.vcx')

Whats the command to export the results of a query as a HTML page? I
can do it by clicking "FILE" --> "SAVE AS HTML" but I want to setup a
real simple program to query and spit out a *.html file... any ideas?

A couple of quick questions about the vfp9 development environment
1. Is there a way to lock the properties, data session and command windows
in place so that each time I restart they are in the same spot and docked
the way I last used them or if I inadvertently close them they ...

How, when you copy a dbf out to an XLS file, how can you make the date range
sortable?  What I am getting is the field is only sorting my month, not
month/day/year.   Any knowledge that you can share would be great.
Respectfully,