The Declare cursor SQL construct or statement is not supported.

[juan.gautier]

Hi,

I try to construct a SQL code for a view to select a specific data
from a table, this query take the value of the filter from a text box
in a visual basic 6.0 form. my problem is when i DECLARE the variable
@AMP receive a error message that said "The Declare cursor SQL
construct or statement is not supported." What i do wrong? Please help
me. i attach the code.

DECLARE @AMP int;
SELECT Size, Type, Ampacity, Isulation, Temperature, Material
FROM dbo.Conductors
WHERE (Isulation LIKE 'THHN') AND (Material LIKE 'COPPER') AND
(Ampacity = @AMP)


Thanks!!!

[Lennart]

ju**********@gm ail.com wrote:

Hi,

I try to construct a SQL code for a view to select a specific data
from a table, this query take the value of the filter from a text box
in a visual basic 6.0 form. my problem is when i DECLARE the variable
@AMP receive a error message that said "The Declare cursor SQL
construct or statement is not supported." What i do wrong? Please help
me. i attach the code.

DECLARE @AMP int;
SELECT Size, Type, Ampacity, Isulation, Temperature, Material
FROM dbo.Conductors
WHERE (Isulation LIKE 'THHN') AND (Material LIKE 'COPPER') AND
(Ampacity = @AMP)

Not sure what you mean by view, is it view as in "create view ..."? If
it is I would advise against creating ddl objects on the fly. If this is
just a query, I would suggest that you use a prepared statement. I dont
see why you would have to declare anything for this particilar query.
Using a pseudo syntax:

ps = new prepared_statem ent(
"SELECT Size, Type, Ampacity, Isulation, Temperature, Material
FROM dbo.Conductors
WHERE Isulation = ?
AND Material = ?
AND Ampacity = ?")

ps.setparameter (1, 'THHN')
ps.setparameter (2, 'COPPER')
....
ps.executequery ()

I dont know VB but I assume it has something atleast similar to a
prepared stmt
HTH
/Lennart

[Knut Stolze]

ju**********@gm ail.com wrote:

Hi,

I try to construct a SQL code for a view to select a specific data
from a table, this query take the value of the filter from a text box
in a visual basic 6.0 form. my problem is when i DECLARE the variable
@AMP receive a error message that said "The Declare cursor SQL
construct or statement is not supported." What i do wrong? Please help
me. i attach the code.

DECLARE @AMP int;
SELECT Size, Type, Ampacity, Isulation, Temperature, Material
FROM dbo.Conductors
WHERE (Isulation LIKE 'THHN') AND (Material LIKE 'COPPER') AND
(Ampacity = @AMP)

Have a look at the DECLARE CURSOR syntax: http://tinyurl.com/2mnmgf

It would be something like:

DECLARE @AMP INT;

DECLARE cursName CURSOR FOR SELECT ... FROM ... WHERE ...;

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany