Click here to Skip to main content
15,915,513 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionDesigner Generated Code Pin
Tainter16-Dec-05 7:22
Tainter16-Dec-05 7:22 
AnswerRe: Designer Generated Code Pin
Dave Kreskowiak16-Dec-05 9:20
mveDave Kreskowiak16-Dec-05 9:20 
AnswerRe: Designer Generated Code Pin
Joshua Quick16-Dec-05 9:46
Joshua Quick16-Dec-05 9:46 
GeneralRe: Designer Generated Code Pin
Tainter16-Dec-05 9:52
Tainter16-Dec-05 9:52 
Questioncalling .NET virtual method from VB6 Pin
IsaacB16-Dec-05 6:46
IsaacB16-Dec-05 6:46 
QuestionConvert BMP to black & white Pin
thrakazog16-Dec-05 6:37
thrakazog16-Dec-05 6:37 
AnswerRe: Convert BMP to black & white Pin
Dave Kreskowiak16-Dec-05 7:04
mveDave Kreskowiak16-Dec-05 7:04 
QuestionSQL Query (VB6 & MS Access) Pin
mellvincent16-Dec-05 4:18
mellvincent16-Dec-05 4:18 
I have a table with 2 fields: ProductCode(Text) and InventoryNo(Int). I'd like to display the largest integer in InventoryNo field that has the same ProductCode. my SQL query is :

SELECT MAX(InventoryNo) FROM StockTable WHERE ProductCode = '&txtprdcode.Text&'

The problem is, the outcome I got was the largest integer regardless of its ProductCode (The output was more like the largest integer in InventoryNo Column).

What seems to be the problem?

TQ
AnswerRe: SQL Query (VB6 & MS Access) Pin
albCode16-Dec-05 4:52
albCode16-Dec-05 4:52 
QuestionApp to Authenticate a User Pin
bduboftexas16-Dec-05 4:14
bduboftexas16-Dec-05 4:14 
AnswerRe: App to Authenticate a User Pin
Joshua Quick16-Dec-05 9:55
Joshua Quick16-Dec-05 9:55 
QuestionUSB Pin
Sushmadm16-Dec-05 2:19
Sushmadm16-Dec-05 2:19 
AnswerRe: USB Pin
Dave Kreskowiak16-Dec-05 4:44
mveDave Kreskowiak16-Dec-05 4:44 
GeneralRe: USB Pin
Sushmadm18-Dec-05 18:29
Sushmadm18-Dec-05 18:29 
GeneralRe: USB Pin
Dave Kreskowiak19-Dec-05 1:47
mveDave Kreskowiak19-Dec-05 1:47 
GeneralRe: USB Pin
Sushmadm19-Dec-05 21:36
Sushmadm19-Dec-05 21:36 
GeneralRe: USB Pin
Dave Kreskowiak20-Dec-05 2:41
mveDave Kreskowiak20-Dec-05 2:41 
GeneralRe: USB Pin
Sushmadm20-Dec-05 17:36
Sushmadm20-Dec-05 17:36 
GeneralRe: USB Pin
Dave Kreskowiak20-Dec-05 18:40
mveDave Kreskowiak20-Dec-05 18:40 
GeneralRe: USB Pin
Sushmadm22-Dec-05 17:55
Sushmadm22-Dec-05 17:55 
GeneralRe: USB Pin
Sushmadm28-Dec-05 19:54
Sushmadm28-Dec-05 19:54 
Questionsms integration Pin
Rajkumar_d16-Dec-05 2:12
Rajkumar_d16-Dec-05 2:12 
AnswerRe: sms integration Pin
jonathan1516-Dec-05 2:58
jonathan1516-Dec-05 2:58 
Questiondragging controls in VB 2005 express Pin
davebrooke15-Dec-05 20:14
davebrooke15-Dec-05 20:14 
QuestionHelp on nhibernate Pin
Gaurav_Rahi_SE15-Dec-05 18:50
Gaurav_Rahi_SE15-Dec-05 18:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.