Thank you so much for being patient with me. That worked perfectly. I'm not sure if one is preferable to the other as far as speed goes, but I think that I like the simplicity of the NOT EXISTS.
In my quest to learn SQL I will try to take as much from those two examples as I can.
Based on a little research, this is what I tried (but it didn't work):
SELECT *
FROM all_orders
OUTER WHERE NOT
EXISTS (
SELECT *
FROM joes_orders
INNER WHERE inner.order_ID = outer.order_ID
);
I'll keep trying different things, but if anyone could tell me where I'm going wrong, I would...
Well, this is not the actual layout or purpose of the tables, but it is a comparable example. For any possible future legal reason I'm not too comfortable giving the actual tables. However, for the purposes of my question, the example I gave is identical in theory to the actual situation...
I'm having a bit of trouble with conceptualizing this problem. I'm pretty new to mysql and I'm working on my first large-scale project.
Here's what I'm trying to understand. I have a table that keeps track of all orders. Then, each person can add one of those orders to their table. When...
This is a simple question for seasoned vets, but I am new to database programming.
I have a table for cake orders and a table for cupcake orders. I had to split the two because the table columns are completely different (e.g., I have different requirements for the different orders).
However...
I have been a programmer much longer than I have been a database developer. I see the error of my way. As I suspected--and your "harsh" words echo--I didn't even know how to approach the idea; however, that is mostly because I don't know much about Access. I thought that it might be a good...
TheAceMan1,
I have uploaded the file to 4shared: http://www.4shared.com/document/BMtSEg5H/timesheetDB.html
I have created a very simple version, but for the most part it is what I want a larger version to look like, except with more queries and reports. Basically, the structure that I want is...
Thank you very much TheAceMan1. That looks like the perfect solution. I just have one problem. I am very proficient with many different languages but VBA is not one of them. I really feel bad for asking--I don't want you to have to put forth more effort in correcting my ignorance than you...
Two parts to this question.
1) Can you create VBA for a table only?
2) Can you create a form in VBA on a table that will only make the table visible if the correct password is entered?
Reason: I need to make certain tables viewable to only certain people. I've created tables that my employees...
I was thinking that if you put a stop() on the first scene, and then on the end of the text exploding effect put a gotoAndPlay() with the scene name for scene two as the reference, that that will work. Then at the end of scene two you will need to also put a stop(). That way the text effect...
If you press buttonA and you always have the same sequence, like, scene 4 then scene 8, then on the last frame of scene 4 put a gotoAndPlay() function. Inside the gotoAndPlay() function use a scene name to refer to scene 8, instead of the number. This way if you ever add scenes or delete scenes...
The first brackets do not require the leading dot syntax, as in _root[myInstance]. However, after that, especially when referring to functions of and properties of myInstance, you would use the dot notation. The same as in _root.myInstance._x. I think that in their example they are not referring...
The dot syntax replaces the [] syntax. They are synonymous. If you us the brackets to refer to an instance, then you don't use the dot, as in _root[myInstance]. However, if you refer to a property or function of myInstance, and still want to use the [], then you also use the dot, as in...
What I suggested is the easiest possible solution to what you are requesting. If you run a normal preloader to make sure that all of your frames are loaded, you can start the animation of the doors opening upon the conclusion of the preloader. If you made the doors sequence a movie clip with the...
I would advise not doing it with scenes. I would put the underlying website on a lower layer than the doors animation, but on the same scene. The doors opening won't affect your website that hides underneath. After the animation has run for the doors opening, I would have the rest of the frames...
It really depends on how the lines move to form the box, and if the cross and box are 2D or 3D. If the cross and box are 2D and the horizontal line of the cross splits into two lines, then you could make each line a MC, and slowly progress the lines to their final destination. You would also do...
The _root is the main timeline. Let's say that your movie clip is called box. On frame 1 of the main timeline, type in:
box._visible = false;
Now on frame 10 type:
box._visible = true;
Make sure that your movie clip is on the stage of the main timeline, and you have given it an instance name...
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.