(new) Databases

New Question - what does this (oracle) syntax mean? - (tuberculosis) - (18) - Jan. 31, 2004, 10:03:21 PM EST

Left join. - (admin) - (17) - Jan. 31, 2004, 10:27:02 PM EST

Oy - (tuberculosis) - (16) - Feb. 1, 2004, 12:43:45 AM EST

Ick. -NT - (admin) - (7) - Feb. 1, 2004, 12:48:54 AM EST

Way - (tuberculosis) - (6) - Feb. 1, 2004, 12:56:26 AM EST

Looks to me like it was generated from icky tools. - (FuManChu) - (2) - Feb. 1, 2004, 01:23:50 AM EST

Naah; we manually write shit like that all the time. :-( -NT - (CRConrad) - (1) - Feb. 1, 2004, 07:42:34 AM EST

Yeah - a tool would use consistent capitalization -NT - (tuberculosis) - Feb. 1, 2004, 10:25:24 AM EST

Just start breaking it down. - (admin) - (2) - Feb. 1, 2004, 10:38:15 AM EST

That's the plan - (tuberculosis) - (1) - Feb. 1, 2004, 10:53:22 AM EST

Yeah, 'zackly, we use views like that all the time. :-( -NT - (CRConrad) - Feb. 1, 2004, 10:57:25 AM EST

Relax; you'll get the hang of it pretty quickly. - (CRConrad) - (1) - Feb. 1, 2004, 10:56:19 AM EST

I'm saving those for dessert - (tuberculosis) - Feb. 1, 2004, 05:02:11 PM EST

Dumb question on the second statement - (boxley) - (4) - Feb. 1, 2004, 11:29:17 AM EST

Then, in the Bronze Age, the Query Optimizer was invented... -NT - (CRConrad) - (2) - Feb. 1, 2004, 12:39:31 PM EST

Which typically chokes with too many joins. -NT - (admin) - (1) - Feb. 1, 2004, 02:36:35 PM EST

Yeah, well; whaddaya expect, from Bronze-Age technology? :-) -NT - (CRConrad) - Feb. 1, 2004, 04:09:57 PM EST

Depends on the optimizer... - (Simon_Jester) - Feb. 2, 2004, 11:41:39 AM EST

Left join in the new SQL standard syntax - (Simon_Jester) - Feb. 2, 2004, 11:44:48 AM EST

Porting Oracle Delete Trigger to PGSQL - (tuberculosis) - (10) - Jan. 31, 2004, 07:33:40 PM EST

It's just "OLD". - (admin) - (9) - Jan. 31, 2004, 07:45:59 PM EST

Re: It's just "OLD". - (deSitter) - (8) - Jan. 31, 2004, 08:07:46 PM EST

About what? - (admin) - (7) - Jan. 31, 2004, 08:11:10 PM EST

Re: About what? - (deSitter) - (5) - Jan. 31, 2004, 08:13:19 PM EST

Here's the thing, though: - (admin) - (4) - Jan. 31, 2004, 08:32:36 PM EST

dont admit stuff like that! - (boxley) - (3) - Jan. 31, 2004, 08:35:16 PM EST

Pah. - (admin) - (2) - Jan. 31, 2004, 08:40:04 PM EST

We don't have the same manual then - (tuberculosis) - (1) - Jan. 31, 2004, 09:45:02 PM EST

I didn't find an example. - (admin) - Jan. 31, 2004, 10:23:19 PM EST

Online PostgreSQL book - (ChrisR) - Jan. 31, 2004, 08:16:28 PM EST

Replace function in MSAccess - (ChrisR) - (10) - Jan. 16, 2004, 03:16:38 PM EST

ObVB Mid$ -NT - (deSitter) - (6) - Jan. 16, 2004, 03:55:30 PM EST

...with ObVB InStr() -NT - (FuManChu) - Jan. 16, 2004, 04:55:28 PM EST

Problem with that function - (ChrisR) - (4) - Jan. 16, 2004, 07:29:47 PM EST

Re: Problem with that function - (deSitter) - (1) - Jan. 16, 2004, 08:13:38 PM EST

That can be dangerous for some cases - (Arkadiy) - Jan. 17, 2004, 02:25:06 PM EST

Why write when you can Copy-n-Paste? ;) - (altmann) - (1) - Jan. 17, 2004, 01:46:47 AM EST

That's not going to run very well... - (FuManChu) - Jan. 17, 2004, 12:50:18 AM EST

Which Version of Access? - (altmann) - (2) - Jan. 16, 2004, 04:04:53 PM EST

Access 2000 - (ChrisR) - (1) - Jan. 16, 2004, 07:27:14 PM EST

Access 2000 should have it - (altmann) - Jan. 16, 2004, 10:05:36 PM EST

Public Universal variable. - (acagle) - (8) - Jan. 5, 2004, 12:38:18 PM EST

Put them in a module. - (mmoffitt) - Jan. 5, 2004, 12:44:37 PM EST

Several ways - (FuManChu) - Jan. 5, 2004, 02:10:31 PM EST

Well. . . . . - (acagle) - (5) - Jan. 5, 2004, 05:35:29 PM EST

