To remove duplicate records from a table. What field(s) determine a duplicate, such as
SSN, or SSN and code assignment. In my example shown I use SSN and a code that desinates a group assigned to. The SSN can have more then one unique code assignment.
First verify duplicates with...
check out microsoft site
http://msdn.microsoft.com/library/?url=/library/en-us/devio/base/idiscmaster.asp
I have not used it yet.
Attitude is Everything
I use this to find if a file exist on a users system at the time of running setup.exe. If the file exist I can then take other action. This example only searches for the file once, if found, returns the path.
PARAMETERS lcPath, lcfile
** find file located in the path passed or subfolder...
By default, each thread has an independent input state (its own active window, its own focus window, and so forth). The SetActiveWindow() function always logically sets a thread's active window state.
To force a window to the foreground, however, use SetForegroundWindow()...
try this
loExcel.ActiveSheet.PrintOut(1,1,1,.F.,"CutePDF Printer",.T.,.T.,"C:\"+ALLTRIM(mquotenum))
thinking that your print driver will automatically add the pdf. mine does
Attitude is Everything
You need a JOIN condiction in your FROM
FROM dbo.tmp_PTO_AccesstoSQL a LEFT OUTER JOIN
dbo.tlkp_PTO_Plan_Basis b ON a.simfield = b.simfield
Attitude is Everything
select usrID, count(usrID) from Yourtable WHERE useID LIKE '%test%'
This will count all usrID's that have test in the field
'test%' = all usrID's with test at the first part of the field
Attitude is Everything
DISTINCT is not needed in this. COUNT(localaddr) with the group by localaddr is the key. If you want to get a listing based on localaddr count add HAVING
SELECT LocalAddr, COUNT(LocalAddr)
FROM firsttbl
GROUP BY LocalAddr HAVING COUNT(LocalAddr) > 3
Attitude is Everything
instead of
"If present open it and save it as AARVARK,ANN,01 January 1985... move on to the next one.
"
RENAME FileName1 TO FileName2
Attitude is Everything
lot to cover, try going to http://support.microsoft.com/kb/
do a search on
HOWTO: Set Up an Offline View in Visual FoxPro
As with online data, analyze your requirements before creating offline views to determine the design of the views you will need in the offline database. Once you know the...
If local workstations have hard drives with plenty of free space, you can improve performance by placing these temporary work files on the local drive or in a RAM drive. Redirecting these files to a local drive or a RAM drive increases performance by reducing access to the network drive.
You...
' Get the number of rows of the selection.
RowCount = Selection.Rows.Count
' Get the number of columns of the selection.
ColumnCount = Selection.Columns.Count
' Activate the last cell of the selection.
Selection.Cells(RowCount, ColumnCount).Activate
Attitude...
BCL Drake COM Object is a convenient way to programmatically access BCL Drake's PDF to Word / RTF conversion module, giving you a way to maximize efficiency in a way that no prepackaged software can.
http://www.bcltechnologies.com/document/products/drake/drake_com.htm
Attitude is Everything
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.