You can convert to a LONG and see how it goes.

LONG(pSqlRet)

Jamal

<r>Hi Gerard,<br/> <br/> Those are PTR values. The VO documentation is wrong to say EnvHandle is of LONG data type.<br/> <br/> Internally the SQL class has a hidden variable:<br/> <CODE><s>[code]</s> HIDDEN hEnv AS PTR<e>[/code]</e></CODE> and declares:<br/> <CODE><s>[code]</s>ACCESS EnvHandle CLASS...

Hello Jan,

FWIW, you may have your reasons to use MSXML2 since you are using X#, why not use System.Xml namespace and classes?
They are well documented and built in the NET framework

Jamal

<r>Hello Gerard,<br/> <br/> I don't use ReportPro with SQL, but the following may trigger some thoughts on your end <E>:)</E><br/> <br/> I think it is a good idea to check if the connection is the connection is successful first before calling other methods,<br/> <br/> i.e. <br/> <CODE><s>[code]</s><...

Robert,

Are you sure about the # of Fields: 255 ?

I have a DBF file with 336 fields.

Jamal

<r>Karl,<br/> <br/> I have better luck with MP4 files.<br/> <br/> Jamal<br/> <QUOTE author="Karl-Heinz"><s>[quote="Karl-Heinz"]</s>Mmmh, it seems the forum software doesn´t like the GIF extension, because both files have now the PNG extension ?<br/> <br/> anyway, i´ ll put the animated GIFs in a zip...

Alf,

How about also , in addition to SetDefault(), calling SetPath() to point to the same folder?

Jamal

<t>Alf,<br/> <br/> I suggest you check if the DBF alias or dbServer is the correct one that you are doing the FIELDGET() on.<br/> <br/> One way to find out is to override the FIELDGET method and trap the error to return the Alias; that way you can tell for sure what alias or workarea is being used, ...

<r>Joe,<br/> <br/> <B><s>[b]</s>It works for me! Take a look at the attached sample AEF.<e>[/b]</e></B> <ATTACHMENT filename="CloseWindowTestApp.AEF" index="1"><s>[attachment=1]</s>CloseWindowTestApp.AEF<e>[/attachment]</e></ATTACHMENT> <ATTACHMENT filename="2022-01-11_15-35-02.mp4" index="0"><s>[at...

<r>Joe,<br/> <br/> VO calls the QueryClose method. See the Windows Properties dialog, then click the dotted button to generate the QueryClose event call such as:<br/> <CODE><s>[code]</s><i> </i>method QueryClose(oEvent) class YourWindow local lAllowClose as logic lAllowClose := super:QueryClose(oEve...