DataSet problems (None Specified) [Revelation On-Line Wiki]

None Specified, John Henry, Cameron Purdy, DSig (SigSolutions)

Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 13 MAY 1998 06:59:56PM John Henry wrote:

The following routine appears to be returning a partially populated dataset. After returning 6 - 10 rows of correct data, the rest of the rows are returned with the fields null (or with zeroes in numeric fields). There are 1228 rows and the correct number is being returned.

The problem is intermittent as on SOME runs it seems to return the rows correctly.

hXO=XOInstance('GENMAP','ODBC',,,,,'')

hDS=DSInstance('MAP_DEVICE',hXO)

SQLScript=select * FROM DEVICE'

stat=DSSetProperty(hDS,DS_SELECT_SCRIPT$,SQLScript)

IF stat THEN
 stat=DSMethod(hDS,DS_EXECUTE$,'SELECT')
 IF stat THEN
    stat=DSGetProperty(hDS,DS_ROWCOUNT$,RowCnt)
    IF stat THEN	
       stat=DSGetProperty(hDS,DS_RECORD$,TableData,1:@FM:RowCnt)
       IF stat THEN
          FOR I=1 TO 100
             RowData  =FIELD(TableData,@RM,I)
             PrintData=RowData
             CONVERT @FM TO '/' IN PrintData
             stat=Send_Dyn(PrintData)	
          NEXT I
       END
    END
 END
END

I have also tried the DS_ROW$ method with the same results. I am talking to an Access97 database. XO parms are: XO_NOTRANS$, XO_GLOBALSHARE$, XO_LOGINDIALOG$ and XO_RESOLVE$. The database is on a Windows NT server and is used by another application in a multiuser environment. The OI installation is at 3.61 and is running on a Novell 4.xx server.

Any ideas??

TIA

John @ J.C. Henry, Inc.

At 14 MAY 1998 07:28AM Cameron Purdy wrote:

John

You are using a Microsoft 32-bit ODBC driver (perhaps for Access) on Windows '95, correct? The thunking that allows it to work will sometimes return invalid data … your DataSet is a case in point, since after the first few rows it returns just blanks (but does not report an error).

There are several possible solutions:

1) Windows NT officially supports ODBC thunking … Windows 95 does not

2) A 16-bit driver may be available for the database you are connecting to

I do not know if these problems are resolved in Windows '98.

Cameron Purdy

Revelation Software

At 14 MAY 1998 09:32AM John Henry wrote:

Thanks Cameron

John @ J.C. Henry, Inc.

At 15 MAY 1998 09:48AM John Henry wrote:

Cameron,

I ran the program on an NT workstation yesterday and it has the same problem as on Win 95.

We're looking at moving the Access DB to SQL Server.

Thanks again

John Henry

At 17 MAY 1998 11:47PM DSig (SigSolutions) wrote:

John,

If you are moving to SqlServer be sure to use the 16bit drives that were in 6.0. If you don't have or are not sure let me know and I will send the files to you

dsig

David Tod Sigafoos ~ SigSOlutions

[email protected] cis:70302,77 voice:503-639-8080

View this thread on the Works forum...