Search results for query: *

PeopleBooks PeopleCode Built-in Functions This chapter provides a reference to PeopleCode built-in functions and language constructs and discusses: PeopleCode Typographical Conventions Functions by category PeopleCode built-in functions and language constructs...

create an expression SELECT A.ACQUISITION_DT, MONTH( A.ACQUISITION_DT) FROM PS_ASSET A WHERE A.ASSET_ID = '000000018629' http://programmer-by-the-hour.com

select SUM(XX.LENGTH) FROM SYSIBM.SYSCOLUMNS XX where XX.tbcreator = 'DBAADMIN' AND XX.tbname = 'YOUR_TABLE_NAME' http://programmer-by-the-hour.com

This should work... Select * from SW.ADDR_VERIFICATION where QUADRANT = pQUAD and STREET = pSTREET and pADDRESS_NUMBER between LOW_ADDRESS and HIGH_ADDRESS and STREET_TYPE between (CASE WHEN pSTREET_TYPE IS NULL THEN ' ' ELSE pSTREET_TYPE END) and...

Try something like this and you won't need the "IF"... Select * from SW.ADDR_VERIFICATION where QUADRANT = pQUAD and STREET = pSTREET and pADDRESS_NUMBER between LOW_ADDRESS and HIGH_ADDRESS and STREET_TYPE LIKE (CASE WHEN pSTREET_TYPE IS NULL...

Don't you need to say ":max" instead just "max" http://programmer-by-the-hour.com

You could try concatenating in a ps_query expression... i.e. select tAP3L.BUSINESS_UNIT||'`'||tAP3H.journal_id FROM PS_JRNL_HEADER tAP3H, PS_JRNL_LN tAP3L http://programmer-by-the-hour.com

You can create a temp table to include your @local_vars and then select from it. http://programmer-by-the-hour.com

Sounds like a new field you've added and have not re-built the table (Personal_DATA). Be careful when building the table if you have data in it already. Back-it up, build table, re-load it. Best Regards, http://programmer-by-the-hour.com

In reference to the "invalid column name" error, while you might have added the field in PeopleSoft, it sounds like the field is not on the database table. To verify that the table did get created do the following... If Oracle then do a (describe on the table). If MSSQL, then...

This sounds like a job for a MassChange process... http://programmer-by-the-hour.com

An expression is just a column on the query and you don't have to create a field to have an expression. If Oracle you'd probably use DECODE() else CASE. SELECT A.BUSINESS_UNIT, A.ASSET_ID, DECODE ( A.ASSET_ID,'000000000001','ONE','NOT-ONE') FROM PS_ASSET A WHERE A.BUSINESS_UNIT = 'AUS01'...

I would created a view of what is on the sub-report to use on my main report... Hope this helps! http://programmer-by-the-hour.com

Hope this helps... If you turn trace on, with options to trace>>sql,>>peoplecode. then you will have log files to look at http://programmer-by-the-hour.com

I just tried it... Field(execute_pb) attatched to a "command button" in the FieldChange-event, I added the following... SQLExec("EXECUTE 8x_ztree1 'SHARE' ,'BD_DEPARTMENTS','ALGO')"); http://programmer-by-the-hour.com

Hope this helps... on a command button SqlExec("myproc") http://programmer-by-the-hour.com

Need help with the following... Connecting VB to Oracle 8i using ADO http://programmer-by-the-hour.com

I tried this and I get an error... Run-Time error '426': Only one MDI form allowed. ... MDIParentFormName.sbStatusBar.Panels.Item(1).Text = "location (" & g_sys_location & ") Year (" & g_sys_Year & ") Season (" & g_sys_Season & ")&quot...

In my MDIForm I've got this code below and it works fine... public sub updbar() sbStatusBar.Panels.Item(1).Text = "location (" & g_sys_location & ") Year (" & g_sys_Year & ") Season (" & g_sys_Season & ")" From any MDIchild forms, how can I reference the...

Crystal and SQR is included with PeopleSoft and is the most common combination. PeopleSoft does include some canned reports, but like every business there is always a need for some custom reports. As far as format well Crystal is Crystal and SQR is batch process and one can use any editor...