Not a foxpro person, I was looking at the SQL. Unfamiliar with this syntax requirement.
I see this is what you mean:
DELETE FROM MyTable ;
WHERE CustNo IN ;
(SELECT CustNo FROM MyTable ;
WHERE CustNo IN ;
(SELECT CustNo FROM Test1) ;
GROUP BY CustNo ;
HAVING...
Is this what worked ?
DELETE FROM MyTable WHERE CustNo IN (
SELECT CustNo FROM MyTable WHERE CustNo IN (SELECT CustNo FROM Test1)
GROUP BY CustNo HAVING COUNT(*) > 1 );
Here are a few date calculations that may offer some insight.
Sub SomedateStuff()
10 Debug.Print "First Day of Week is Sunday"
20 Debug.Print "First day Last Week " & DateAdd("ww", -1, Date - Weekday(Date) + 1)
30 Debug.Print "Last day Last Week " & DateAdd("ww", -1, Date -...
Have you considered?
- a copy of the database for your testing totally separate from the copy being used by the accountant
- a database /table designed specifically for you to "tune your skills" before working with the "official" database
Either option would allow you to check/revise the...
Are the Terms and Conditions consistent for all Contracts? That is, is it boiler plate with customization for a few fields. If so, then you may get some insight from this code/sample.
' ----------------------------------------------------------------
' Procedure Name: testStr
' Purpose: To...
You can find details by Google search
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.locknavigationpane
https://docs.microsoft.com/en-us/office/vba/api/access.docmd.navigateto
It's been years, but I have used a single front end (form with combo) to select and use tables in multiple back ends. The BEs were different Oracle environments (dev, test, prod, maint) .
See these link andLink for info.
You seem to be missing some commas in the sql you posted???
SELECT tblO.DateL
,ROUND(SUM(tblO.A + tblO.B + tblO.C), 2) AS Ovs
,COUNT(tblO.Client) AS NumCl
,tblR.Reas
FROM (
tblO LEFT JOIN tblR
ON tblO.CLIENT = tblR.CNr
)
GROUP BY tblO.DatumL
,tblR.Reas
,[tblR].[DateN] <= [tblO].[Datel]...
Vic,
I am not aware of any feature to watch code as it executes. What I often do for debugging is the following:
Add a line in each or selected procedures to indicate that procedure has been entered. You can also include Now() to show the time.
I add a global boolean variable to allow this...
I am new to Powershell.
I have the following script. I am trying to determine the powershell "code" to identify which, if any, "field" is an array or hashtable.
$txt = @"
{
"id": "02002010",
"booktitle": "",
"pagetitle": "Demo Page",
"parent": "02002000",
"img": [
{...
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.