Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~792 People Reached
Favorite Forums
Favorite Tags
Member Avatar for shizzle08

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

Member Avatar for TnTinMN
0
136
Member Avatar for shizzle08

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 …

Member Avatar for JorgeM
0
363
Member Avatar for shizzle08

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 …

Member Avatar for poojavb
0
151
Member Avatar for shizzle08

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 …

Member Avatar for bluehangook629
0
142