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

...the server messages from English to French for a PARTICULAR SESSION ( per user) in ORACLE. I have a multi lingual database. For ex: SQL> select * from t; ORA-00942: table or view does not exist should appear as ORA-00942: table ou vue inexistante I used NLS_LANG parameter for date...

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