Lowyat.NET: Latest topics by aicescko

SQR PROBLEM

aicescko — Tue, 18 Nov 2008 11:52:34 +0800

Hi, I am new here. I am facing his problem. Hope any peoplesoft / SQR expert could help me to solve this problem.

begin-Procedure print-Para_Y1($fieldname0, $fieldname5)
begin-SELECT
[$fieldname0] &fieldname_0=CHAR (+1,1)
do print-Para_Y2($fieldname5)
FROM PS_CP_AWFR003_VW
GROUP BY [$fieldname0]
ORDER BY [$fieldname0]

end-SELECT
end-procedure

(SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 4:
ORA-00936: missing expression
SQL: SELECT DISTINCT FROM PS_CP_AWFR003_VW GROUP BY ORDER BY

Error on line 173:
(SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.

THANKS

[addedon]November 18, 2008, 6:52 pm[/addedon]
solve my problem ...

But Encouter another problem

I need to have get_field_information, Somehow I Got this error.

Error on line 97:
(SQR 2001) Could not find procedure: 'get_field_information'.

And below is my SQR

begin-heading 7
do Get_Field_Information ('AWFGB003', 'REPORT_TITLE', $REPORTTITLE, #DW)
#Include 'stdhtr08.sqc'

do Get_Field_Information ('AWFGB003', 'HIRE_REHIRE1', $HIRE1, #DW)
!do Get_Field_Information ('AWFGB003', 'HIRE_REHIRE2', $HIRE2, #DW)

PRINT $REPORTTITLE (1)
PRINT $HIRE1 (+2,5)

end-heading

!************************************************************************
! Procedure Init-Report
!************************************************************************

begin-procedure Init-Report
show 'PROGRAM: AWFR003 (Turnover Report)'
move 'AWFGB003' to $ReportID
move 'TURNOVER REPORT' to $ReportTitle
do Init_Report_Translation ($ReportID, $ReportTitle)
display ' '
display $ReportTitle
display ' '

do Init-DateTime
do Init-Number
do Get-Current-DateTime
do Stdapi-Init

end-procedure Init-Report

California Vs true fitness vs fitness first

aicescko — Mon, 23 Jun 2008 14:51:58 +0800

Planing to join club next month, is there anyone there can share which club has better equipment, environment and also cheaper price among all.

Thank you

SQR

aicescko — Thu, 29 May 2008 11:17:34 +0800

SQL

aicescko — Thu, 29 May 2008 10:55:09 +0800

PHP website

aicescko — Fri, 16 May 2008 19:15:13 +0800

Hi,

I am thinking to buy php references book, before that, anyone mind to share me which book is good to use ? or mind to share me which website I can learn more about PHP from basic to expert.

Thank you so much

logic test when interview

aicescko — Sun, 04 May 2008 09:24:05 +0800

Anyone mind to share me your experience when go for interview as programmer ?
Where you interview, (company's name)
What is the question
And please provide me answer if you still remember

Thank you

logic test from symhony

aicescko — Sat, 03 May 2008 22:18:54 +0800

anyone know what kind of logic test will be given from symphony ?
mind to share experience ?

thank you

driver for toshiba L200

aicescko — Sun, 27 Apr 2008 10:47:25 +0800

Who can tell me where can I download all the driver for Toshiba L200 by using Window XP ?

vista or XP

aicescko — Sat, 26 Apr 2008 09:06:11 +0800

you guys out there think vista is better or XP is better ?