Is the object globally scoped? -NT - (mmoffitt) - (4) - Jan. 6, 2004, 09:02:22 PM EST

Re: Is the object globally scoped? - (acagle) - (3) - Jan. 9, 2004, 04:26:47 PM EST

Answering the other question - (ben_tilly) - Jan. 9, 2004, 04:49:38 PM EST

If Ben's answer doesn't help. - (mmoffitt) - (1) - Jan. 10, 2004, 08:49:06 AM EST

PARAMETERS also available in Access SQL - (FuManChu) - Jan. 10, 2004, 11:46:51 AM EST

Securing a SQL Server - (Yendor) - (1) - Dec. 26, 2003, 01:23:02 PM EST

Re: Securing a SQL Server - (orion) - Dec. 26, 2003, 05:52:16 PM EST

SQL/Server rant for the day - (broomberg) - (5) - Dec. 17, 2003, 04:52:44 PM EST

Moral of the story is... - (ChrisR) - (1) - Dec. 17, 2003, 04:55:36 PM EST

What he said. -NT - (mmoffitt) - Dec. 18, 2003, 09:49:39 AM EST

Won't it be interesting when... - (FuManChu) - Dec. 17, 2003, 05:25:05 PM EST

Yet again MS show a single-user mentality. - (static) - (1) - Dec. 19, 2003, 05:00:05 AM EST

No choice - (deSitter) - Dec. 19, 2003, 06:19:01 AM EST

SQL/Server roles - (broomberg) - (2) - Dec. 17, 2003, 03:09:51 PM EST

Hmm... From MS' (confusing) Web site: - (CRConrad) - (1) - Dec. 17, 2003, 03:32:16 PM EST

I gave up - (broomberg) - Dec. 17, 2003, 04:49:28 PM EST

Keyboard remapping. - (acagle) - (9) - Dec. 11, 2003, 12:38:31 PM EST

Re: Keyboard remapping. - (acagle) - (4) - Dec. 11, 2003, 12:56:10 PM EST

Re: Keyboard remapping. - (deSitter) - (3) - Dec. 11, 2003, 01:35:51 PM EST

Gazillion levels between Access 2000 and keyboard interrupt - (Arkadiy) - (1) - Dec. 11, 2003, 01:49:50 PM EST

rofl - (deSitter) - Dec. 11, 2003, 01:54:36 PM EST

May have got it. - (acagle) - Dec. 11, 2003, 04:04:01 PM EST

Final update. - (acagle) - (3) - Dec. 12, 2003, 01:43:19 PM EST

Re: Final update. - (deSitter) - (2) - Dec. 12, 2003, 02:05:21 PM EST

Re: Final update. - (acagle) - (1) - Dec. 26, 2003, 12:26:32 PM EST

I do now (re: F8). - (altmann) - Dec. 26, 2003, 03:11:21 PM EST

Home made DTS objects in SQL/Server - (broomberg) - (11) - Dec. 8, 2003, 10:48:11 AM EST

You mean MTS objects? - (deSitter) - (10) - Dec. 8, 2003, 11:58:06 AM EST

DTS = Data Transformation Services - (altmann) - (9) - Dec. 8, 2003, 05:04:15 PM EST

ok, my bad thought that was "distrib transact" -NT - (deSitter) - Dec. 8, 2003, 05:07:20 PM EST

Thanks - (broomberg) - (7) - Dec. 9, 2003, 06:43:55 AM EST

That might be doable - (ben_tilly) - (6) - Dec. 9, 2003, 11:29:51 AM EST

Further reading shows much worse - (broomberg) - (5) - Dec. 9, 2003, 06:47:41 PM EST

VB works well doing this. - (mmoffitt) - (4) - Dec. 10, 2003, 08:55:30 PM EST

IIRC SQL Server can export to a VB Module - (orion) - (1) - Dec. 10, 2003, 09:28:49 PM EST

My past experience - (lincoln) - Dec. 11, 2003, 06:46:29 PM EST

Re: VB works well doing this. - (deSitter) - (1) - Dec. 10, 2003, 09:48:34 PM EST

VB.NET is sort of like Visual C++ now - (orion) - Dec. 11, 2003, 08:08:50 AM EST

Date+time in Access. - (acagle) - (7) - Dec. 5, 2003, 01:15:19 PM EST

Works in Microsoft Access 2002 - (SpiceWare) - (4) - Dec. 5, 2003, 01:51:06 PM EST

Oops. - (acagle) - Dec. 5, 2003, 01:54:06 PM EST

Bingo. - (acagle) - (2) - Dec. 5, 2003, 01:57:38 PM EST

Re: Bingo. Unpdate. - (acagle) - (1) - Dec. 5, 2003, 02:39:03 PM EST

I can verify that - (orion) - Dec. 5, 2003, 03:30:31 PM EST

Check the date format. - (jbrabeck) - (1) - Dec. 5, 2003, 02:07:53 PM EST

Oops. Took too long formating the reply. Disregard prior. -NT - (jbrabeck) - Dec. 5, 2003, 02:08:57 PM EST

Welcome to IWETHEY!