MySQL lacks a ton of features that PostgreSQL has...Foreign keys, triggers, stored procedures, etc. That is basically the argument that gets thrown around alot. As for speed, that is the one thing that MySQL always touts. But I've seen testimony that PostgreSQL is no slouch either.
Depends on...
This is a decent print box. I have a client using it for the past couple of years.
If you have XP, XP supports it directly (not sure if 2000 does or not).
Try single quotes instead of the double quotes.
Also make sure you have a beg_date is not null in your where clause on the first part of the union.
Do the queries run by themselves when not UNIONed?
Sorry can't be more help. I ran this through SQL Server and it ran fine....I thought perhaps...
Basically you want to set the rowsource property of the 2nd combo box during the afterupdate event of the 1st combo box.
Now what you set the rowsource to is up to you, you could set it to seperate queries you created or you could roll your own select statement.
If you want to dynamically...
My experience is like the others. I'll give you my story.
Got it done on a Friday afternoon last December. Three other guys in the waiting room, wives in tow, jockstraps in hand all waiting for the big snip.
I didn't have to trim and shave, they would do that. Of course visions of a...
Combine count with the having clause
select userid from tableabc
group by userid
having count(userid)>1
order by userid;
What database platform is this for?
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.