Is PBForms.inc not compatible with ADO?

[Dominic Mitchell]

I decided to try the file the PB COM browser would produce, but for some odd reason the browser
does not seem to like my system. It lists the registered versions of the type library, but
displays "Libray not present" in the Location field.
It's the only browser of the many in my arsenal that behaves like this.

Well, I can use the "Open Library File" command, but there is no way I am going to let this browser
monkey around with my type libraries.

The Microsoft ActiveX Data Objects library is a rather interesting library when it comes to the
resolving of external references, but I digress.

[Alexander Holzer]

DATA is used to declare string constants within the source code to be read by READ$ function.
Example: DATA "Abc", Bob, "Sally", 123
Read the help file.
Apparently, the compiler is being confused when used as a parameter name.

If PowerBasic reserves this word, it must think if such case comes.
My recommendation:
- change in the COM Browser ".. DATA string.." on " .. xDATA string..", if such entries would happen.
Otherwise one must everyone times examine Work of COM Browser.
COM Browser is also development of the PB.

[Alexander Holzer]

I have this error with WinXP Pro & Home, SP2.
PBWin 8.04.0042

[José Roca]

I have tested it with version 8.04, but you have to use the particular MSADO27.INC file that Alexander is using.

[Dominic Mitchell]

Which version of the compiler is this? I am not getting any errors on my system(PB/WIN 8.04).

[José Roca]

DATA is used to declare string constants within the source code to be read by READ$ function.
Example: DATA "Abc", Bob, "Sally", 123
Read the help file.
Apparently, the compiler is being confused when used as a parameter name.

[Alexander Holzer]

But PBForms use this "word" DATA also...
Why does it make this? if it admits is

[José Roca]

It is not a PBForms problem. Is a problem of using the reserved word Data as the name of a parameter when there are more parameters after it.

[Alexander Holzer]

Thanks José Roca!
It works!

..but I think, to use PBForms further

[Alexander Holzer]

I change my code and shall work without PBForms

[Alexander Holzer]

Hi Alexander,

Do you have understood what I have said in my previous post?

Just change Data to xData in the following line of MSADO27.INC:

    Member Call WriteText<&H00000014>(in [B]Data[/B] As String<&H00000000>, optional in Options As enumADODBStreamWriteEnum<&H00000001>)

OK, I make...

Is this MEMBER CALL WriteText continues to function?

[José Roca]

Hi Alexander,

Do you have understood what I have said in my previous post?

Just change Data to xData in the following line of MSADO27.INC:

    Member Call WriteText<&H00000014>(in [B]Data[/B] As String<&H00000000>, optional in Options As enumADODBStreamWriteEnum<&H00000001>)

[Alexander Holzer]

Thanks José Roca,
but unfortunately this library is necessary to me.

While I don't use PBForms more.., but it is a pity

[StanHelton]

Thank you Jose

PB doesn't natively support visual ActiveX controls because these need an OLE container. But ADO is not a visual ActiveX.

thanks for that clarification. now I will reread the thread hopefully with understanding.

[Alexander Holzer]

You can not modify PBMain() ?

1. read that

2. For what did I buy then this program (PBForms)???
...if I must correct thereafter everything

[José Roca]

The problem is in this line in MSADO27.INC:

    Member Call WriteText<&H00000014>(in Data As String<&H00000000>, optional in Options As enumADODBStreamWriteEnum<&H00000001>)

Apparently the use of the Data keyword as the name of the parameter is causing havoc. Change it to:

    Member Call WriteText<&H00000014>(in [B]xData[/B] As String<&H00000000>, optional in Options As enumADODBStreamWriteEnum<&H00000001>)

According to my documentation PB doesn't support ActiveX controls yet the discussion here seems to assume that it does. Did I miss something?

PB doesn't natively support visual ActiveX controls because these need an OLE container. But ADO is not a visual ActiveX.

[StanHelton]

Read the thread now I'm cofused

MSADO27.INC to be created with PowerBasic COM-Browser from ActiveX Data Objects 2.7 Type Library (msado27.tlb).
But I need this library.

According to my documentation PB doesn't support ActiveX controls yet the discussion here seems to assume that it does. Did I miss something?

[Edwin Knoppert]

You can not modify PBMain() ?

[Alexander Holzer]

No, no...
How with it: PBFormsMakeFont, PBFormsRichEdit ???

And next time PBForms will all change back again...

[Edwin Knoppert]

If i remove the macrotemp's it works.

Though it's not 'allowed' to modify this pbforms.inc