Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Oracle, Store procedure and custom where Post Reply Post New Topic
Author Message
litterat
Newbie
Newbie
Avatar

Joined: 31 Mar 2011
Online Status: Offline
Posts: 1
Quote litterat Replybullet Topic: Oracle, Store procedure and custom where
    Posted: 31 Mar 2011 at 8:59pm
Hi all
I have a store procedure which check if user can view a record or not
I need to use it in the where clause
something like this
select * from sometable
where sometable.userId = userCanView(sometable.id, sometable.userId)
 
I could not find a way to do this
 
Please help
Thanks in advance
Nehemia


Edited by litterat - 31 Mar 2011 at 9:00pm
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 01 Apr 2011 at 2:20am
get your data via a stored proc, then you can chain/filter on that stored proc.
 
CR will not connect to database to ask it any questions, other than give me this data. For something like that you need to it during the data retrieveal stage, which to use a stored proc like that would be in a stored proc / view
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.