Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple rows with singleton select
Thank you for taking the time to reply. I have solved the problem. It was in my algorithm. I was checking for a duplicate, whereas the SQL call which checks for many fields, actually did find multiple rows. I had to change the params to compare. It was now.- debbee
- Post #5
- Forum: Embarcadero: Delphi
-
Multiple rows with singleton select
Thank you for answering. I am using Database Desktop that comes with Delphi installation. Paradox I think. No, I am not joining tables. Just reading data and adding into the same table, screening through duplicate session numbers first. Yes, I made sure there are no duplications in the...- debbee
- Post #3
- Forum: Embarcadero: Delphi
-
Multiple rows with singleton select
I am using Borland's Delphi working with a simple database structure. Basic structure is 1. Name table, including a MasterID, which increments with each entry. 2. Session table, with session number, Session ID which increments with each entry, and a MasterID field that links to MasterID in...- debbee
- Thread
- Replies: 4
- Forum: Embarcadero: Delphi
