Powerbuilder中定义游标,就这几句就错了,求解,解决办法
Powerbuilder中定义游标,就这几句就错了,求解,急!!!!
这是测试的代码
就写了这几条语句就一堆错
create procedure fenpei_seat_ss
as
declare fenpei cursor for
select stno,floor,area from seat where available='y';
open fenpei;
fetch fenpei into :stno_info,:floor_info,:area_info;
close fenpei;
错误如下:
1、尚未声明游标
2、fetch附近有语法错误
3、游标未打开
刚学PB,求教
怎么回事呢,怎么在PB的数据库中定义存储过程和游标呢???
------解决方案--------------------
//create procedure fenpei_seat_ss
//as
declare fenpei cursor for
select stno,floor,area from seat where available='y';
open fenpei;
fetch fenpei into :stno_info,:floor_info,:area_info;
close fenpei;
------解决方案--------------------
支持二楼,定义游标不用建过程哦。
这是测试的代码
就写了这几条语句就一堆错
create procedure fenpei_seat_ss
as
declare fenpei cursor for
select stno,floor,area from seat where available='y';
open fenpei;
fetch fenpei into :stno_info,:floor_info,:area_info;
close fenpei;
错误如下:
1、尚未声明游标
2、fetch附近有语法错误
3、游标未打开
刚学PB,求教
怎么回事呢,怎么在PB的数据库中定义存储过程和游标呢???
------解决方案--------------------
//create procedure fenpei_seat_ss
//as
declare fenpei cursor for
select stno,floor,area from seat where available='y';
open fenpei;
fetch fenpei into :stno_info,:floor_info,:area_info;
close fenpei;
------解决方案--------------------
支持二楼,定义游标不用建过程哦。