GPF when using todbc

[PeterHarmes]

Hi,

When trying to open a Sage file using todbc i'm getting a GPF when calling pen() command. Here is a cut-down version of the code that i'm using:

Code: Select all  Expand view

oOdbc := TOdbc():New(cDsn, cName, cPass)

   If !oOdbc:lSuccess
      oOdbc:ShowErrorList("ODBC session not successfully initialized, aborting...")
      oOdbc:End()
      retu nil
   Endif
   
   oDbf := oOdbc:Query( "SELECT * FROM " + cTable )
   oDbf:lDateAsStr := .t.
   oDbf:Open()
   oDbf:Complete()

Any ideas why i'm getting the gpf?

Thanks in advance

Pete

[James Bott]

Pete,

I have never used these classes, but I note that the oDBF:open() method is trying to create a DBF. This might fail if the user doesn't have the proper rights.

If that isn't the problem, then I suggest compiling the TDBODBC.PRG and linking it into your program. This way you can put msgInfo()'s into the Open method until you find the exact line that is causing the GPF.

Regards,
James

[PeterHarmes]

I think the problem is due to the number of fields in the table that i'm opening (141 fields) - if i just select the first field, my routine works. So is there a limit to the size of fields in a table?

[James Bott]

Peter,

141 fields shouldn't be a problem. Perhaps there is an unsupported datatype field?

James

[PeterHarmes]

Thats possible i suppose - the trouble is that its hard to find the field types from sage.

[Antonio Linares]

Peter,

Better use ADO. There are many ADO examples in these forums.