Search results for query: *

In the form, I only want the person creating, or approving or the managers to see their own data. So, I put a where clause on the datablock for security within the form. However, my problem is when I try to query on JUST ONE record it still brings me all the records in my set. Any ideas...

Sorry so long, DECLARE AppID PLS_INTEGER; WebBrowser VARCHAR2(100) := 'C:\PROGRA~1\NETSCAPE\Communicator\PROGRAM\netscape.exe'; WebPage VARCHAR2(100) := 'http://www.xxx.xxxx.gov/xxxxxxx/index.cfm'; BEGIN AppID := DDE.App_Begin(WebBrowser || ' ' || WebPage, DDE.APP_MODE_NORMAL); EXCEPTION WHEN...

No need to respond I have figured this one out.. thanks

Hey I have created my table with a LONG datatype. In the form it will only let me put a 400000 char limit on the field size before it starts erroring out. If I make the char field more than 400000, when I do a query it says "query caused no records to be retrieved", when I change it...

I didnt see what you were talking about (in the help file). So, you're saying that I need to set_item_property on the item UPDATABLE to true? in which trigger?

I am using Forms 5. I have a field (FSC) with a LOV attached. There are essentially 2 values in the lov, 0 = no MSDS 1-7000 = various descriptions for the MSDS(material Safety Data Sheets) if they choose 1-7000 it populates the field (DESCR) with the description of the MSDS they chose and...

Hey is there a way to have the report print out 0, or something other than nothing when there are no rows returned from my query?? Is there something that I can set to tell it to print a value (like "no rows returned") when no rows are retrieved from the query??? Thanks in advance!

microgreen,, I already figured this one out months ago. We threw the info in a temp table. It was easy once I understood what in the world I was doing! LOL Thanks tho!! Have a great Holiday season!

I am still new to Oracle and we want to explore the capabilities of the Reports Server. We have a copy of Oracle Developer/2000 Reports 3.0.5.8.0. We have no documentation. We normally just create reports and call them from forms. If the Reports Server is included in Developer/2000, please...

When I check my scheduler.log file I get this. It is great that it submitted successfully, but look at the date??? for the year 2000 it showed 100 & for year 2001 it shows 101. We havent realized this before...

We got it. It is blank by default. Thanks!

We are installing Crystal Reports on our server. Is there a default password for the User ID administrator or any default User ID's & passwords??? During the set up it asked for a NT user name & password so we put in the administrator UN & PW in that dialog box, it said we could change it if...

I am not sure if I got that Sem, but I got it working. I took the easy way out. I created a web page & then redirected it to the web site that I wanted it to go. So now when you click on the button it will go to the web page I created, but it redirects automatically to the other site, so the...

Hey everyone, we finally figured out how to place a button on a form that will call a web page (internally or externally) and now I have encountered a new problem.. A folder that is referenced in teh hyperlink has an " ' " in it. This is causing problems in the compilation of the...

I am trying to do some documentation at work. Can anyone give me a clue as to what is happening in this part of the code? I am very new to CF and would like some help. <cfset strtoe_code = ''> <cfloop query=&quot;getOracleData&quot; > <cfset strtoe_code = strtoe_code & &quot;,&quot; &...

I have figured it out. If anyone needs the info, let me know.

Hey I am wanting to put a button on a menu form & get it to pull up a web site when you click on the button. any ideas? Thanks a bunch!

we got it figured out. It was a pain but it all worked out I would love to explain, but that would take me all day... lol Thanks!!!

the reason we used a form is because we have to pull the PO info from the database 1st, then the user inputs their info about 2 other vendors on that form. Then it all prints out on a report. Initially I tried using a parameter form in the reports, but I needed 2 parameter forms, one to pull...

hey, this is my first big project using forms & reports. I do have a general understanding and have created several general reports & forms. But this is a little more complicated. We have a user that wants to be...