From where to, I dunno
-
SELECT [SELECT], [FROM], [TO], [WHERE], [ORDER] FROM [WHERE] WHERE [WHERE]='GROUP BY OR HAVING'
This blanket smells like ham
:laugh: This same schema just caught me again, as I have a policy of naming all my DAL parameters the exactly the same as the column names, which works Ok until a column that is called IsNew in a view is actually called 'new' in the table.
-
Who the hell names database fields 'from' and 'to'? Need I say more? :mad:
An Apple for Eve, A button for Steve, It never ends. . . bramster on Worse Than Failure My new blog.
Database designers who don't have to write any SQL. :)
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
-
Database designers who don't have to write any SQL. :)
Chris Meech I am Canadian. [heard in a local bar] Donate to help Conquer Cancer[^]
I also deal with gems like Tax%. Hey, 'like Tax%'...
-
Who the hell names database fields 'from' and 'to'? Need I say more? :mad:
An Apple for Eve, A button for Steve, It never ends. . . bramster on Worse Than Failure My new blog.
I myself just created a table named Group. I also have a table named Parameter. And a field named When. But (so far) only I need to deal with them.
-
I myself just created a table named Group. I also have a table named Parameter. And a field named When. But (so far) only I need to deal with them.
PIEBALDconsult wrote:
But (so far) only I need to deal with them.
So you still have the chance to fix this foolishness before it gets into the real world... ;-P
------------------------------------------- Don't walk in front of me, I may not follow; Don't walk behind me, I may not lead; Just bugger off and leave me alone!!
-
I myself just created a table named Group. I also have a table named Parameter. And a field named When. But (so far) only I need to deal with them.
PIEBALDconsult wrote:
And a field named When
And a field named "Poof"? :)
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips: - use PRE tags to preserve formatting when showing multi-line code snippets - before you ask a question here, search CodeProject, then Google
-
SELECT [SELECT], [FROM], [TO], [WHERE], [ORDER] FROM [WHERE] WHERE [WHERE]='GROUP BY OR HAVING'
This blanket smells like ham
That reminds me of some fun I used to have (aeons ago) in Coral-66:
'FOR' FOR = 0 'TO' TO 'STEP' STEP 'UNTIL' UNTIL
'BEGIN'
BEGIN;
END;
'END'something like that anyway - I can't remember the exact syntax
Phil
The opinions expressed in this post are not necessarily those of the author, especially if you find them impolite, inaccurate or inflammatory.
-
PIEBALDconsult wrote:
And a field named When
And a field named "Poof"? :)
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips: - use PRE tags to preserve formatting when showing multi-line code snippets - before you ask a question here, search CodeProject, then Google
I once had to deal with a database that had dashes in the field names. That was the first time we ever had to lookup how to quote identifiers and were horrified to find that there was no standard. What worked on one system just made it a quoted string on another. :wtf: Meddle not in the affairs of dragons, for you are crunchy and taste good with catchup.
-
Who the hell names database fields 'from' and 'to'? Need I say more? :mad:
An Apple for Eve, A button for Steve, It never ends. . . bramster on Worse Than Failure My new blog.
-
PIEBALDconsult wrote:
And a field named When
And a field named "Poof"? :)
Luc Pattyn [Forum Guidelines] [My Articles]
this months tips: - use PRE tags to preserve formatting when showing multi-line code snippets - before you ask a question here, search CodeProject, then Google
Not yet, waiting to hear back from the manufacturer.