Click here to Skip to main content
16,006,341 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionRe: Locked Access database Pin
aransiola10-Oct-06 22:26
aransiola10-Oct-06 22:26 
Questionascending/discending [modified] Pin
Ultima Reborn10-Oct-06 6:20
Ultima Reborn10-Oct-06 6:20 
AnswerRe: ascending/discending Pin
dptalt10-Oct-06 6:50
dptalt10-Oct-06 6:50 
GeneralRe: ascending/discending [modified] Pin
Ultima Reborn10-Oct-06 7:25
Ultima Reborn10-Oct-06 7:25 
QuestionRe: ascending/discending Pin
Ultima Reborn12-Oct-06 11:42
Ultima Reborn12-Oct-06 11:42 
QuestionVB.Net and SQL Statements Pin
directred10-Oct-06 5:11
directred10-Oct-06 5:11 
AnswerRe: VB.Net and SQL Statements Pin
mr_lasseter10-Oct-06 6:49
mr_lasseter10-Oct-06 6:49 
AnswerRe: VB.Net and SQL Statements Pin
James Foxall10-Oct-06 9:50
James Foxall10-Oct-06 9:50 
Stored procedures are often the best way to go, but you will be limited in how you can create your SQL statements. A stored procedure has to be able to be compiled when saved, which means the compiler needs to know the fields to retrieve/update and the criteria to use when exucuting the procedure. With highly dynamic SQL, this is often not an option.

In short, use a stored procedure if possible. Another option is to create SQL views and call those to retrieve data. If you're going to process the views though (i.e. retrieve a subset of data from a view), wrap that code in a stored procedure if possible.


james
commercial developer, author, speaker, dude.
www.jamesfoxall.com

QuestionCrystal Report XI Pin
ihe10-Oct-06 3:56
ihe10-Oct-06 3:56 
AnswerRe: Crystal Report XI Pin
Steven J Jowett10-Oct-06 6:02
Steven J Jowett10-Oct-06 6:02 
GeneralRe: Crystal Report XI Pin
ihe11-Oct-06 0:30
ihe11-Oct-06 0:30 
QuestionHow to create a calculator in VB (using RPN) Pin
Wrycu10-Oct-06 3:55
Wrycu10-Oct-06 3:55 
QuestionMy ComboBox class events do not fire Pin
dptalt10-Oct-06 3:42
dptalt10-Oct-06 3:42 
AnswerRe: My ComboBox class events do not fire Pin
James Foxall10-Oct-06 9:51
James Foxall10-Oct-06 9:51 
GeneralRe: My ComboBox class events do not fire Pin
dptalt11-Oct-06 3:13
dptalt11-Oct-06 3:13 
GeneralRe: My ComboBox class events do not fire Pin
James Foxall11-Oct-06 3:23
James Foxall11-Oct-06 3:23 
GeneralRe: My ComboBox class events do not fire Pin
dptalt11-Oct-06 3:53
dptalt11-Oct-06 3:53 
GeneralRe: My ComboBox class events do not fire Pin
James Foxall11-Oct-06 3:56
James Foxall11-Oct-06 3:56 
GeneralRe: My ComboBox class events do not fire Pin
dptalt11-Oct-06 4:47
dptalt11-Oct-06 4:47 
GeneralRe: My ComboBox class events do not fire Pin
James Foxall11-Oct-06 4:54
James Foxall11-Oct-06 4:54 
QuestionData conversion Pin
Chira Chandra10-Oct-06 3:09
Chira Chandra10-Oct-06 3:09 
Questionregister class name in vb.net Pin
K edar V10-Oct-06 1:02
K edar V10-Oct-06 1:02 
AnswerRe: register class name in vb.net Pin
nlarson1118-Oct-06 9:50
nlarson1118-Oct-06 9:50 
Questiondatabase is installed or not Pin
amaneet10-Oct-06 0:36
amaneet10-Oct-06 0:36 
Questionbyval and byref Pin
amaneet10-Oct-06 0:21
amaneet10-Oct-06 0:21 

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.