Board index Database Programming

CRecordset skipping INSERT of one field

CRecordset skipping INSERT of one field

Post by Gary Newm » Sun, 30 Mar 1997 04:00:00



[ Article crossposted from microsoft.public.vb.database.odbc ]
[ Author was  ]
[ Posted on 28 Mar 1997 03:01:23 GMT ]

: I've got a CRecordset derived class that does just fine
: at inserting all the fields of the set except one.

It appears to be a bug in the Microsoft CRecordset class.
If I put the assignment of any of the database field members
in a separate simple assignment statement it works just fine.
However if I put the assignment in a more complex statement
it fails.

This works:
        m_myDBFieldMember = AnyThingHere;
This fails:
        for(i=0, m_myDBFieldMember=0; i < N; i++)
                m_myDBFieldMember |= array[i];
--

--

115 North Branch Rd.                    voice: (508) 369-4207
Concord, MA 01742                       Fax:   (508) 369-8109

 
 
 
Top

1. insert data from one field in one table to another field in another table

I have 8500 records in a table called items which has a
field called itemlookupcode.
I have another table called alias which has a field called
alias.
I need to replace the itemlookupcode data with the alias
data.
There is a join between the 2 tables on ID
Does anybody know how this is done Please

2. Newbie looking for suggestions:

3. One Field Value Skipped

4. soundex function

5. How to insert a row which has IDENTITY field using VC++4.0 CRecordset class

6. RAID Disks, Progress, RS6000

7. Insert rows with Identity field using VC++ 4.0 CRecordset class [sql.txt] (1/1)

8. A Special Offer!

9. Insert many fields in one field

10. Using CRecordset::AddNew() and CRecordset::Edit() with IDENTITY fields

11. How to insert fields from one table to another

12. inserting field into a new table from an old one :)


All times are UTC
Board index