How can I connect 2 different databases via database triggers?
DB1 = Oracle 9i Version 9.205
DB2 = Oracle 7.23
both databases are running above unix.
DBLink doesn't work with those versions, and I want update differents tables between databases.
Thanks.
How can I connect 2 different databases via database triggers?
DB1 = Oracle 9i Version 9.205
DB2 = Oracle 7.23
both databases are running above unix.
DBLink doesn't work with those versions, and I want update differents tables between databases.
Thanks.
I have a table named
TEST_TABLE
COD_A NUMBER(1)
FIELD_1 NUMBER(7)
DESC VARCHAR2(10)
I have a trigger AFTER UPDATE on FIELD_1, when I update the the field DESC via SQL, the database trigger doesn't fire, and this is fine, but if I update the field DESC via FORM, the database...
Alexhu, in my company we have aplications developed in forms 6i with Oracle 9i.
Is necesary that a coleague learn this old software by himself, for that reason he must install Fomrs 6i in his house computer.
which configuration do you recommend to learn Forms 6i?
thanks.
I am trying to install Personal ORACLE 8.1.6 on Windows 2000 Spk 4, my PC configuration is :
Processor: Pentium IV 1.4 GHZ
RAM : 256 Mb.
when the installation software are running, I received an error like that :
Error: "The area is not valid. There aren't superior level components for...
sorry, I find the answer...
I had been using the incorrect procedure, the right procedure is :
WIN_API_SHELL.STARTFILE(:block.file_name_xls,WIN_API.SW_SHOWNORMAL,TRUE);
thanks,
Pablo
I use the WIN_API library, exactly the function
WIN_API_SHELL.WINEXEC(:block.file_name_xls,WIN_API.SW_SHOWNORMAL,TRUE);
:block.file_name_xls contain 'c:\sheet.xls'
(the file exist in the root directory)
I want open the excel application with the file store in the item.
then, forms send me...
you must set the system parameter named DESTYPE (in the report) to "PRINTER", then the report directly will be printed. Too you must delete all entry parameters from Window Parameter in the report:
In the Report Editor (button with the icon "xy"), press the button named "Parameter Form Builder"...
Hi, Dima.
I don't have problems with the system variable, realy I don't know why Forms don't change the current record apereance thought I use the right property (I think).
POST-QUERY trigger on the block.
IF MOD(TO_NUMBER(:SYSTEM.TRIGGER_RECORD),2) = 0 THEN
SET_ITEM_INSTANCE_PROPERTY...
This thread is a rply of thread259-877570
The lewisp's solution work fine, but I want to highlight the current record with another color, but when I stay in a record with another background color activated by the trigger POST-QUERY, the current record's color don't change.
Thanks.
Pablo...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.