Recent content by vulcanjena

MSCAL.OCX & MSCOMCT2.OCX are two OCX we generally used for Calendar utilties. But these two needs license to use. This comes with MS Access software. It was free along with MS Office/Access 97 but later it is been copyrighted. So in your case , the previous version is over wiritten with the...

yep, no problem , even the whole thing is working perfect , I'm getting error message when I'm trying to change this &quot; ( WFCTOTAL.DURATIONSECSQTY <> 0 ) AND &quot; to ( WFCTOTAL.DURATIONSECSQTY >= 0 ) AND or ( WFCTOTAL.DURATIONSECSQTY = 0 ) AND or ( WFCTOTAL.DURATIONSECSQTY > 0 ) AND...

It is running perfectly OK in Query analyser , only difference is I'm putting the values in arguments. thanx

SELECT PERSON.PERSONNUM, BADGEASSIGN.BADGENUM, VP_HOMELABORACCT.LABORLEVELNAME1, VP_HOMELABORACCT.LABORLEVELNAME2, VP_HOMELABORACCT.LABORLEVELNAME4, ISC_PAYCODECONFIG.SHIFT_CODE, sum(WFCTOTAL.DURATIONSECSQTY )/3600.00 as TotalWorkedHours...

PB8.0 and MSSQL server 8.0 , I'm getting error : Invalid Coulmn Name &quot;colname&quot; where as the same script is running Ok in Query Analyser in MS-Sql. Do anybody have any idea /solution ? Thanks in advance !

Have you defined the DB profile in your PB ? If yes then check all the fields , like catelog owner etc . In SQL the table owner by default is dbo . Best of luck ...

Can you please elaborate little more ? Have you tried through PB6 profile ?

Thanks for the reply ..get back asap.

The script for the packages/function is like shown below. //--------------- BEGIN IF cmo_utilities.cmo_calculate_massive THEN dbms_output.put_line(' Recalculate Process finished successfully '); ELSE dbms_output.put_line(' Recalculate Process has errors. Please check...

I'm using ORACLE9 with PB9. I have a package defined with many functions for a massive calculations. How can I execute that package in PB scipt ?

It is b'cos u don't have any data / inserted no data there. Or if you have data then check the properties of the datawindows etc.

Thank a lot !

How can I save a generated Report in PDF format ? Also is there anyway I can save them into WORD format ? Thanks in advance. vulcanjena

You can use PB9.0 ....even though u have to change a lot but reduce a lot of scripting as so many new PB functions are included along with multiuse etc. good luck..

there are different ways to do this things depending on different scenarios. I don't know what ur expecting to do .... # If you just simply want to import from a file(txt without headers) then I think the database itself provide tools/menuoptions to import . #But if ur importing data from a...