i need the user to supply a password for decrytion. After which the decryted
data will be stored into a temporary table (ORACLE). After displaying the report, i
need to delete all the records from the table. Is there any way out? I can't get
stored procedure to work in crystal, in fact i can't even see my stored procedure (
that handles the decrytion) in crystal report. My guess is because this stored
procedure requires parameter in and output a value. thus there's no way i can see this
stored procedure and thus i chose the latter method of storing the records in a table
first then delete it after loading the report.
what would u recommend for such a case?
-----Original Message-----
From: Kwang Suh [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 10:18 AM
To: CF-Talk
Subject: Re: How To Delete Recs After loading of crystal report (URGENT)
If you're using SQL Server, you can put your results into a temporary table.
But why are you putting the report data into a table in the first place?
Why not just do a select statement?
----- Original Message -----
From: "JAIME HOI" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, March 30, 2003 6:30 PM
Subject: How To Delete Recs After loading of crystal report (URGENT)
> Hi
> Does anyone knows how to delete records from a table after crystal
report completed loading its report? i tried using CFX_WAIT however , it
deleted the records before the report was able to retrieve it and display
it.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
