4 Solved Topics

Remove Filter
Member Avatar for
Member Avatar for amishraa

The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all …

0
223
Member Avatar for amishraa

Hello, What seems so trivial, has been bugging me. I have a table with duplicate values on one column, while non-duplicate (date) values on the other. If I am to use DISTINCT it will only eliminate the row with the same date. But how do I use DISTINCT and only …

Member Avatar for diafol
0
242
Member Avatar for xuexue

Hi! Could you help me initialize or load the data into a Data Grid View Control using iDB2 Connection? I've tried this code I've seen from the net but it does not seem to work :( I am initializing the connection using form_load and not in the Properties Window. Imports …

Member Avatar for cgeier
0
324
Member Avatar for xuexue

Hi! My database is in AS/400 DB2 hence, I am using SQL. Here's my line of code for opening a connection. Dim str As String = "User ID=EDITH;Password=EDITH;Data Source=10.0.1.11;Initial Catalog=ictms;Integrated Security=True" Dim conn As SqlConnection = New SqlConnection(str) conn.Open() Now, I wanted to execute a delete query, however, I already …

Member Avatar for xuexue
0
2K

The End.