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... 

Database and Reporting | Forum profile

Forum profile page for Database and Reporting on http://www.xtremevbtalk.com. This report page is the aggregated overview from a single forum: Database and Reporting, located on the Message Board at http://www.xtremevbtalk.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Database and Reporting" on the Message Board at http://www.xtremevbtalk.com is also shown in the following ways:

1) Latest Active Threads
2) 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 forum's popularity and/or exact posting volumes at any given reporting period.

Site: Xtreme Visual Basic Talk - Database and Reporting (site profile, domain info xtremevbtalk.com)
Title: Database and Reporting
Url: http://www.xtremevbtalk.com/forumdisplay.php?f=16
Users activity: 15 post per thread
Forum activity: 16 active threads during last week
 

Posting activity on Database and Reporting:

  Week Month 3 Months
Threads: 16 53 186
Post: 25 80 275
 

Database and Reporting Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Phonon
4
user's latest post:
Minimal example for blob (byteA)...
Published (2009-11-27 07:07:00)
Has really nobody a little complete upload example in combination with a postgresql database? Stephan
gibra
4
user's latest post:
SQL 2008 connection string
Published (2009-12-03 17:47:00)
OleDB Connection String Builder sound good! But, really, don't need to use a VB project to get open DataLink window. Simply, create a new UDL file (i.e. data.udl into Desktop), next double-click on it, this will open DataLink. After set all proprerties as you want, save file, then right-click to open file using Notepad to get connection string.
Lee123
2
user's latest post:
Date Order messed up once in new...
Published (2009-11-28 03:12:00)
Thanks...yes, my bad, I am using SQL Server 2005. CAST is new to me, but is this close? From: Code: SELECT * FROM my_table WHERE item_status = 'Open' ORDER BY item_date DESC, item_time DESC To: Code: SELECT * FROM my_table WHERE item_status = 'Open' ORDER BY CAST(item_date AS datetime) DESC, CAST(item_time AS datetime) DESC
Flyguy
2
user's latest post:
Syntax error in INSERT INTO...
Published (2009-12-04 06:15:00)
I think you should not put the complete statement between () Code: Insert into Bookings (Arrival_Date, Departure_Date) VALUES ( '" & dtp_arrival_date & "', '" & dtp_departure_date & "'" Also check for the spaces between table name and values
Peter_Aquino
1
user's latest post:
Problem with SQL Query returning...
Published (2009-11-26 16:06:00)
To be honest, this query is pretty hard to read or make sense of, because of the table name similarities and your SQL formatting. To make things more readable, and probably assist in troubleshooting, try cleaning up your formatting and using table aliases like below: Code: SELECT a.barcap_requestnumber, a.barcap_typename, a.barcap_stagename, a.createdbyname, a.createdon, a.barcap_name, a.barcap_localename, a.barcap_priorityname,...
dragon100
1
user's latest post:
Problem with SQL Query returning...
Published (2009-11-26 05:41:00)
Hi all i have a problem where im trying to run this sql query but return no data if the following table is empty the first part runs fine but not the second part. What im trying to do is still display results even if there is no data entry in the below table. thanks for your help. Filteredbarcap_fibloombergswaps_productbbswaps select FilteredBarcap_fibloombergswaps.barcap_requestnumber, FilteredBarcap_fibloombergswaps.barcap_typename,...
eppitis1
1
user's latest post:
datagrid and vb6
Published (2009-11-27 08:05:00)
i have a datagrid in vb6 in some columns i want to have boolean values i want to do this with code and not in the datagrid properties (right click in datagrid --> properties --> format) here is 3 columns of my datagrid Code: Public Sub initDataGrid() dgPumpLog.Columns(0).Width = 1800 dgPumpLog.Columns(0).Caption = " Rec Date" dgPumpLog.Columns(0).DataField = "RecDate"...
vampyjoker
1
user's latest post:
Compare & updates records in...
Published (2009-11-26 01:44:00)
Hi, I have a vbscript written to read a txt file into database. Now, I would need to compare the database records that I had created with a live database record. Both database table has the same fields. I would need to check every records and updates the live database with the changes in the one I had read from the txt file. Any codes for comparing these 2 database then updates the database if there's any changes in the record, the...
smohrmax
1
user's latest post:
VB6 and MS Access 2003 not...
Published (2009-12-02 19:28:00)
Terrific, Thanks for the "INSERT" insight, It's working!! Thanks for you help and patience. I did determine that if there is a field being inserted that is too large than what the field is set to recieve, truncation does not occur, no records get inserted. But I accomodated for that. Thanks again, Steve
carnation
1
user's latest post:
SQL 2008 connection string
Published (2009-12-03 04:19:00)
Hi all, I use SQL 2000 before then begin to use SQL 2008. Pls let me know is the connection string different in 2008 from 2000? Thanks.
 

Latest active threads on Database and Reporting::

Xtreme Visual Basic Talk
Started 2 days, 4 hours ago (2009-12-04 06:15:00)  by Flyguy
I think you should not put the complete statement between () Code: Insert into Bookings (Arrival_Date, Departure_Date) VALUES ( '" & dtp_arrival_date & "', '" & dtp_departure_date & "'" Also check for the spaces between table name and values
Thread:  Show this thread (3 posts)   Thread info: Syntax error in INSERT INTO statement Size: 614 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Syntax error in INSERT INTO statement :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 3 days, 5 hours ago (2009-12-03 04:39:00)  by gibra
http://www.connectionstrings.com/
Thread:  Show this thread (4 posts)   Thread info: SQL 2008 connection string Size: 258 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL 2008 connection string :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 6 days, 11 hours ago (2009-11-29 22:47:00)  by vb5prgrmr
What happens if you use vb6 to read the file in and insert into the database? What is the size of the csv? Have you checked to see if the csv is corrupt? Have you run check disk lately? Good Luck
Thread:  Show this thread (8 posts)   Thread info: VB6 and MS Access 2003 not playing nice together Size: 296 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: VB6 and MS Access 2003 not playing nice together :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 4 days, 18 hours ago (2009-12-01 15:58:00)  by loquin
Check BillSoo's How to Create Line Graph and A Current Trend Or, look at the MSChart control, or NTGraph
Thread:  Show this thread (4 posts)   Thread info: Make a Graph in Vb6 Size: 407 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Make a Graph in Vb6 :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 5 days, 7 hours ago (2009-12-01 03:04:00)  by Flyguy
1st the following line does not what you expect it to do, making both variables of type Date Code: dim dteBegDate, dteEndDate as Date ' should be written as Dim dteBegDate As Date , dteEndDate As Date 2nd, You put the date value in the statement between ' This will produce the following (simplified) statement: Code: SELECT * FROM tblReservations WITH ...
Thread:  Show this thread (5 posts)   Thread info: SQL Statement Using MySQL Problem Size: 1,549 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL Statement Using MySQL Problem :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 1 week, 2 days ago (2009-11-27 07:07:00)  by Phonon
Has really nobody a little complete upload example in combination with a postgresql database? Stephan
Thread:  Show this thread (5 posts)   Thread info: Minimal example for blob (byteA) upload into postgresql server Size: 257 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Minimal example for blob (byteA) upload into postgresql server :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 1 week, 1 day ago (2009-11-28 07:45:00)  by gibra
DataGrid hasn't this feature. To 'alter' the column you have to adjust query to get desired result, to specify field by field. Doesn't use: "SELECT * FROM table", use instead: Code: Dim sSQL As String sSQL = "SELECT field1, field2, Iif(BatteryVoltage > 0, 'YES', 'NO'), field4 FROM table" rs.Open sSQL, CN, .......... Set dgPumpLog.DataSource = rs
Thread:  Show this thread (2 posts)   Thread info: datagrid and vb6 Size: 842 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: datagrid and vb6 :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 1 week, 1 day ago (2009-11-28 03:03:00)  by gibra
Simply 'cast' the String to Data type in the ORDER BY proposition. You haven't specified what database you use (you say SQL database but SQL is the language of databases, not a database) so I can't suggest you the exact code. See here, if you use SQL Server 2005 http://msdn.microsoft.com/en-us/libr...28.aspx?ppu d=4 otherwise read guide about database you use....
Thread:  Show this thread (3 posts)   Thread info: Date Order messed up once in new year. Size: 699 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Date Order messed up once in new year. :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 1 week, 2 days ago (2009-11-26 16:06:00)  by Peter_Aquino
To be honest, this query is pretty hard to read or make sense of, because of the table name similarities and your SQL formatting. To make things more readable, and probably assist in troubleshooting, try cleaning up your formatting and using table aliases like below: Code: SELECT a.barcap_requestnumber, a.barcap_typename , a.barcap_stagename, a.createdbyname, a....
Thread:  Show this thread (2 posts)   Thread info: Problem with SQL Query returning no data after joins Size: 1,614 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Problem with SQL Query returning no data after joins :: Database and Reporting :: Xtreme Visual Basic Talk"
Xtreme Visual Basic Talk
Started 1 week, 4 days ago (2009-11-24 14:37:00)  by loquin
perhaps this will help
Thread:  Show this thread (4 posts)   Thread info: Need really help concerning postgresql together with Excel VBA Size: 161 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Need really help concerning postgresql together with Excel VBA :: Database and Reporting :: Xtreme Visual Basic Talk"
 

Hot threads for last week on Database and Reporting::

Database and Reporting
Started 3 days, 5 hours ago (2009-12-03 04:39:00)  by gibra
http://www.connectionstrings.com/
Thread:  Show this thread (4 posts)   Thread info: SQL 2008 connection string Size: 258 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL 2008 connection string :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
Started 1 week, 1 day ago (2009-11-28 03:03:00)  by gibra
Simply 'cast' the String to Data type in the ORDER BY proposition. You haven't specified what database you use (you say SQL database but SQL is the language of databases, not a database) so I can't suggest you the exact code. See here, if you use SQL Server 2005 http://msdn.microsoft.com/en-us/libr...28.aspx?ppu d=4 otherwise read guide about database you use....
Thread:  Show this thread (3 posts)   Thread info: Date Order messed up once in new year. Size: 699 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Date Order messed up once in new year. :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
Started 1 week, 2 days ago (2009-11-27 07:07:00)  by Phonon
Has really nobody a little complete upload example in combination with a postgresql database? Stephan
Thread:  Show this thread (5 posts)   Thread info: Minimal example for blob (byteA) upload into postgresql server Size: 257 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Minimal example for blob (byteA) upload into postgresql server :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
Started 2 days, 4 hours ago (2009-12-04 06:15:00)  by Flyguy
I think you should not put the complete statement between () Code: Insert into Bookings (Arrival_Date, Departure_Date) VALUES ( '" & dtp_arrival_date & "', '" & dtp_departure_date & "'" Also check for the spaces between table name and values
Thread:  Show this thread (3 posts)   Thread info: Syntax error in INSERT INTO statement Size: 614 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Syntax error in INSERT INTO statement :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
RE: datagrid and vb6 - 2 new posts
Started 1 week, 1 day ago (2009-11-28 07:45:00)  by gibra
DataGrid hasn't this feature. To 'alter' the column you have to adjust query to get desired result, to specify field by field. Doesn't use: "SELECT * FROM table", use instead: Code: Dim sSQL As String sSQL = "SELECT field1, field2, Iif(BatteryVoltage > 0, 'YES', 'NO'), field4 FROM table" rs.Open sSQL, CN, .......... Set dgPumpLog.DataSource = rs
Thread:  Show this thread (2 posts)   Thread info: datagrid and vb6 Size: 842 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: datagrid and vb6 :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
Started 5 days, 7 hours ago (2009-12-01 03:04:00)  by Flyguy
1st the following line does not what you expect it to do, making both variables of type Date Code: dim dteBegDate, dteEndDate as Date ' should be written as Dim dteBegDate As Date , dteEndDate As Date 2nd, You put the date value in the statement between ' This will produce the following (simplified) statement: Code: SELECT * FROM tblReservations WITH ...
Thread:  Show this thread (5 posts)   Thread info: SQL Statement Using MySQL Problem Size: 1,549 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: SQL Statement Using MySQL Problem :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
Started 6 days, 11 hours ago (2009-11-29 22:47:00)  by vb5prgrmr
What happens if you use vb6 to read the file in and insert into the database? What is the size of the csv? Have you checked to see if the csv is corrupt? Have you run check disk lately? Good Luck
Thread:  Show this thread (8 posts)   Thread info: VB6 and MS Access 2003 not playing nice together Size: 296 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: VB6 and MS Access 2003 not playing nice together :: Database and Reporting :: Xtreme Visual Basic Talk"
Database and Reporting
Started 4 days, 18 hours ago (2009-12-01 15:58:00)  by loquin
Check BillSoo's How to Create Line Graph and A Current Trend Or, look at the MSChart control, or NTGraph
Thread:  Show this thread (4 posts)   Thread info: Make a Graph in Vb6 Size: 407 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Make a Graph in Vb6 :: Database and Reporting :: Xtreme Visual Basic Talk"