Database retrieval: record limitation 1

[HowlinHow]

Hi:

I am trying to execute a query through an ADO connection to an Oracle 9i Database. Two fields are being queried for and placed in a recordset. Everything looks fine until after the 101th record where one field is retrieved but the second field is retrieved as ???????? (question marks). In the database, the second field does have values.

Any ideas for a solution.

Thanks

 

[fredericofonseca]

please show us your code.

If at all possible reduce it to the bare minimum
e.g.
connection
recordset
loop
but in a way that still gives you the error.


Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[HowlinHow]

Here is the code (the second variable TEXT_ID appears as ????? marks after the 100th record)--

sampleQuery = "select SAMPLE_NUMBER,TEXT_ID from sample where (Status = 'C' OR Status = 'I' OR Status = 'P') And M_SITE_CODE = '" & sSite & "' order by SAMPLE_NUMBER desc"

conLIMS --> Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=XXXXXX;Data Source=XXXXX;Extended Properties=""

rsSamples.Open sampleQuery, conLIMS, adOpenStatic, adLockReadOnly

Do While Not rsSamples.EOF
colSample.Add rsSamples!SAMPLE_NUMBER, Trim(rsSamples!TEXT_ID)
rsSamples.MoveNext
Loop

 

[fredericofonseca]

What happens if you try the following

"select sample_number, '=='||SAMPLE_NUMBER||'=='||TEXT_ID||'==' as fieldx from sample where (Status = 'C' OR Status = 'I' OR Status = 'P') And M_SITE_CODE = '" & sSite & "' order by SAMPLE_NUMBER desc"

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com