PB 6.5 , OLAP and OCX


I want to give a drilldown functionality in the app. I am using Microsoft
Horizontalflexgrid and ado.
I am connecting to the ado and want to assign the recordset created to the
horizontal flexgrid.

There are couple of questions:-

1. How do I check whether the ADO has created a recordset or not  in PB 6.5

2. "ole_hflexgrid.object.rowset = nvado.recordset", this statement is giving
me a error accessing external object property rowset.  What am I doing wrong
? ( the full code is given below)

3. This is the strangest  of all. I tried going thru the mshflx98.chm. I am
unable to find any help for the properties Data source, Record source or
Rowset. But these properties are seen when you use the object browser in PB


long ll_status

nvado = create oleobject

/*connect to the object first*/
ll_status = NVado.ConnectToNewObject ("MSadodclib.adodc.6")
if ll_status < 0 THEN
  messagebox("Error", "Could not establish connection to

end if

NVAdo.datasourcename = "sybaseadoodbc"
NVAdo.username = "sa"
NVAdo.password = ''
Nvado.commandtype = 1
NVado.recordsource = 'SELECT * FROM TABLE1'
NVADO.connectstringtype = 3
nvado.maxrecords = 100

ole_hflexgrid.object.rows = 10
ole_hflexgrid.object.cols = 5

ole_hflexgrid.object.rowset = nvado.recordset

6/28/2000 11:25:23 PM
sybase.ole-ocx-activex 6324 articles. 0 followers. Follow

0 Replies

Similar Articles

[PageSpeed] 0


Similar Artilces:

Delphi 5 OCX and PB 6.5
Hi I have created a Delphi 5 ActiveX that manage a series of BMP images. I inserted it in PB 6.5 (using the tips posted here, i.e., getting a native pointer, etc.). It worked fine... for a while. But now I'm having a little trouble with the following description: Within the ActiveX inserted in PB 6.5: 1.- I construct an image (a BMP) for printing it. 2.- I use the delphi printer object to put a title over the image. 3.- I print it and everything is OK. The title and the image appear. 4.- Here is the trouble. I print it again and just the title appear. I don�t know why the ...

OCX and PB 8 (vs PB 6.5)
We have developped an application with PB 6.5 which included some OCX (DynaZip, Imaging and another dedicated to secure payment with visa card). It worked fine under PB 6.5 whatever the OS we were using (95, 98, Me, NT). We've migrated under PB 8.5 and now we get errors trying to access external functions of OCX. With the dynazip OCX, the behaviour is nearly correct but arguments seem to always be passed by value (and no more by reference). With the OCX dedicated to secure payment, we get error accessing external function. With the Imaging OCX, we get error accessing external func...

OCX Web and PB 6.5
Hi PB People: We are using the OCX Web browser for view html files, and we want to send a Word document that is stored in a database to the OCX Web browser, we recovered this document with the sentence SELECTBLOB document FROM DocWord; and we stored the binary object in a BLOB variable. After, we generated a temporary Word file with the data of this variable and show it in the Web browser with the Navigate(url) sentence ole_web.Object.Navigate("C:\temp\document.doc") We want to make the same without having to generate the document temporary, directly sending the informatio...

PB 6.5 crash with Sheridan OCX
I am using Sheridan's SSYear OCX control. It worked fine for me under PowerBuilder 5.004. But in PB 6.5 i get a GPF in PBVM60.DLL if I click between days too quickly. I've tried moving the click event's code to a user event and I've tried allocating space for the strings that the ole_calendar uses before their usage with no luck. My OLE DLLs are later than what is recommended. Any ideas? Thanks. I had (actually, I still have) problems with OCX controls and PB 6.5 executables too (see discussion: "PB 6.5 OCX Crashes in EXE") and someone recommended ...

How to use .ocx files in pb 6.5
Hi all, I'm kinda newbie and I have to attacht this bar-code scanner to my powerbuilder application. With mscomm32.ocx this has to work, but HOW? Can anyone PLEASE!!! help me!!??! Thnx in advance, Jona jona@home.nl Open a window and then from the window toolbar select 'OLE ' from the visual components list. This will open a dialog box. Go to third tab 'Insert Control' and selected your required ocx. If its not already registered then register it by the button 'Register New' Hope it helps Suhail Sarwar ...

Internet Explorer OCX in PB 6.5
Hi all, just started testing to use OLE objects in PB 6.5 trying to build an browser using Microsoft WebBrowser Object. When doing this in Visual Basic I have no problem accessing properties or functions of this control but when trying to do the simplest task of them all in PB I'm failing on ex. "Unknown function name: navigate". When using objectBrowser looking at the objects properties/functions and so on in PB it lists the functionname "navigate". I found an example on how to work with IE in PB 7. But I don't have this version of PB thats why I'm ask...

PB 6.5 OCX Crashes in EXE
I have build an application in Powerbuilder 6.5 that uses 2 OCX controls. One of them is the GanttOCX from AddSoft, the other one is home-made. Both OCX controls are working fine when running the appliction from within the PB 6.5 development environment, but if I run the executable and try to open the windows containing the controls the executable is crashing and causing a Access Violation. This happens with both the controls. Some Additional information: The OCX controls are created as a visual ole user object and this ole user object is placed on a window. If you have any ideas...

Newbie Question : OCX & pb 6.5
Hi all, I've just finish my first ActiveX Component (a simple toolbar), with vb 6.0, but it seems that I've missed something... I can "import" my ocx in pb 6.5, I can run the application etc... but... I can't call ocx's methods and properties... Here is my piece of code : ole_toolbar is my ocx....(hu... the OLE container) ole_toolbar.AddItem("Some texte for the caption of the item") or ole_toolbar.BkColor = RGB(some values...) pb doesn't recognize AddItem function and BkColor Property... Why...? thx you, Cedric Menec Try: ol...

OCX (visual control) creation in PB 6.5 ?
What is the way to create dynamicly an OLE Control for a visual V.B. 6.0 OCX (through PB scripting)? Why doesn't my OCX react to event pbm_keydown, ... What should be done ? Best regards, Michel Goetz mailto:michel.goetz@pandora.be ...

Need help in using ocx in PB 6.5
Hi all, I'm new in using OCX in PB, so I need someone to help me. I need to do an interface to allow my PB app to call into a VB app. I created an OCX using VB. I've added a OLE object (with my OCX) to my PB app. How do I call the function inside the OCX, can someone help me? Thanks. ...

Informix + PB 6.5: which I-Net for PB 6.5?
Hi, I want to migrate our PB4/ PB 5.01 16 bit Informix applications to 32bit. Which version of CLI/I-Connect and which PB 6.5 build do you recomend me? We are using 7.13 and 7.30 OnLine. TIA Pepa PS. I need ISO 8859.2 <-> ISO latin 2 (1250) conversion. We use the latest INFORMIX-Connect v 7.2 drivers for our PB 6.5 apps. These drivers are available for free download (actually INFORMIX-Client SDK, of which INFORMIX-Connect is the runtime component) from the Informix website ...

What to upgrade my PB 6.5 to PB 6.5.1 ?
What to upgrade my PB 6.5 to PB 6.5.1 ? What file I can download and Where is this file ? thanks http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001286 On Thu, 5 Aug 1999 23:03:18 +0800, in powersoft.public.powerbuilder.database Netvigator <kevinlcw@ctimail.com> wrote: >What to upgrade my PB 6.5 to PB 6.5.1 ? What file I can download and Where >is this file ? > >thanks > > --- Bruce Armstrong [TeamSybase] | Romac/Source International mailto:Bruce.Armstrong@teamsybase.com | mailto:jobs@sourcela.com ...

ocx for displaying jpeg and gif images in pb 6.5
Does anyone know of an ocx that will display jpeg and gifs in pb 6.5 Mark, if you have WIN98 or NT, look for imgedit32.ocx in System32 folder. Larry "Mark" <mpellegrino@crunchtime.com> wrote in message news:uLWb3A0ODHA.187@forums-2-dub... > Does anyone know of an ocx that will display jpeg and gifs in pb 6.5 > > > You can try my jpegviewer for PB6 - not fancy, but works... http://www.teamsybase.com/roy.kiesler/downloads/jpegview.zip ...

What to upgrade my PB 6.5 to PB 6.5.1 ?
What to upgrade my PB 6.5 to PB 6.5.1 ? Where I can donwload the upgrade pack ? thanks Go to http://support.sybase.com select Software Distribution, log on, select Powerbuilder and then pick PB 6.5.1 maintenance patch. Harpreet Netvigator wrote in message ... >What to upgrade my PB 6.5 to PB 6.5.1 ? Where I can donwload the upgrade >pack ? > >thanks > > Go to Sybase Developers Network (http://www.sybase.com/sdn) and look for the patches link. Good luck, Terry [TeamSybase] and Sequel the techno-kitten On Thu, 5 Aug 1999 23:02:22 +0800, &quo...

Web resources about - PB 6.5 , OLAP and OCX - sybase.ole-ocx-activex

OLAP cube - Wikipedia, the free encyclopedia
A cube can be considered a multi-dimensional generalization of a two- or three-dimensional spreadsheet . For example, a company might wish to ...

Kyvos Debuts OLAP for Hadoop
Many technology pros view OLAP as a legacy technology, a holdover from the days of data warehousing that doesn't have a place in today's big ...

Ask HS: What is a good OLAP database choice with node.js?
... database with all the data necessary to do financial analysis. My associate is a Business Intelligence specialist so he is keen to use OLAPs ...

OLAP information, news, and how-to advice - InfoWorld
OLAP news, information, and how-to advice

Ask Slashdot: Changing Career From OLTP To OLAP Dev
... submitter xby2_arch writes "After spending over 12 years writing OLTP applications (Java EE/JDBC/ORMs), I decided to dabble in the OLAP world. ...

OLAP and the need for SPEED
... we're looking at the myths and legends of the database world; some turn out to be true, others false. This myth is about why we use OLAP. If ...

iTnews - For Australian Business - iTnews.com.au The Third Way - iTnews Australia
... the lead time of the design to delivery cycle. For years now, CIOs and IT specialists have been discussing the pros and cons of OLTP v OLAP. ...

Global trends in deploying PostgreSQL
This year’s conference lineup led me all over the world, a giant rectangle triangle going from the west coast of the US, north to Canada, east ...

AnandTech - Opteron
Eight improved cores, 16 threads, integrated 40 lane PCIe 3.0: the new socket 2011 Xeon E5-2660 manages to package it all in a very modest power ...

Price Drop: Glimpse
... logarithmic and inverted axis scales• Direct connections to Oracle, SQL Server, and MySQL databases• Connections to multi-dimensional OLAP data ...

Resources last updated: 12/21/2015 10:02:04 AM