Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

dBforums - Database Support Community - www.dbforums.com | Site profile

Site profile page for http://www.dbforums.com. This report page has aggregated and summarized the online discussions from the Message Board located at http://www.dbforums.com. This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional site profile information for http://www.dbforums.com is also shown in the following divisions:

1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.

Title: dBforums - Database Support Community - http://www.dbforums.com dBforums - Database Support Community
Url: http://www.dbforums.com
Users activity: 0 posts per thread
site activity: 0 active threads during last week
Domain info for: dbforums.com
 

Posting activity table on dBforums - Database Support Community:

  Week Month 3 Months
Threads: 0 0 0
Post: 0 0 0
 

Authority Badge:

dBforums - Database Support Community | Forum Authority Badge

dBforums - Database Support Community posting activity graph:

Posts by:  day  week  month 
 

http://www.dbforums.com Alexa graph:

Top authors on dBforums - Database Support Community during last week:

Name
Posts
pootle flump
84
user's latest post:
Minimising the Ribbon
Published (2009-11-06 12:40:00)
I have just started looking at playing around with the ribbon in VBA, and have learned enough that it is a blooming nightmare. I am scaling down my plans. I think that I would be satisfied with minimising the ribbon. To do this I think I either need to: 1) Read the registry to see the current ribbon state and conditionally use Send Keys to minimise the ribbon if it is currently maximised (yuck) 2) Download some tool from MS, read a heck of a...
Brett Kaiser
64
user's latest post:
Opinion Needed
Published (2009-11-07 20:25:00)
No, you are thinking correctly, but missing the bigger point That Value of doing this, is, as you mentioned, adding valid alues along the way, but the bigger point is to ensure Referential Integrity Just understand, you will not be able to remove any code values if they still exists in Issues...which is not really a big deal
Thrasymachus
59
user's latest post:
The Yak Corral, part IX - Page...
Published (2009-11-06 17:33:00)
just busy. off to vegas for connections. later.
blindman
56
user's latest post:
The Yak Corral, part IX - Page 9...
Published (2009-11-06 16:26:00)
MCrowley: Did you reboot server X? Helpdesk: (quietly) I did the job you sent me to do. MCrowley: Did you reboot server X? Helpdesk: You're goddamn right I did!!
Lenny77
51
user's latest post:
Absolute SUDOKU Solver - Page 4...
Published (2009-11-06 17:07:00)
11/06/09 "Metro" NY, page 29 HARD --> 1 sec <-- Code: Source (line, sudoku_str) as ( select 1, '020090800' from sysibm.sysdummy1 union all select 2, '600270003' from sysibm.sysdummy1 union all select 3, '000006210' from sysibm.sysdummy1 union all select 4, '000700008' from sysibm.sysdummy1 union all select 5, '702804109' from sysibm.sysdummy1 union all select 6,...
db2girl
38
user's latest post:
Where I can get the DUMPS of...
Published (2009-11-07 21:04:00)
Quote: Originally Posted by prashantopel Thanks How to create dummy database for practice in DB2 9.7? From DB2 Command Window, enter: db2 create db db2dummy I'd have suggested to create a db called db2dummy1 if db2 allowed the db name to be more than 8 char.
gvee
37
user's latest post:
The Yak Corral, part IX - Page...
Published (2009-11-07 11:10:00)
Quote: Originally Posted by r937 oh, give over From that Wiki page: Quote: # (British, idiomatic) Usually as an imperative. To tell someone to stop molesting , fooling around, or saying silly things. Or sometimes to stop saying flattering things. Give over with your nonsense, will you! WTF?!
mike_bike_kite
34
user's latest post:
Problems with this design?
Published (2009-11-07 17:31:00)
Quote: Originally Posted by magicmoose Can anyone help me work out the problems with my approach and a better way to go about attacking the problem? You haven't really told us what your system does or what it is you're trying to model so it's impossible giving you solid examples of why your design won't work. Nevertheless I agree with your friend who said the design is poor. Let's say we're displaying a page on a...
leebaggaley
33
user's latest post:
Can anyone help?
Published (2009-11-05 11:11:00)
resolved thanks for your help
pkstormy
33
user's latest post:
Tricky Data Format Validation
Published (2009-11-07 23:01:00)
Otherwise one way (although someone can probably shorten this syntax or come up with something better) is something like this in the AfterUpdate event of the field: If not instr([MyFieldName],"v") and not instr([MyFieldName],"0") and not instr([MyFieldName],"1") and not instr([MyFieldName],"2") and not instr([MyFieldName],"3") and not...
 

Top 10 active forums on dBforums - Database Support Community during last week:

Microsoft Access - 387 new posts Microsoft Access - forum profile
DB2 - 346 new posts DB2 - forum profile
Microsoft SQL Server - 261 new posts Microsoft SQL Server - forum profile
Chit Chat - 157 new posts Chit Chat - forum profile
Oracle - 152 new posts Oracle - forum profile
MySQL - 51 new posts MySQL - forum profile
Database Concepts & Design - 47 new posts Database Concepts & Design - forum profile
Sybase - 46 new posts Sybase - forum profile
PostgreSQL - 28 new posts PostgreSQL - forum profile
Microsoft Excel - 25 new posts Microsoft Excel - forum profile
 

Top 10 forums on dBforums - Database Support Community:

Microsoft Access - 26,736 posts Microsoft Access - forum profile
Microsoft SQL Server - 22,660 posts Microsoft SQL Server - forum profile
DB2 - 20,434 posts DB2 - forum profile
Chit Chat - 13,762 posts Chit Chat - forum profile
Oracle - 11,926 posts Oracle - forum profile
Database Concepts & Design - 8,902 posts Database Concepts & Design - forum profile
MySQL - 8,579 posts MySQL - forum profile
Sybase - 3,956 posts Sybase - forum profile
Informix - 1,978 posts Informix - forum profile
Microsoft Excel - 1,901 posts Microsoft Excel - forum profile

Latest active threads on dBforums - Database Support Community:

dBforums - Database Support Community
Started 12 hours, 6 minutes ago (2009-11-08 21:45:00)  by diazed129
Thanks, good news, i'll check that.
Forum:  Marketplace Marketplace - forum profile
Thread:  Show this thread (2 posts) Thread info: New Oracle and MySQL conversion tools from DBConvert.com released! Size: 35 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Thanks, good news, i'll check that. :: Marketplace :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 day, 6 hours ago (2009-11-08 02:57:00)  by Derek Asirvadem
Nothing actually. It depends on how well or how badly your security model is set up. In a good security model, where all users have permissions (roles, or groups in the old paradigm) explicitly granted; and users are explicitly added to the db (to grant access to the db), there is no problem. In fact many security conscious orgs delete guest (user) and public (group). In a medium ...
Forum:  Sybase Sybase - forum profile
Thread:  Show this thread (4 posts) Thread info: Guest account Size: 1,433 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Nothing actually.

It depends on how well or how badly your security model is set up. In a
good... :: Sybase :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 14 hours, 4 minutes ago (2009-11-08 19:47:00)  by r937
oh noes!! i guess it was all my fault, i started IX and it was immediately a spam magnet
Forum:  Chit Chat Chit Chat - forum profile
Thread:  Show this thread (2 posts) Thread info: The Yak Corral X Size: 246 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: oh noes!!

i guess it was all my fault, i started IX and it was immediately a spam
magnet :: Chit Chat :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 14 hours, 59 minutes ago (2009-11-08 18:52:00)  by StarTrekker
(a) Use a rectangle. (b) Format - Align - Top/Bottom and Format - Align - Left/Right
Forum:  Microsoft Access Microsoft Access - forum profile
Thread:  Show this thread (2 posts) Thread info: Newbie - Borders and printing alignment Size: 117 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: (a) Use a rectangle.

(b) Format - Align - Top/Bottom and Format - Align - Left/Right :: Microsoft Access :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 4 days, 18 hours ago (2009-11-04 15:14:00)  by Teddy
Check help for "GROUP BY" as well as "Aggregate" functions. The jist of it is you want to "GROUP" your results by resident, and then use the SUM() aggregate function to produce the required result.
Forum:  Microsoft Access Microsoft Access - forum profile
Thread:  Show this thread (11 posts) Thread info: Retrieving data based on multiple field values Size: 244 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Check help for "GROUP BY" as well as "Aggregate" functions.

The jist of it is you want to "GROUP"... :: Microsoft Access :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 17 hours, 50 minutes ago (2009-11-08 16:01:00)  by pkstormy
Quote: Originally Posted by Karen Day Hi all, I want to: 'Check to see if the child record (subform) is a new record, 'if yes then copy some details from parent record to child record (subform). 'Parent Form is [eEmployer1HODetails] 'Child Form (subform) is [usysbeEmployer2SiteDetailsSubform] Is there a way to check ...
Forum:  Microsoft Access Microsoft Access - forum profile
Thread:  Show this thread (3 posts) Thread info: Check subform for new record then update fields Size: 4,690 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Quote:

	Originally Posted by Karen Day Hi all,
I want to:

'Check to see if the child record (subform)... :: Microsoft Access :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 1 day ago (2009-11-08 09:05:00)  by LKBrwn_DBA
You need to add the NOT NULL constraint if that is the requirement, otherwise you can leave as NULL if nulls are permitted.
Forum:  Oracle Oracle - forum profile
Thread:  Show this thread (4 posts) Thread info: FK column is automatic not null ? Size: 262 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Add it :: Oracle :: dBforums - Database Support Community"
dBforums - Database Support Community
Started 4 days, 23 hours ago (2009-11-04 10:51:00)  by scooby_at_work
Normally it's pretty reasonable to put a clustered index on your primary key. Assuming that by identity you mean the column is based on a sequence or something, that shouldn't matter one way or the other. A clustered index just means that the leaves of the index point straight into the data, and that the data is arranged, roughly, around the index. This means that you eliminate one seek when...
Forum:  Database Concepts & Design Database Concepts & Design - forum profile
Thread:  Show this thread (10 posts) Thread info: Would it be a good idea to index on an identity column? Size: 785 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Normally it's pretty reasonable to put a clustered index on your primary
key. Assuming that by identity you mean... :: Database Concepts & Design :: dBforums - Database Support Community"
 

Hot threads for last week on dBforums - Database Support Community:

Chit Chat
Started 1 week ago (2009-11-01 21:34:00)  by r937
well, there we go, it's gotta be a bot making those spam posts
Forum:  Chit Chat Chit Chat - forum profile
Thread:  Show this thread (147 posts) Thread info: The Yak Corral, part IX Size: 62 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: well, there we go, it's gotta be a bot making those spam posts :: Chit Chat :: dBforums - Database Support Community"
DB2
Started 6 days, 15 hours ago (2009-11-02 18:45:00)  by stolze
You need the aggregation of strings. XMLAGG or recursive queries are the standard answer for that.
Forum:  DB2 DB2 - forum profile
Thread:  Show this thread (88 posts) Thread info: Simple specs Size: 98 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: You need the aggregation of strings. XMLAGG or recursive queries are the
standard answer for that. :: DB2 :: dBforums - Database Support Community"
Microsoft Access
Started 6 days, 12 hours ago (2009-11-02 21:26:00)  by pbaldy
I'm not clear on the rest of it, but this can easily be simplified to: Code: If Me.dayname1 = "Sunday" OR Me.dayname1 = "Monday" Then Me.cmdday1am.Enabled = False Else Me.cmdday1am.Enabled = True End If If you're saying Me.dayname1 repeats like Me.dayname2, then I'd use a For/Next loop along with that.
Forum:  Microsoft Access Microsoft Access - forum profile
Thread:  Show this thread (49 posts) Thread info: Using more than 7 IF statements (or simplifying) Size: 633 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: I'm not clear on the rest of it, but this can easily be simplified to:

Code:

If Me.dayname1 =... :: Microsoft Access :: dBforums - Database Support Community"
Microsoft SQL Server
Started 6 days, 5 hours ago (2009-11-03 04:10:00)  by pootle flump
Farax x - probably neither. It sounds like you don't know too much about indexes but have heard that having some "speeds things up". it is also true that having some indexes can "slow things down". I would either read up on indexing in SQL Server, or run all you queries against your database and then run the Database Tuning Advisor to find out what queries are recommended. The former is the ...
Forum:  Microsoft SQL Server Microsoft SQL Server - forum profile
Thread:  Show this thread (35 posts) Thread info: put all columns in one index or create one index per column Size: 523 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Farax x - probably neither.
It sounds like you don't know too much about indexes but have heard that... :: Microsoft SQL Server :: dBforums - Database Support Community"
DB2
Started 5 days, 19 hours ago (2009-11-03 14:05:00)  by ARWinner
My guess is that your configuration is based on 16GB of memory, but 32 bit can only access 4GB. Anything over that is wasted. Andy
Forum:  DB2 DB2 - forum profile
Thread:  Show this thread (29 posts) Thread info: DB2 V9.5 - STMM errors Size: 148 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: My guess is that your configuration is based on 16GB of memory, but 32 bit
can only access 4GB.... :: DB2 :: dBforums - Database Support Community"
Microsoft SQL Server
Started 6 days, 5 hours ago (2009-11-03 04:33:00)  by pootle flump
You could use CROSS APPLY instead of JOIN. If the relationship between these two tables is 1:1 then you could use a subselect in your SELECT clause too.
Forum:  Microsoft SQL Server Microsoft SQL Server - forum profile
Thread:  Show this thread (23 posts) Thread info: Subselect Vs Join issues Size: 159 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: You could use CROSS APPLY instead of JOIN.
If the relationship between these two tables is 1:1 then you... :: Microsoft SQL Server :: dBforums - Database Support Community"
DB2
RE: Any ideas !!!! - 22 new posts
Started 6 days, 15 hours ago (2009-11-02 18:06:00)  by koganti
Any ideas !!!!
Forum:  DB2 DB2 - forum profile
Thread:  Show this thread (22 posts) Thread info: db2_all $N Size: 14 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Any ideas !!!! :: DB2 :: dBforums - Database Support Community"
Corel Paradox
Started 2 days, 3 hours ago (2009-11-07 06:34:00)  by Steve Green
first question.. 4.5 DOS or 4.5 WIN?
Forum:  Corel Paradox Corel Paradox - forum profile
Thread:  Show this thread (19 posts) Thread info: Paradox 4.5 and Vista or Windows 7 Size: 36 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: first question.. 4.5 DOS or 4.5 WIN? :: Corel Paradox :: dBforums - Database Support Community"
DB2
Started 3 days, 23 hours ago (2009-11-05 10:21:00)  by sathyaram_s
Not clear! Please give an example or if possible, the same code and query that is not 'working' What version of DB2 are you using ?
Forum:  DB2 DB2 - forum profile
Thread:  Show this thread (18 posts) Thread info: Order of picking data mismatch in Mainframes DB2 and AIX DB2 Size: 147 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Not clear! Please give an example or if possible, the same code and query
that is not 'working'

What... :: DB2 :: dBforums - Database Support Community"
Microsoft SQL Server
Started 6 days ago (2009-11-03 09:50:00)  by blindman
Try adding PRINT @SQLString before you exec, to aid in debugging.
Forum:  Microsoft SQL Server Microsoft SQL Server - forum profile
Thread:  Show this thread (18 posts) Thread info: Paging Stored Procedure Size: 65 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Try adding PRINT @SQLString before you exec, to aid in debugging. :: Microsoft SQL Server :: dBforums - Database Support Community"

This page was found by:   Concatenate with Microsoft AQT