Search results for query: *

Hi, I had written code to open the excel application through powerbuilder using oleobject. My code was protecting a range of excel cells. It was working fine on excel 2007. Now my machine has excel 2010. Oleobject open function is giving error at open function. How can I correct that...

...Boolean lb_get Oleobject ole_excel,ole_sheet //To get the file path li_return = GetFileOpenName("Select File",docpath,filename,"XLS","EXCEL Files,*.xls,*.xlsm,*.xlss") If li_return < 1 then Messagebox("File","Unable to open the file") Return -1 End If ole_excel = CREATE oleObject...

...when mcpe < 0 then mcpe*-1 else Mcpe end/10),meterCount=COUNT(distinct(meter_id)),P_OR_OP=case when(datepart(hh,end_Date) >=1 and datepart(hh,end_Date) <= 8) then ''P'' when(datepart(hh,end_Date) = 23 and datepart(mi,end_Date) = 59) then ''P'' else ''OP''...

...prefix pattern from string. $var##pattern - remove the longest match prefix pattern from string. for exp $var="/data/bin/prod/test.ksh" then $var##*/ will return the filename test.ksh $var%pattern - remove shortest match suffix pattern from string. $var%%pattern - remove longest match...

Thanks. I got your point.

Hmm... that would be an good option. Thanks for your reply.

So in this way I can set for any time interval. Can you please send me the syntax for 55 min time interval? Your advice is helpful.

Hi Ken, Thanks for your reply. I need to run the job at 45 min time interval. For example if I set the test.sh file in cron starting at 00:00 then it should run at 00:00 AM then 00:45 AM then 01:30 AM then 02:15 AM then 03:00 AM then 03:45 AM etc. I mean at 45 minutes of time interval. To do...

...time interval, but unable to set the time. I want to run the job after 45 min time interval. I tried these two methods to set the time 0-59/45 * * * * * * * * exec /appl/prod/bin/test.sh >/dev/null 2>&1 */45 * * * * * * * * exec /appl/prod/bin/test.sh >/dev/null 2>&1 and in both cases...

...run time for .sh file from every 1 hour to 45 min time interval, but unable to set the time. I tried these two methods to set the time 0-59/45 * * * * * * * * exec /appl/prod/bin/test.sh >/dev/null 2>&1 */45 * * * * * * * * exec /appl/prod/bin/test.sh >/dev/null 2>&1 and in both cases...

Thanks mbalent.

Hi All experts, I have one question.. When I change the column size of a table in database. I need to do change in all dataobjects where this column is being used. Is there any way in powerbuilder where at one shot change affects in dataobject. Currently I need to open all dataobject one by...

Hi, Can anybody provides the powerbuilder 7.0 setup files. I want to install pb 7.0. I want to work on pb 7.0 Please help me. I know somebody must have pb 7.0.

on which object you are writing the coding ?

No.... I was trying with Message object, but application was hanged during compiling the GetMessageA(). I will try with String datatype and let you know what happend. Have you ever tried these API function ?

How Can I Declare GetMessageA and TranslateMessageA API function as it has an reference argument of type msg and in powerbuilder there is no such any msg datatype. It is saying "Illegal data type msg". Actual declaration of API function is FUNCTION ulong GetMessage(ref Msg lpMsg,ulong...

Where did you read changing column case will solve the problem?

Here uf_search_folder will take 2 argument as oleobject as_ole_object oleobject as_original_object and will return object of oleobject type

...outlook folder list. This can be at any level. My program search in all outlook folder list and return the folder object which I am searching. /* Main Code */ OLEObject ole_outlook,ole_namespace, ole_folder Long li_return,li_items,li_row,li_count String ls_name,ls_classname //6 -...

To pass any value in embedded DW, only retrieval argument is the way.what's the problem not calling retrieval argument? Are you facing any problem ?