Home » Developer & Programmer » Forms » Post-Query result
Post-Query result [message #77598] Tue, 16 October 2001 03:57 Go to next message
Fernando
Messages: 10
Registered: September 2000
Junior Member
How i can to know if a query return zero record?

----------------------------------------------------------------------

Report message to a moderator

Re: Post-Query result [message #77599 is a reply to message #77598] Tue, 16 October 2001 04:02 Go to previous messageGo to next message
Lars Sjöström
Messages: 24
Registered: June 2001
Junior Member
%ROW_COUNT% is zero. or NO_DATA_FOUND is set, to be used in EXCEPTION-clause.

----------------------------------------------------------------------

Report message to a moderator

Re: Post-Query result [message #77601 is a reply to message #77598] Tue, 16 October 2001 04:17 Go to previous message
Fernando
Messages: 10
Registered: September 2000
Junior Member
My problem is how to know de number or record of the block that is associated to post-query record.

With %ROWCOUNT% or NO_DATA_FOUND i can to know de number of record of a cursor result.

Thaks

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: migration of forms and reports from windows to Unix
Next Topic: Re: Forms 4.5 on Windows 2000
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jan 18 11:30:26 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.