Search results for query: *

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.

There are 5 datawindows. The first datawindow is sorted on column A by selecting it from sort dialog box. (dw_1.Setsort(null) - columns are selected dynamically) How to sort the remaining 4 datawindows on the same column/s without prompting the dialog. In other words how to get the column/s...

Problem with find. Long ll_found String ls_findexp, as_date, as_time ls_date = '09/17/2003 15:06:00' ls_time = '12:00:00' Scenario 1: ls_findexp = &quot;DateTime(crit_date,Time(&quot;+as_time+&quot;)) <= DateTime ('&quot; + as_date + &quot;')&quot; ll_found =...

Thanks for your reply. The above problem was solved by sending string type data from PowerBuilder and converting back to decimal inside the stored procedure. set @hoursdec = convert(decimal(6,1),@hours)

HI, I am using Powerbuilder 6.5 and MS SQL Server 7.0 I am calling stored procedure with an argument of decimal data type. Decimal ldc_hours ldc_hours = dw_1.GetItemDecimal(1,&quot;hours&quot;) sp_hours(ldc_hours) In Sql Server Procedure <name> hours decimal(6,1) AS <etc.,> Now the real...

While compiling pb application (6.5) for 16bit deployment getting the following error. Compiles fine for 32 bit. any ideas? Compiled segment size exceeds 64K for object::function