Recent content by abhijit74

Hey PowerObject, I tried doing exactly the same thing I did this dw.SetFilter(&quot;Col1 IS NULL and Col2 <> 'N') However I observed that it gave me a datawindow &quot;invalid function error&quot; I am using 6.5 Cheers! Abhijit

Hi Folks, I want to use SetFilter function of the datawindow to specify a condition. The condition is that column value should be equal to a null. Please help me. Regards, Abhijit

Granted. Ok. I get it. It should come from some one with DBA privs. Any ideas on how to get DBA privs? In our shop, the DBA's never listen to the developers. Regards, Abhijit

Hi Folks, I am unable to create a function based index on a table. The error I am getting in invalid column name. The function I am trying to use is SUBSTR(COLUMN_NAME,1,3) I tried creating function based index for UPPER(COLUMN_NAME). It doesn't work either. I keep on getting insufficient...

Wouldn't replacing the c:\IChoose with the default sql server directory be a obvious option? -Abhijit

Does this DBMS_UTILITY.COMPILE_SCHEMA procedure work in 8.1.7?

There is no facility to bookmark. You might have to use a sequence number and keep track of the same. If you have solved this problem, let me know how did you do it. Cheers! Abhijit

Gunjan, Null doesn't affect the SUM function. Seems to me that you have missed something else. Cheers! Abhijit

Jessica, I was wondering if you could post part of your code. Cheers! Abhijit

There is a package called PL/SQL Developer by AllRound Automation which has a feature of compiling all invalid objects. How do you do this in SQLPLUS? Cheers! Abhijit

hi folks, i am facing a problem in tryin to keep track of the current row of a datawindow. i use the dw.GetRow() function to get hold of the current row. I have written this function in the scrollvertical event of the datawindow control. I notice that scrolling in the dw has no effect on this...

I am facing problems with the vertical scroll event as well. I am trying to get the currentrow in the datawindow after the user has scrolled. The GetRow function always seems to be returning a 1, no matter which row has been scrolled to. Any explanations? I am using PB 6.5 Cheers! Abhijit

Thanks mate. Will get there!

Is there some website where I can access Powerbuilder online books? I don't access to them on my machine.

Thanks for your prompt reply. I have got different column types in my datawindow including datetype, float type and integer type columns. Does that affect the update method of the datawindow? Do I need to take special care before updating? Cheers! Abhijit