Click here to Skip to main content
15,922,015 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: VB6 supported until 2008 Pin
Christian Graus5-Apr-05 20:03
protectorChristian Graus5-Apr-05 20:03 
GeneralRe: VB6 supported until 2008 Pin
rwestgraham5-Apr-05 22:21
rwestgraham5-Apr-05 22:21 
GeneralRe: VB6 supported until 2008 Pin
Christian Graus6-Apr-05 13:15
protectorChristian Graus6-Apr-05 13:15 
GeneralRe: VB6 supported until 2008 Pin
rwestgraham6-Apr-05 14:19
rwestgraham6-Apr-05 14:19 
GeneralRe: VB6 supported until 2008 [edit] Pin
Mitch F.6-Apr-05 7:21
Mitch F.6-Apr-05 7:21 
GeneralClearing the Values in Combo Box Pin
Anonymous5-Apr-05 10:53
Anonymous5-Apr-05 10:53 
GeneralNeed Help Pin
Anonymous5-Apr-05 5:51
Anonymous5-Apr-05 5:51 
GeneralRe: Need Help Pin
Dave Kreskowiak5-Apr-05 6:23
mveDave Kreskowiak5-Apr-05 6:23 
The statement you used in SQLPlus is not identical to the statement your generating using string concatenation. A practice which, BTW, is frowned upon with great predjudice here at CP. You've opened yourself up to SQL Injection attacks using this method. You've also robbed yourself of the wonders of having SqlParameter objects check your values and convert them to the appropriate format for you, automatically. But if you want to give yourself more work, like this problem your having, that's fine us too.

But, if you want to do it the right way from the start, look into parameterized queries. You'll save yourself alot of hassel in the future and it's what real companies expect of your code.

Now, back to your problem. You might want to dump that string to the Output window before you execute it so you can see EXACTLY what your trying to have SQL execute for you.
strSql = "Inset into StudentTransaction(..."
Debug.WriteLine(strSql)
...whatever code you have next, set a breakpoint on this line
   then look in the Output window of the IDE to see the
   SQL statement your code actually built.



RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

GeneralRe: Need Help Pin
Colin Angus Mackay5-Apr-05 6:24
Colin Angus Mackay5-Apr-05 6:24 
GeneralProblem in VB 6.0 Pin
sams_eee5-Apr-05 5:02
sams_eee5-Apr-05 5:02 
GeneralRe: Problem in VB 6.0 Pin
Dave Kreskowiak5-Apr-05 6:09
mveDave Kreskowiak5-Apr-05 6:09 
GeneralSend SMS in PDU format Pin
bgm22915-Apr-05 3:47
bgm22915-Apr-05 3:47 
GeneralRe: Send SMS in PDU format Pin
Dave Kreskowiak5-Apr-05 5:57
mveDave Kreskowiak5-Apr-05 5:57 
GeneralRe: Send SMS in PDU format Pin
Anonymous5-Apr-05 6:46
Anonymous5-Apr-05 6:46 
GeneralWave file property in vb Pin
accessnetwork5-Apr-05 1:38
accessnetwork5-Apr-05 1:38 
GeneralRe: Wave file property in vb Pin
Anonymous5-Apr-05 7:22
Anonymous5-Apr-05 7:22 
QuestionHow to Inherit DataColumnCollection Pin
Prakash Chajer5-Apr-05 0:49
Prakash Chajer5-Apr-05 0:49 
Generalpackage and deployment wizard Pin
Salman Sheikh4-Apr-05 23:12
Salman Sheikh4-Apr-05 23:12 
GeneralSWF files Pin
Mr Dabbah4-Apr-05 22:42
Mr Dabbah4-Apr-05 22:42 
GeneralRe: SWF files Pin
Dave Kreskowiak5-Apr-05 5:52
mveDave Kreskowiak5-Apr-05 5:52 
Generalbuild trial appication Pin
samithaslk4-Apr-05 22:33
samithaslk4-Apr-05 22:33 
Generalhav an error tag for DBGrid Pin
Member 13879124-Apr-05 22:00
Member 13879124-Apr-05 22:00 
GeneralRe: hav an error tag for DBGrid Pin
Dave Kreskowiak5-Apr-05 3:45
mveDave Kreskowiak5-Apr-05 3:45 
Generaldynamically create picture control with tab Pin
shinay4-Apr-05 16:42
shinay4-Apr-05 16:42 
GeneralRe: dynamically create picture control with tab Pin
Dave Kreskowiak5-Apr-05 5:46
mveDave Kreskowiak5-Apr-05 5:46 

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.