Recent content by BigM

Hi, I am wanting information on the different ways in which to web front end an Oracle DB. We have plenty of PL/SQL and Forms experience in a Client Server architecture but are wanting to write an application with a web front end. Apart from web enabling forms, which we have ruled out what...

Hi, I have been using Developer for a while and currently am using Forms 6i. However the app I am working on has a Windows 9x look and feel to it. I am wanting to give it a more up-to-date look and feel. Could anybody out there point me to any resources, papers or ideas for this. Many Thanks...

Hi Each, I have two schemas, lets say schema1 and schema2. I am wanting to move all objects and any data from schema1 to schema2. Any quick easy ways? TIA Big M

Hi, I am wanting to process all items within a block and set the visual attribute according to a value retrieved from the database. This to be done on when-new-block-instance. Code is as below but using next_item triggers of validation etc.....is there any other way of looping through items in...

Hi All, I am wanting to create a drop list box which when you enter and type a letter or number the current hilighted entry seraches progressively. For example if I have a drop list of names and enter B the list moves to the head of Names beginning with B, if I then enter R it will move to the...

Hi All, I am wanting to create a drop list box which when you enter and type a letter or number the current hilighted entry seraches progressively. For example if I have a drop list of names and enter B the list moves to the head of Names beginning with B, if I then enter R it will move to the...

Thanks but I have tried that but I get "Undefined Function 'Format' in expression" SELECT Format(scheduled_date,'mmmm') FROM View_Scheduled_Actions;

Hi, Probably really simple but cant find out how anywhere but...how do I extract the month name from a date in a sql query in access. So I want to extract "May" from this date "06/05/1967" which is in format DD/MM/YYYY. TIA

Simple question....I am an experienced Oracle developer but am wanting to move into Java/Oracle development for obvious reasons.... Where do you people recommend I start....SQLJ or JDBC? TIA Martin

Hi Ed, If that is the case its a pretty fundemental flaw. What a complete p*sser!!!! I will have to think of some other way of housekeeping as there could be many of these files left lying round on the web server. Maybe I could check the create date on files and if its more than a day old...

Hi, I have the following global.asa which should delete any files created during the current session. The file names when created contain the SessionID so each user has their own copy of the files to work on. However this doesnt seem to be working...the files are not deleted when the session...

Yoofs, It was the semi-colon at the end of the statement. Within SQL*Plus the semi-colon at the end executes the statement. Obviously this is not required with ADO. So statement should read ------------------------------------------------- strShowSQL = "UPDATE bv_prt_link_main SET...

Hi, I am getting the following error when running my update statement. Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00911: invalid character The SQL statement does NOT contain invalid characters as I can cut and paste it into a SQL session and it runs fine. Statement is as...

Hi, A quick question....are session variables still available in Session_OnEnd or are they destroyed before this sub is called? Thanks

Just use form.action you numbskull.... where action is the script name of where you want to submit the form. X