Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 04-16-2005, 02:06 AM   #1 (permalink)
the_ruthless
Registered User
 
Join Date: Mar 2005
Posts: 6
the_ruthless is on a distinguished road
Cobol : Embedded Sql

Hello,

im doing a project for school.
We have to make a DB in access and contact it with EMBEDDED SQL
im trying to build a simple search engine now but i get an error.

ERROR MESSAGE

+0000000001

CODE

Code:
       zoek-gegevens.
            EXEC SQL
               select LidNaam, LidAdres, LidGeboortedatum,
               LidTelefoon INTO :lid-naam, :lid-adres,
               :lid-geboortedatum, :lid-telefoon
               from leden
               where LidNaam = :lid-naam
            END-EXEC.
               if sqlcode not = 0
                  if sqlcode = 100
                       display "deze naam bestaat helaas niet"
                        line lijn-nummer position 2
                  else
                       display "een error heeft zich voorgedaan"
                       display sqlcode
                       display sqlerrmc
                  end-if
               else
                  display "naam : " lid-naam line lijn-nummer position 2
                  compute lijn-nummer = lijn-nummer + 1
                  display "adres : " lid-adres
                   line lijn-nummer position 2
                  compute lijn-nummer = lijn-nummer + 1
                  display "telefoon : " lid-telefoon
                   line lijn-nummer position 2
               end-if
               accept lid-nummer.
sorry for the language i use here but im from belgium when you guys want i can translate the variables and text.

there are no error when i compile the project only when i run it and i typed in a name and i press enter to search
the_ruthless is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sql server 2000 validation problems cmartin2 MS Technologies ( ASP, VB, C#, .NET ) 0 12-11-2004 12:55 PM
SQL Server Worm -- Is It Just Me.... technobard Lounge 6 01-30-2003 03:53 PM
loading sql schema from php sde PHP 7 12-11-2002 07:57 PM


All times are GMT -8. The time now is 02:02 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0 RC8 ©2007, Crawlability, Inc.





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting