Search results for query: *

Can anybody tell me where I can find a list of sql errors with the needed explanation? I need the info for sql error 920 Thanks in advance

I have one fixed Frame (eg named left with a single html) where I put a button to print. Now I want to print the other frame (eg with the name right) How can I print only the right frame. Thanks in advance

Thanks, but it's a really large table and it's set at 100% I only get the first 5 columns or so

How can I make sure that I can print an entire page. I can scroll to the right on the page, but when I print the page it only prints the left side. Is it possible to print all what is on the form. Thanks, Pushkin

Ok, thanks, Can I just put in the head-section of the html-script or not? Thanks

Where do I put this? In the head section or someplace else? I've really no idea When I put it in a link on another page (which redirects to my homepage) it opens a new window without toolbars. But I want it to open directly without toolbars (also when you enter the URL in your browser) Thanks

How can I open a window directly without toolbars. It must open without toolbars right after clicking the link. So, my homepage (by matter of speach) must open without toolbars. Thanks, Pushkin

Hi, does anybody know how I can create an asp-page with a script that opens the page without toolbars. Thanks

Hello, I want to put a button on ap html-page that closes this page and opens a new one. The new one must be without toolbars. I've no idea. Please help, Pushkin

Can anybody tell me how I can get the last record from a table. e.g. I created a table with 3 fields id, birthdate and name. I filled the table with data. How can I go to the last data I hava inserted? How can I know what was the last ID I inserted? I only need the value of the final ID...

What do you mean with: -- Do not change already provided value -- use retrieved by get_new_id function

The value before insert must be automaticly filled out in the form. So I need to use this function. I work in WebDB and in this form you can't see the nextval of a sequence when you use a trigger. So I created a function that shows the current value. So people see the id they need and don't...

I created this sequence. create sequence test_seq2 increment by 1 start with 1 nomaxvalue minvalue 1 nocache order Trigger create or replace trigger t_test_id before insert on test referencing old as old new as new for each row begin select test_seq2.nextval into :new.id from dual; end...

Do you know how I could do this. I've absolutely no idea

I've got an application with a sequence, trigger (before insert that uses this sequence) and a function that calls the currval of this sequence. When I run the app Oracle gives this error: ORA-08002: sequence TEST_SEQ2.CURRVAL is not yet defined in this session So, I removed the function and...

Thanks a lot to you all.

I used the above code to create the function and my sequence is increased by 1. I only return one times the value of the sequence and it still increases by 2. Can anybody help me? Greetz

Thanks for the help. There is only one problem, in webdb after insert the sequence increases by 2 instead of 1. Does anybody know how to handle this? Thanks in advance, Pushkin

I'm trying to create a function that generates a sequence. This sequence has to fill a id-field. I can't generate it in the id-field because I need to use it in Oracle Webdb.

Can anybody help me to generate a sequence.nextval in a function, I have no idea how I can do this. Thanks in advance.