Search results for query: *

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...

My expectaion is to know whether myapplication.exe is running or not ? if it is running then not to allow to open another one. sometimes let's say ...myapplication.exe is running , u can see from TaskMgr but the application did not appear due to some reason in windows os. I tried all the way...

I tried as per you. but still I'm able to run two instances . Anyway ..thanx a lot

I'll appreciate if you can please send me the script .....

find the preview(example) of the DB profile ... // Profile MARRIOT SQLCA.DBMS = &quot;MSS Microsoft SQL Server&quot; SQLCA.Database = &quot;TESTDATABASE&quot; SQLCA.LogPass = <****> SQLCA.ServerName = &quot;TESTING&quot; SQLCA.LogId = &quot;testuser&quot; SQLCA.AutoCommit = False SQLCA.DBParm...

why do u want to check the settings ..just do as u want . Below find few examples .... Date fromdate fromdate = today() Messagebox('vulcanjena',string(fromdate)) RESULT --> MM/DD/YYYY Datetime fromdate fromdate = datetime(today()) Messagebox('vulcanjena',string(fromdate)) RESULT -->...