Visual Cobol in Visual Studio 2010 Database

Question

0.00/5 (No votes)

See more:

hello good day..
i am currently creating my project in cobol2 .. i am using a visual cobol of microfocus and was used a Ado.net for my database.. On the interface of openesql assistant i can insert values in my database table..
but on the form of my project on the button1 clicked i've got an error saying "NO SQL DIRECTIVES HAVE BEEN SET"

(here is my code

SQL

method-id button1_Click final private.
       procedure division using by value sender as object e as type System.EventArgs.
       
       EXEC SQL
        INSERT INTO NayreInventory  
        (ItemCode
        ,ItemDescription
        ,Quantity
        ,Price
         ) VALUES (
         :NayreInventory-ItemCode:NayreInventory-ItemCode-0001
        ,:NayreInventory-ItemDescription:Col-2-MEDICOL
        ,:NayreInventory-Quantity:NayreInventory-Quantity-5
        ,:NayreInventory-Price:NayreInventory-Price-150
         )
       END-EXEC. 
       
       invoke type MessageBox::Show("1 RECORD HAS BEEN SUCCESSFULLY ADDED", "RESULT")
       end method.

)
how to get rid on the error..
please help me .. i really need your help..

[edit]code block and sms-spelling[/edit]

Posted 5-Mar-13 5:56am

John Mark Olesco

Updated 5-Mar-13 6:42am

Nelek

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

recoverinfotech · Answer 1 · 2013-03-05T12:39:00

Solution 1

use

C#

try{

// your sql command and connection of database in c#
}catch(Exception ee){

MessageBox.Show(ee.Message);

}

this will work

[edit]code block[/edit]

Posted 5-Mar-13 12:39pm

recoverinfotech

Updated 5-Mar-13 13:17pm

v2

Comments

John Mark Olesco 5-Mar-13 22:13pm

it seems that the solution is not right..

my problem is how to solve the error of visual cobol named
"NO SQL DIRECTIVES HAVE BEEN SET"

how to get rid on that error?
and please tell me how to configure the connection string of database(ADO.NET) in visual cobol