No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
im having a problem on my sql command. here is my command select ProductCode, ProductName, qtyinstock, critical from product where qtyinstock <= critical but it keeps on showing record that qtyinstock is not less than or equal to critical see this image http://a4.sphotos.ak.fbcdn.net/hphotos-ak-snc7/482956_437601922940311_1148836844_n.jpg |
|
what sql command i must use. this is my current command but it give me an error saying "The specified filed 'ClientNo' could refer to more than one table listed in the FROM clause of your sql statemate." Try dc.Connection = conn dc.CommandText = "SELECT * FROM tblClient, tblClientInfo WHERE … |
|
can you help me how to select from multiple tables. so far this is my code how do i Dim dr As OleDbDataReader Dim dc As New OleDbCommand dc.Connection = conn dc.CommandText = "SELECT * FROM tblClient, tblLoan WHERE ClientNo = '" & ClientNo & "'" dr = dc.ExecuteReader If … |
|
Hi guys ok guys this is my problem my DataGridView1 does not show the data on my testdb.mdb i need to fix this first before i continue on adding records on my db i very much appreciate any one who can help me with this. [CODE]Imports System.Data.OleDb Public Class Customer … |