Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Fields not included in Sql collection |
Fri, Nov 16 2007 8:13 AM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 AM | Permanent 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 |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |