Subject | Is there any way to get the record count from the for select or select statements?? |
---|---|
Author | Burak OZLER |
Post date | 2002-01-08T15:30:17Z |
Hi all
Is there any way to get the record count from the for select or select
statements at sp/triger codes like rows affected?
for example
FOR SELECT DOVKOD
FROM DOVKART
WHERE DOVKOD <> :DEFCUR AND TAKIP = 1
INTO :DOVKODU
do begin
bla
bla
bla
end
how can I know the number of record I'll retreive or 'bla' on.
Please somethin better than first count( fieldname) then do sth.
Regards
Burak OZLER
Is there any way to get the record count from the for select or select
statements at sp/triger codes like rows affected?
for example
FOR SELECT DOVKOD
FROM DOVKART
WHERE DOVKOD <> :DEFCUR AND TAKIP = 1
INTO :DOVKODU
do begin
bla
bla
bla
end
how can I know the number of record I'll retreive or 'bla' on.
Please somethin better than first count( fieldname) then do sth.
Regards
Burak OZLER