Phantom records in select statement w/RDO 
Author Message
 Phantom records in select statement w/RDO

I am using a Remote Data Control to connect to an Interbase 4.2
database with VB5 using ODBC.  The select statement for this control
is very simply "select * from [table]".  All records from the table
are returned with several blank or phantom records at the end.
Upon inspection of the table with the database browser supplied by
interbase, these records are not present.  

This is the first time I have tried to access Interbase from VB5.

Any ideas what's occuring??

Thanks...
==================================================

  Lee Nigh
  Software Engineer
  Lucent Technologies, Inc.

  Remove 'NOSPAM' from my address before sending.

==================================================



Tue, 12 Sep 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to select the current record only with SELECT statement

2. running sql code record by record instead of statement by statement

3. Counting records returned by SQL Select statement

4. SELECT Statement returns no records....

5. Need help with Select statement syntax to retrieve Access2000 record between two dates

6. Need help with Select statement syntax to retrieve Access2000 record between two dates

7. Exclude a record in a Select Statement

8. Locking a record with a SELECT SQL statement

9. vb Select * from tableA?How to select record from 1000 to 2500

10. Cetting A Report To Select Records Based Upon A Value Selected In A Combo Box

11. vb Select * from tableA?How to select record from 1000 to 2500

12. selecting items in a Data bound list and passing a field content for the selected record

 

 
Powered by phpBB® Forum Software