Update,Add and Delete in the same Form

[Maki9]

I have a problem of using select CASE,
I am trying to create a form and Use 3 submits which are ADD, EDIT and DELETE on an ASP Page connected to SQL Sever database (DNS connection). But the problem is select Case doesnt work!!! i tried it but still it is giving me errors.
Maki

 

[Cagliostro]

in SQL is no select case, it is only in basic.
In SQL you use

select columnname1, columnname2,.... from yourtable
this is the full sintax of on MS SQLServer select:

SELECT statement ::= 
    < query_expression > 
    [ ORDER BY { order_by_expression | column_position [ ASC | DESC ] } 
        [ ,...n ]    ] 
    [ COMPUTE 
        { { AVG | COUNT | MAX | MIN | SUM } ( expression ) } [ ,...n ] 
        [ BY expression [ ,...n ] ] 
    ] 
    [ FOR { BROWSE | XML { RAW | AUTO | EXPLICIT } 
            [ , XMLDATA ] 
            [ , ELEMENTS ]
            [ , BINARY base64 ]
        } 
] 
    [ OPTION ( < query_hint > [ ,...n ]) ] 

< query expression > ::= 
    { < query specification > | ( < query expression > ) } 
    [ UNION [ ALL ] < query specification | ( < query expression > ) [...n ] ] 

< query specification > ::= 
    SELECT [ ALL | DISTINCT ] 
        [ { TOP integer | TOP integer PERCENT } [ WITH TIES ] ] 
        < select_list > 
    [ INTO new_table ] 
    [ FROM { < table_source > } [ ,...n ] ] 
    [ WHERE < search_condition > ] 
    [ GROUP BY [ ALL ] group_by_expression [ ,...n ] 
        [ WITH { CUBE | ROLLUP } ]
    ]
    [ HAVING < search_condition > ]

Ion Filipski

ICQ: 95034075
AIM: IonFilipski
filipski@excite.com

 

[JamesLean]

I think you should probably post this question in the ASP forum.

--James