Recent content by Shobin

Hi,<br> <br> Let me guess you're using forms 5.0... i've also had that error at the beginning then i've installed a patch for developper 2.1 and that message didn't appear anymore.<br> <br> Good Luck<br> <br> Shobin<br>

Hello Tek1234,<br> <br> I'm also using reports2.5 under O7.3 for a while and i don't any way of bypassing that screen... i hope i'm mistaken.<br> <br> Shobin

Hi Bookor,<br> <br> You should try TRUNC, TRUNC(date,'DD'); <br> <br> Good Luck<br> <br> Shobin

If you use the Keyword DISTINCT on your select and don't put the field FullName, you'll have the ProjectID of both SomeNames.<br> <br> About requerying i don't know anything about it...<br> <br> Good Luck

This suggestion it only works for one book at the time, but you can create a cursor to calculate the Position, and then instead of doing the Select substr... create view as Select substr...<br> <br> Declare <br> Position number(2);<br> <br> Begin<br> Select instr(title,' ') <br> into...

Hi,<br> <br> I don't know if you expect only one field as result of your query, see if this helps you:<br> <br> Select count(*),ddate<br> from sorted<br> where to_char(ddate,'MMYYYY') = to_char(sysdate,'MMYYYY')<br> group by ddate;<br> <br> this returns something like this:<br> <br> COUNT(*)...

Hi,<br> <br> I don't know if you expect only one field as result of your query, see if this helps you:<br> <br> Select count(*),ddate<br> from sorted<br> where to_char(ddate,'MMYYYY') = to_char(sysdate,'MMYYYY')<br> group by ddate;<br> <br> this returns something like this:<br> <br> COUNT(*)...

If you add the system parameter MODE to your default parameter form, with the value CHARACTER, you'll have a ascii report. Be careful because some fields of the layout must be bigger or it'll appear **** on the field.

If you use the query on the Oracle Browser you can save the result into a csv file, select the export option and the type of file you which.

On Report 2.5 you have a boilerplate property called Minimum Widow Lines, if you put de minimum lines = 3 an page break occurs..<br> <br>

The only way i'm remembering to speed up your reports is convert them to ascii, instead of bipmap. But you can only do this if you have the source code, that i suppose you don't like you said in another post.<br> <br> Good Luck<br> <br>

The best option is to convert the forms 4.5 and reports 2.5, it's very simple you only need to compile them using the forms builder (5.0) and report builder (3.0).

I don´t know your application of Purchasing, but the pll's are usually on the directory of orant\forms45\plsqlib, orant\graphics\rob\pll, etc...

You don't need to create a dba login, you have two dba users:<br> sys,system<br> <br> They are automatically created and have the dba role. The password from sys is change_on_install , system is manager.<br>

You can use winrsh to call your C program.