Forms is not cooperating at all!!
ok so idk maybe I'm just not intelligent enough to understand Forms but I have read through various Documentation on Forms 11g and done research on it and I have typed stuff exactly how I read about to put it and nothing seems to be working like it is supposed to.
I am working on making a page that can upload and download a PDF from the client's computer to the Database and back by use of buttons. The upload page has a browse button that is supposed to bring up an open dialog box using webutil and then when the user selects a file the file path of that file will be placed into a text box so that 1. they can verify that it is correct and 2. to store the file path for later. Then the user clicks the upload button and the button is supposed to pull the file path from the text item and store the file located in that location into the database.
here is the code for each of the buttons.
browse button:
DECLARE
File_Path VARCHAR2(255);
BEGIN
FILE_PATH := WEBUTIL_FILE.FILE_OPEN_DIALOG
(
C,
null,
'*.pdf'
)
:block.file_upload_text := FILE_PATH;
Synchronize;
END;
upload button:
Declare
Result_Upload BOOLEAN;
Begin
Result_Upload := Webutil_File_Transfer.Client_To_DB
(
:block.file_upload_text,
'file_tbl',
'file'
);
End;
and the text box is in the data blocks drop down under buttons it was put there automatically by Forms. But when I try to compile it I get an Error 49 bad bind variable 'block.file_upload_text'
the text item name is spelled correctly and everything I have found online says that is how to access the text in a text item I dont understand what is gong on that it isnt working and I am really getting annoyed at Forms because no matter how much I read about it and how much of the little of what is available that I look at I can not figure out what is wrong.
Another problem I am having is that before you even get to this upload page there is another page and that page has a button that is supposed to pull up the upload page and I have figured out enough to figure out that I need the upload page canvas to be a data block in order to call it and then you use a go_block or something like that to pull it up but what I can't figure out is how to make that canvas into a data block... everything that I am finding is saying that to create a data block you need to call a table and stuff and I dont know how I am supposed to put that canvas into a table in the database so that I can create a data block with that canvas in it. I even found something that is supposed to walk you through how to do it and I got to like step 4 of 6 and it said to do something to do with double clicking the database node button or something and I looked everywhere and didn't find anything that said anything about database node. I have been working on this for about a month and a half now and it feels like I have gotten nowhere on it I still haven't even gotten to the download part at all.
I got this same program working completely upload and download in Java in 2 weeks then found out we needed it to work with Forms so I found out I needed it to be a java bean not just java so I tried to figure that out, couldn't seem to figure out how a java bean worked with what I was trying to do and the only documentation I was able to find that might have been helpful for it was on a blog which are blocked from my work computer and I was informed that Forms had something built in that did exactly what I needed, well that hasn't helped much either so far... I could really use some detailed absolutely as dumbed down as possible help here because I really need to get this thing done.
I know I rambled a little and I am sorry, any help that can be provided will be greatly appreciated!!