Click here to Skip to main content
15,901,666 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: How to pass xterm -e option as variable? Pin
k505431-Dec-23 17:35
mvek505431-Dec-23 17:35 
GeneralRe: How to pass xterm -e option as variable? Pin
jschell1-Jan-24 2:07
jschell1-Jan-24 2:07 
GeneralMessage Closed Pin
1-Jan-24 9:51
Salvatore Terress1-Jan-24 9:51 
GeneralRe: How to pass xterm -e option as variable? Pin
k50541-Jan-24 13:09
mvek50541-Jan-24 13:09 
GeneralRe: How to pass xterm -e option as variable? Pin
jschell2-Jan-24 6:14
jschell2-Jan-24 6:14 
GeneralRe: How to pass xterm -e option as variable? Pin
Richard MacCutchan1-Jan-24 22:13
mveRichard MacCutchan1-Jan-24 22:13 
GeneralRe: How to pass xterm -e option as variable? Pin
jschell2-Jan-24 6:26
jschell2-Jan-24 6:26 
AnswerRe: Please - explain the C++ code / function Pin
Richard MacCutchan28-Dec-23 22:02
mveRichard MacCutchan28-Dec-23 22:02 
AnswerRe: Please - explain the C++ code / function Pin
jschell29-Dec-23 5:16
jschell29-Dec-23 5:16 
AnswerRe: Please - explain the C++ code / function Pin
jeron112-Jan-24 5:04
jeron112-Jan-24 5:04 
GeneralRe: Please - explain the C++ code / function Pin
Richard MacCutchan12-Jan-24 5:39
mveRichard MacCutchan12-Jan-24 5:39 
GeneralRe: Please - explain the C++ code / function Pin
jeron112-Jan-24 6:16
jeron112-Jan-24 6:16 
Questiondeleting from a vector Pin
mike741124-Dec-23 20:37
mike741124-Dec-23 20:37 
AnswerRe: deleting from a vector Pin
Richard MacCutchan24-Dec-23 21:39
mveRichard MacCutchan24-Dec-23 21:39 
AnswerRe: deleting from a vector Pin
Mircea Neacsu25-Dec-23 2:19
Mircea Neacsu25-Dec-23 2:19 
Questionstd::async Pin
utcode23-Dec-23 16:31
utcode23-Dec-23 16:31 
AnswerRe: std::async Pin
Richard MacCutchan23-Dec-23 21:32
mveRichard MacCutchan23-Dec-23 21:32 
Questiondesign question : variadic functions use ? . Pin
Maximilien19-Dec-23 2:34
Maximilien19-Dec-23 2:34 
AnswerRe: design question : variadic functions use ? . Pin
Mircea Neacsu19-Dec-23 2:42
Mircea Neacsu19-Dec-23 2:42 
GeneralRe: design question : variadic functions use ? . Pin
Maximilien19-Dec-23 2:54
Maximilien19-Dec-23 2:54 
AnswerRe: design question : variadic functions use ? . Pin
jschell19-Dec-23 5:08
jschell19-Dec-23 5:08 
GeneralRe: design question : variadic functions use ? . Pin
Maximilien19-Dec-23 7:36
Maximilien19-Dec-23 7:36 
GeneralRe: design question : variadic functions use ? . Pin
jschell20-Dec-23 5:31
jschell20-Dec-23 5:31 
GeneralRe: design question : variadic functions use ? . Pin
Maximilien20-Dec-23 6:55
Maximilien20-Dec-23 6:55 
GeneralRe: design question : variadic functions use ? . Pin
jschell21-Dec-23 3:31
jschell21-Dec-23 3:31 
My best practice doesn't fit either of your suggestions...

If I am creating a new database layer (which I have numerous times) then the caller would never provide the SQL.

If the business layer(s) need new database logic then the database layer should be modified to provide it.

The caller provides the parameters that would be used in the call.

Then within that database layer method it would decide how to process the parameters and SQL (provided by the method.)

So it looks like the following.

void DatabaseDoX(param1, param2,...)
{
// multiple variations possible
std::string fullyFormedQuery = sprintf (SQL_X, param1, param2, ... );


There are quite a few variations on the above. For example consider the complication of a user initiated call where they might specify different 'query' terms (like data range, customer name, etc)

But all still hide the SQL.

Certainly there are design considerations for example your code might be coming from within the database layer (not a business call at all.) If so then I suspect that usage would actually vary depending on what the database layer was specifically doing in the code path.

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.