Click here to Skip to main content
16,005,120 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionprinting in continuous form with dot matrix Pin
klakero12-Mar-06 15:52
klakero12-Mar-06 15:52 
AnswerRe: printing in continuous form with dot matrix Pin
Dave Kreskowiak12-Mar-06 16:01
mveDave Kreskowiak12-Mar-06 16:01 
GeneralRe: printing in continuous form with dot matrix Pin
Colin Angus Mackay12-Mar-06 20:10
Colin Angus Mackay12-Mar-06 20:10 
GeneralRe: printing in continuous form with dot matrix Pin
Dave Kreskowiak13-Mar-06 5:47
mveDave Kreskowiak13-Mar-06 5:47 
GeneralRe: printing in continuous form with dot matrix Pin
klakero14-Mar-06 14:27
klakero14-Mar-06 14:27 
QuestionProblem with List Items Collection Pin
KaKa'12-Mar-06 15:34
KaKa'12-Mar-06 15:34 
AnswerRe: Problem with List Items Collection Pin
Dave Kreskowiak13-Mar-06 9:11
mveDave Kreskowiak13-Mar-06 9:11 
QuestionHow to improve efficiency when I frequent query data from a dictionary table? Pin
CooperWu12-Mar-06 15:31
CooperWu12-Mar-06 15:31 
Hi all, I have a dictionary table contains 2 columns. One is the key column, and the others
One is data column. I made the key column records using CODE rules. For example I used letter ‘A’ as short for a Class Name, then number the CODE from 1 to 100. Similarly, A Full CODE look like ‘A00001B00002C00003’, and every CODE have a DATA.

Now, I need query value from this table. And I need using a value by many times.
The direct way to query is using ‘SELECT DATACOLUMN FROM TESTTABLE WHERE CODE = ‘A00001B00001C00001’’.

Sometimes, I must do this SQL QUERY many times for a value.
How do I change the way to access database or other way can improve efficiency to do this?

Any assistance would be really appreciated.


AnswerRe: How to improve efficiency when I frequent query data from a dictionary table? Pin
Steve Pullan12-Mar-06 15:55
Steve Pullan12-Mar-06 15:55 
GeneralRe: How to improve efficiency when I frequent query data from a dictionary table? Pin
CooperWu12-Mar-06 16:03
CooperWu12-Mar-06 16:03 
GeneralRe: How to improve efficiency when I frequent query data from a dictionary table? Pin
Steve Pullan12-Mar-06 18:39
Steve Pullan12-Mar-06 18:39 
GeneralRe: How to improve efficiency when I frequent query data from a dictionary table? Pin
CooperWu12-Mar-06 19:03
CooperWu12-Mar-06 19:03 
QuestionWindow over-redrawing itself Pin
Nick_Kisialiou12-Mar-06 10:11
Nick_Kisialiou12-Mar-06 10:11 
AnswerRe: Window over-redrawing itself Pin
Dave Kreskowiak12-Mar-06 15:57
mveDave Kreskowiak12-Mar-06 15:57 
GeneralRe: Window over-redrawing itself Pin
Nick_Kisialiou12-Mar-06 16:17
Nick_Kisialiou12-Mar-06 16:17 
GeneralRe: Window over-redrawing itself Pin
Dave Kreskowiak12-Mar-06 16:36
mveDave Kreskowiak12-Mar-06 16:36 
QuestionFind and Replace code Pin
zabsmarty12-Mar-06 2:58
zabsmarty12-Mar-06 2:58 
AnswerRe: Find and Replace code Pin
Dave Kreskowiak12-Mar-06 4:31
mveDave Kreskowiak12-Mar-06 4:31 
QuestionProcess Enumeration in vb6 Pin
MohammadAmiry12-Mar-06 2:19
MohammadAmiry12-Mar-06 2:19 
AnswerRe: Process Enumeration in vb6 Pin
Dave Kreskowiak12-Mar-06 4:21
mveDave Kreskowiak12-Mar-06 4:21 
QuestionFixed path for File Open/Save Dialog.... Pin
ibexcentral12-Mar-06 0:37
ibexcentral12-Mar-06 0:37 
AnswerRe: Fixed path for File Open/Save Dialog.... Pin
Dave Kreskowiak12-Mar-06 4:12
mveDave Kreskowiak12-Mar-06 4:12 
GeneralRe: Fixed path for File Open/Save Dialog.... Pin
ibexcentral12-Mar-06 10:07
ibexcentral12-Mar-06 10:07 
GeneralRe: Fixed path for File Open/Save Dialog.... Pin
Chatura Dilan12-Mar-06 15:28
Chatura Dilan12-Mar-06 15:28 
AnswerRe: Fixed path for File Open/Save Dialog.... Pin
CooperWu12-Mar-06 16:09
CooperWu12-Mar-06 16:09 

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.