Recent content by siraj777

Thanks guys. The query took less than 1 second to finish the execution. SELECT r.quarter FROM rcqtr r, (SELECT MAX(rcqtr_num) mymax FROM rcprod11) a WHERE r.rcqtr_num = a.mymax;

SELECT quarter FROM rcqtr WHERE rcqtr_num = ( SELECT MAX(rcqtr_num) FROM rcprod11 ) rcprod11 table having 400,000 rows. rcqtr table have around 1000 rows. The above query is taking 30 seconds. Any ideas to tune it?

SELECT STATEMENT, GOAL = CHOOSE 1 1 17 TABLE ACCESS BY INDEX ROWID MAV83_PRIME3 RCQTR 1 1 17 INDEX UNIQUE SCAN MAV83_PRIME3 PK_RCQTR 1 SORT AGGREGATE 1 13 INDEX FULL SCAN MAV83_PRIME3 AK_RCPROD11_IDX_1 1 13

SELECT quarter FROM rcqtr WHERE rcqtr_num = ( SELECT MAX(rcqtr_num) FROM rcprod11 ) rcprod11 table having 400,000 rows. rcqtr table have around 1000 rows. The above query is taking 30 seconds. Any ideas to tune it?

Working on PowerBuilder 8 with Oracle 9 dw_1.DeleteRow(li_row); // Deleting row If dw_1.Update() = 1 Then // Updating the table COMMIT USING SQLCA; // Commit End If // DO I need to write the below line of code If SQLCA.SQLCODE = -1 Then ROLLBACK USING SQLCA; END IF

Using PowerBuilder 8 with Oracle 9. dw_1.DeleteRow(li_row) dw_1.Update() COMMIT; Is the ROLLBACK automatic when COMMIT FAILS? or do we need the following statement? If sqlca.sqlcode = -1 Then ROLLBACK

Hi, I am using Oracle 9i as database and the frontend application in PowerBuilder 8 which will be installed in English or French Version per user basis. I was successful in translating the frontend text and error messages. Please let me know how to translate the server messages from English to...

Addition to the above.. Installed the localized french version of PB deployment kit which is converting powerbuilder generated error messages into french successfully (eg: Invalid Datawindow row/column). I need a utility / procedure / process which converts oracle backend messages (eg...

PB8 has own built-in search tool. Open Library Painter from the menu Entry --> Library --> Search

Is there any tool which takes english words / phrases / sentences as an argument and returns french equivalent. for ex: string ls_err ls_err = sqlca.sqlerrtext ls_french = trans_french(ls_err) Thanks.

I am trying to use Translation Tool Kit in PowerBuilder V 8.3.1 and I am connecting to TRANSLAT.DB using ODBC. (Datasources ODBC) ServerName: EASDEMODB4 StartLine:..\dbeng7.exe -d -c8m Database Name:TRANSLAT Database File: <location> Getting following error message Connection Failed...

COMMIT; Do COMMIT; SQLCA.MoveTimelines( is_cono, is_plant,is_dept,is_oldcctr, li_rtn ) COMMIT; i = i + 1 LOOP WHILE li_rtn > 0 and i <= 0 COMMIT;

Sorry. It didn't work out.

Hi, I am calling a stored procedure from Powerbuilder using n_tr.procedurename(parameters). This procedure will take set of rows and does something. Surprisingly it works fine in PowerBuilder Debug mode (process all rows called from a loop), but in runtime it blowsup after processing only 1st...

create static text same size as check box (square) with grey color and put on top of checkbox. Use bringtofront / sendtoback properties whenever is needed.