The last one gives me a "Operation must use an updateable query.
Your posting at 1:19 seems to solve the problem (sort of). I haven't established theexact number that causes it to blow up. But it appears that it doesn't run when part of the Analysis table is to big. I haven't been able to hunt...
That last one would be what did it.. Unfortunately I also just figured oout that Dcount blows up when you feed it a large amount of records programatically (system resources exceeded). However, it does work when embedded as a query in Access.
So with that in mind. I guess my VB will just call...
Hi All
First off, let me say thanks for any advice or help you can provide with this problem. So I’m a bit confused with whats going on right now. I have two sets of tables that I need to run a DCOUNT routine (VBA) on and I am at a loss why the second one isn’t working programmatically.
The...
thargtheslayer
Thansk for the heads up.. Ironically, I did get tsk-ed tsk-ed on that approach earlier today. I think the current way will be to keep the table structure but just delete everything inside it.. (TRUNCATE, I think..)
-e
I don't know if this answers the question or not about the "business need" end of things or not. But I figure I should give it a shot. And to be honest I’m a little concerned that I’m doing my whole approach incorrect. But I hope I have a decent enough head on my shoulders to be doing this thing...
Thanks for the help. It worked using the approach above, but it was very pokey (slow) 785 seconds for the query.
I just want to verify something here.. The suggested approach earlier was to effectiverly run that as four different commands, right? (Make Table, Make Index, Run Update, Delete...
Sorry for the slow reply, I just got out of 6 hours of meetings..
update analysis a
set NMBR_TRP =
(select Count(*) from analysis s
where a.tripid = s.tripid);
It just keeps running. I had to cancel the operation. This brought up warning bells from an earlier posting I had which...
update a
set NMBR_TRIP = FREQ
from Analysis A join
(SELECT ANALYSIS.TRIPID, Count(*) AS Freq
FROM ANALYSIS
GROUP BY ANALYSIS.TRIPID) S
on A.tripid = s.tripid
give me a
ORA-009933: SQL Command not properly ended..
(I also get the same error with the semicolon at the end, If that matters)
Hi All, first off let me preface this posting by saying I am an Access guy who is still learning how to do some things in Oracle.. and therein lies my issue. Any help or suggestions would be greatly appreciated. I’m assuming something along these lines is possible, right??
I have a table...
DING DING DING DING...
That would be the correct answer.. Thanks!
It works, but it is ridiculously slow, (but I'll deal with that later...)
I must say I don't quite understand everything to do with indexes, but three of those fields did not have any indexes associated with them.
Thanks Again
-e
Mufasa
First off thanks for the advice, but I still seem to be chasing my tail here…
If I understand what you said earlier. (paraphrasing) Basically, we need to address every field that included in the select statement. Such that if we have a MAX(or whataver..) in the select statement. Then...
In answer to your first question about why my last code snippet didn't work..
I got a "ORA-00979 Not a GROUP BY expression"
And I'm in the middle of playing with what you suggested . I initially got an error that it was "Not properly ended" but I think that was the second )) in
AND...
Hi All
First off let me state that any assistance that could be assistance/suggestions with this would be greatly appreciated… And I’ll give you the disclaimer to start. I’m an Access guy who is learning painfully that Access SQL isn’t quite the same as is required for Oracle..
But this works...
Golom
Thanks for the reply. Quite interesting code (I wouldn't have thought to do it that way). And it works perfectly for when the STEP in under a year in length. But you nailed the problem on the head with how to represent steps greater then a year.
Optimally, using your example from up...
I couldn't figure out how to do it in SQL (or if it was even possible).. SO if anyone cares. the VB code.
Private Sub cmdStepApply_Click()
DoCmd.SetWarnings False
cmdApply.Enabled = True
Dim DateSpan As Integer
Dim DateSpanYear As Integer
Dim TotalYearGap As Integer
Dim StepEndYear As Integer...
Okay guys and help/advice/suggestion would be greatly appreciated. I hope this explanation I sufficient
I have a user form which requires the user to dictate a STARTDATE and ENDDATE,I also have the user have the option to dictate a STARTSTEPDATE and ENDSTEPDATE field. I need to be able to...
Thanks for the heads up. I'll be giving that a shot right after lunch..
And as far as the field names are concerned. Yup, I'm was aware of that (somewhere in the back of the brain). I changed/simplified the field names a bit before I posted the sample table and wasn't thinking about key words...
Never mind... I'm an idiot and just figured out the easy way..
MONTHS
Step: Format([Analysis]![DATE],"m yyyy")
Quarters
Step: Format([Analysis]![DATE],"q yyyy")
etc.
-e
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.