Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Fields not included in Sql collection
Fri, Nov 16 2007 8:13 AMPermanent Link

Malcolm Fowler
Hi,
I wonder if you can help me please. I have a SQL in a VB6 program that joins 4 tables. The SQL runs through fine, at least no errors are displayed.
When I try and display the resulting recordset with debug.print the field from one file is not present, I receive the error "Runtime error '3265' Item
noy found in this collection".
The table in question is not one that comes with the software I am evaluating but one that I have created using the EMS DBISAM Manager software,
so I suspect that something is not quite right but I can't see it. The table is very simple, 2 fields call Field1 & Field2 18 & 9 character respectively,
and contains about 14000 records.
This problem occurs if I try to read from only this table also, which is why I think the table is at fault.
I have attached the table for you to look at and would appreciate any help you can offer. The primary key is Field1

Regards
Malcolm



Attachments: CstPrc.dat
Fri, Nov 16 2007 5:33 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Malcolm,

<< I wonder if you can help me please. I have a SQL in a VB6 program that
joins 4 tables. The SQL runs through fine, at least no errors are displayed.
When I try and display the resulting recordset with debug.print the field
from one file is not present, I receive the error "Runtime error '3265' Item
noy found in this collection". >>

I can't open that table here using the DBSYS utility - it reports that the
table header is corrupted.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Nov 23 2007 8:52 AMPermanent Link

Malcolm fFowler
Hi Tim
Sorry its taken so long to get back to you.
I went back to the people who converted the database for me and they agreed, no wonder I was pulling my hair out. I now have a fresh converted
database and all appears to be ok.

Many thanks for you time and effort, very much appreciated.
Malcolm


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Malcolm,

<< I wonder if you can help me please. I have a SQL in a VB6 program that
joins 4 tables. The SQL runs through fine, at least no errors are displayed.
When I try and display the resulting recordset with debug.print the field
from one file is not present, I receive the error "Runtime error '3265' Item
noy found in this collection". >>

I can't open that table here using the DBSYS utility - it reports that the
table header is corrupted.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image