Create Store Procedure From Delphi

Posted on 2006-04-18
Last Modified: 2010-04-05
I am trying to create a store procedure from my Delphi program. I use an ADOComand to execute the procedure create script.I find 2 problems...if i do not use GO in my statement in script i get error becouse 'Create Procedure' must be firs and if i use GO i get 'Incorect syntax near GO statement error'. EOLEException Error. In SQL Querry Analizer the script work fine so...what could be the problem ? elese can i create my procedure at program runtime ?...thanks you all
Question by:dannertb

    Author Comment

    By the way ..Database Server is MSSQLServer 2000
    LVL 11

    Accepted Solution

    Dont use GO, I just tried it with an ADOCommand and a ADOConnection,

    in the ADOCommand  Text property I had

    SELECT * FROM TestTable

    the commandtype was set to cmdText

    then on a button I just had

    ADOCommand1.execute and it worked ok

    Author Comment

     ExecuteInit.ParamCheck := False;

    It worked OK in this problem was that i wanted to create more than one procedure in one script...but separtely it works fine...10x

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Join & Write a Comment

    Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
    Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now