Database and Reporting | Forum profile

Has really nobody a little complete upload example in combination with a postgresql database? Stephan

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.

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

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

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

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

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

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

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

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.