Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    4

    Unanswered: How to make a string with this Query?

    Hi guys,

    I need to make a query with this algorythm whithin one single String.

    Code:
    IF X < 18
    Start
     DELETE from School WHERE age = 17;
     DELETE from Party WHERE hobby = 'alcohol';
     DELETE from Girls WHERE hair = 'blodes';
    End
    INSERT School (age, name) VALUES(17, 'RaiL');
    INSERT Party (drink, name) VALUES('soda', 'RaiL');
    INSERT Girls (girls, name) VALUES('none', 'RaiL');
    Any idea?

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Based on this post:
    http://www.dbforums.com/delphi-c-etc...de-1064-a.html
    Please can you state what database you are using?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2009
    Posts
    4
    Quote Originally Posted by pootle flump
    Based on this post:
    http://www.dbforums.com/delphi-c-etc...de-1064-a.html
    Please can you state what database you are using?
    Server Version = 5.0.67-community-nt

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I meant what relational database server. But that answers the question- you are using MySQL. This is the SQL Server forum. Two different products.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •