|
More site info...
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.
|
|
|
|
|
Posting activity table on dBforums - Database Support Community:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
580
|
2,250
|
6,169
|
|
Post:
|
1,532
|
6,412
|
17,501
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for dBforums - Database Support Community (http://www.dbforums.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
dBforums - Database Support Community posting activity graph:
|
|
http://www.dbforums.com Alexa graph:
|
Top authors on dBforums - Database Support Community during last week:
user's latest post:
AfterDelete event?
Published (2009-07-08 02:12:00)
..thats odd I've only got a afterdelconfirm.... mind you I am using A2003/XP
user's latest post:
AfterDelete event?
Published (2009-07-08 02:05:00)
I am using Access 2000 from what I read and test the event triggers both for a yes and for a no. Dumb so trigger for a no I think.
user's latest post:
rant: Referential Integrity not...
Published (2009-07-07 17:37:00)
should any of you actually get around to testing that DDL, you will discover that it isn't "ON CASCADE UPDATE" but ON UPDATE CASCADE instead and i should like to challenge any of you to describe a set of circumstances where a parent table, which has an autonumber (identity) surrogate primary key, will ever have occasion to need to renumber one of its key values , which would require cascading to child tables...
user's latest post:
SQL Query
Published (2009-07-07 10:36:00)
Well you see, there isn't really a second table that contains exactly what I'd like to see next to e.g., 1.1.1.1 like I'd like to see BSC(1) RX/TX. So....
user's latest post:
Access make table query with one...
Published (2009-07-07 03:09:00)
:shudder: A field name or table name should NEVER contain colons. There must be another way.
user's latest post:
can't see the result of my...
Published (2009-07-07 14:37:00)
>What should I do to actually see....something? There is nothing to "see" PL/SQL runs inside the database engine & has to direct contact with the outside world. You could SPOOL the SELECT out to a file (capture.sql) & then @capture.sql
user's latest post:
Wrapping backup in a TRY...CATCH...
Published (2009-07-07 08:38:00)
Look at the BOL entry for try...catch: TRY...CATCH (Transact-SQL) Snippet from the link Code: BEGIN TRY -- Generate a divide-by-zero error. SELECT 1/0; END TRY BEGIN CATCH SELECT ERROR_NUMBER() AS ErrorNumber, ERROR_SEVERITY() AS ErrorSeverity, ERROR_STATE() AS ErrorState, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_LINE() AS ErrorLine, ERROR_MESSAGE() AS ErrorMessage; END CATCH; You can assign things like the error message to variables in a...
user's latest post:
Why RDMS implementations are not...
Published (2009-07-07 11:05:00)
It's a discussion when the questions are not rhetorical. These are also not database concepts, but implementation issues.
user's latest post:
Naming Convention
Published (2009-07-07 15:12:00)
OK, I just asked all my developers, and they prefer CamelCase, saying that all lower case is difficult to read.
user's latest post:
can't see the result of my...
Published (2009-07-07 15:06:00)
Hi Patricia, If you want to do some simple testing of your procedures, try something like this: Code: SQL> CREATE OR REPLACE PROCEDURE pp (tbl IN VARCHAR2, rslt OUT sys_refcursor) 2 AS 3 str VARCHAR2 (50); 4 BEGIN 5 6 str := 'SELECT * FROM '|| tbl ||' WHERE ROWNUM < 11'; 7 8 OPEN rslt FOR str; 9 10 END; 11 / Procedure created. SQL> VAR plist REFCURSOR; SQL> EXEC pp('PRODUCTS',:plist);...
|
|
|
Top 10 active forums on dBforums - Database Support Community during last week:
|
|
Top 10 forums on dBforums - Database Support Community:
Microsoft Access
- 21,197 posts
|
Microsoft SQL Server
- 19,234 posts
|
DB2
- 15,971 posts
|
Chit Chat
- 12,119 posts
|
Oracle
- 9,629 posts
|
Database Concepts & Design
- 7,711 posts
|
MySQL
- 7,265 posts
|
Sybase
- 3,372 posts
|
Informix
- 1,730 posts
|
PHP
- 1,593 posts
|
|
|
|
|
Latest active threads on dBforums - Database Support Community:
Started 2 days, 4 hours ago (2009-07-08 00:52:00)
by Bob2119
Can I tell in afterdelete event if the user press yes or no?
Started 2 days, 4 hours ago (2009-07-08 00:50:00)
by Bob2119
Can I set the form's caption property from vb ?
Started 2 days, 3 hours ago (2009-07-08 01:59:00)
by bklr
Hi, I have created a user and a database with login postgres 5 days back but now when i am login with postgres password authentication failed for user "postgres" like this bash-3.2$ psql -W postgres postgres Password for user postgres: psql: FATAL: password authentication failed for user "postgres" can any one help how to login for postgres it some what urgent
Started 2 days, 3 hours ago (2009-07-08 01:45:00)
by andi_kan
Hi guys, I need help. I'm not too familiar with the various SQL terms and all so please forgive me if I don't say it right Let me start by explaining what I'm trying to achieve. I'm trying to create a tracking system whereby all outgoing and incoming documents are matched. The problem is that outgoing documents (I'll use an invoice book as example) run in sequence, say each book contains ...
Started 2 days, 4 hours ago (2009-07-08 01:41:00)
by Bob2119
I tried to build a query using count. What I want is to count the number of records where Flight.[battery id] a number like 2 I want to run this in vb code onclick of a button on a form I then want to display the count in a unboudn text field. Please help SELECT Count(Flights.[iBattery ID]) AS [CountOfiBattery ID] FROM Flights HAVING (((Count(Flights.[iBattery ID]))=2));
Started 2 days, 8 hours ago (2009-07-07 20:56:00)
by dbfHelp
Please help on following Table: ITrans Primary key: uid, RefNo, type, spkey. Group by field : uid, Ino Sum field: IValue Requirement: 1.) Group the recrods by uid,Ino sum(Ivalue) as totval. 2.) select a distinct RefNo, Ino, totval from Itrans Note Refno cannot be repeated must be distinct. It does not matter there many Refno for the summation just ...
Started 2 days, 5 hours ago (2009-07-07 23:48:00)
by sundaram
Hi, We use db2 8.2 on Windows 2000. We were on fixpack 13 initially. Last week we applied fixpack 17a. after this we notice the cpu utilisation in the server is comming closer to 100% and our production users complain of slow response. Our production system uses Windows clustering - our production DB instance ican fail over to the other server using Microsoft clustering. We ...
Started 2 days, 8 hours ago (2009-07-07 21:14:00)
by Bob2119
Are there any utils to print all the forms code. Export to a txt file would be nice. I am setting up a data base for this but it is manual and slow to keep current. Also print all the forms screens would be nice all so I print screen the screens now and save to a image file.
Started 2 days, 14 hours ago (2009-07-07 15:35:00)
by MarkWahlbergTwo
Hello I would like to drop by and say hello. I was watching this forum for a while now, but haven't made a contribution. I am from Algiers and like to play video games like half life and xbox. I hope to get a lot out of this forum . Thank you for having me Marc
Started 2 days, 4 hours ago (2009-07-08 00:44:00)
by desireemm
Hi all I have yet another question. I need to have two datasources for a report that has two tables in it, now the reason being is because one table is to give totals for the shool year and the other table is to give totals for the summer school. so its going to be different totals in both tables. And each table has its own datasource. The user wants to see both totals for summer school and ...
|
|
Hot threads for last week on dBforums - Database Support Community:
Started 1 month, 4 weeks ago (2009-05-11 07:30:00)
by mike_bike_kite
The old one has hit 1000 so this is yet another preemptive strike to avoid melt down of vBulletin. No doubt in years to come they may release a fix - then again they probably won't. Happy yakking
Started 1 week, 1 day ago (2009-07-01 08:13:00)
by MarineX
["http://img195.imageshack.us/img195/695/picture2e pi.png"]Kindly remove this.. im kinda confused with it.
Started 1 week, 1 day ago (2009-07-01 09:22:00)
by darkangie
Hi! I'm writing a code to fill a sub form with the data from my db...but when i select any of the filters I got the error msg: Too few parameters. Expected 2, when it tries to execute .OpenRecordset() Could you please help me...I'll put the code here This is the sql: strSQL_Transf = "" & " TRANSFORM Sum([SaldoDevedorIni]) AS SomaSaldoDevedorIni " & "" strSQL_Select = "" & "...
Started 1 week, 3 days ago (2009-06-29 09:58:00)
by jancliff
I apologise if this is very easy as its been a while since I've used Access. In very simple terms I have a database with Field1 Field2 Field3 and Field4. There are times if a user is inputting 100 records at a time where Field1, Field2 and Field 3 are the same but Field4 is different. I was hoping to find the best way to do this so I could perhaps use a form with drop down lookups for Fields...
Started 3 days, 11 hours ago (2009-07-06 18:26:00)
by TheSarge
Running DB2 v9.105 FP 5 on AIX I'm trying to learn about controlling user access at a table level but things aren't working the way I expect. I've created a new database - DBACTION - with 2 tables - general_access and restricted_access. The goal is to allow user HIREM to access general_access but not restricted_access. I've revoked all database level privileges from PUBLIC - my id...
Started 3 days, 17 hours ago (2009-07-06 12:26:00)
by shajju
Hi Thought I'd get some ideas from the gurus here. Basically I am querying a table and generating a report with the returned data. Now, what I'm after is that e.g., one of the returned columns gives rows containing string: 1.1.1.1 1.1.1.2 1.1.1.3 etc And 1.1.1.1 means A 1.1.1.2 means B 1.1.1.3 means C etc Is there any way that I can get output so that I see 1.1.1...
Started 1 week ago (2009-07-02 06:26:00)
by sunsail
Hello can you explain how I should use these funcs? I generally do trunc(date)='01-01-2009' to_date(date)='01-01-2009' to_char(date)='01-01-2009' in which situations should I use these Thanks
Started 4 days, 17 hours ago (2009-07-05 12:25:00)
by benrees
Hi All I'm looking at different ways of implementing a simple, but extensible ETL application in SQL Server and was wondering what people have previously used. I've played with SSIS and, though it does a lot of what I'm after, it doesn't seem particularly extendable (e.g. allowing for quite sophisticated transformation processes) and it's also not as easy to use as it could be! Has ...
Started 1 week, 1 day ago (2009-07-01 10:01:00)
by MarineX
ER-Diagram my other current er diagram is like that. Is there any issues on how i rearranged the diagram? [Agency] AgencyId PRIMARY KEY [Customer] CustomerId PRIMARY KEY [Rental] RentalId PRIMARY KEY VehicleId FOREIGN KEY CustomerId FOREIGN KEY [Vehicle] VehicleId PRIMARY KEY VehicleTypeId FOREIGN KEY AgencyId FOREIGN KEY [VehicleType] VehicleTypeId PRIMARY KEY ...
Started 5 days, 14 hours ago (2009-07-04 14:55:00)
by Bob2119
After downloading a sample mdb when I try to open I get a out internet ... error and will not open the file. Only happens on some of course the ones I really want to look at.
|
|
Size: 60 bytes
