Re: ADOX - Access table creation with nullable columns.




"Andy" <Andy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C7C7AC4C-53C0-47FB-BA07-E578F4F29AAA@xxxxxxxxxxxxxxxx
Yep, that code was my starting point!. See first post that opened the
thread.
Repeated here for clarity :-

.....
m_pCol1.CreateInstance(__uuidof(ADOX::Column));
m_pCol1->Name = "Column 1";
m_pCol1->Type = ADOX::adVarWChar;
m_pCol1->DefinedSize = 24;
m_pCol1->Attributes = ADOX::adColNullable; \\Does this work?

m_pTable->Columns->Append(m_pCol1->Name, ADOX::adVarWChar, 24);
.....


Yeah, I see it NOW, like a bonfire.
[I consider myself a C programmer, but after too many years with VB and
dotNet, I'm not sure I could format a printf statement.]

So what's the question now? I thought the problem was because you were
getting errors trying to use a "Properties Collection" which doesn't support
what you were after. What else is blazing around me that I'm oblivious to.
<g>

-ralph


.



Relevant Pages

  • Re: One thing I noticed
    ... applications for the adverage programmer. ... error handling, almost mindless controls, straight-forward data handling, ... and splice 'n dice with perhaps the simplest syntax possible. ... It may have similar syntax, but it pure dotNet, no ...
    (microsoft.public.vb.general.discussion)
  • Re: SOA and "White box" code reuse...
    ... >Standards make communicating easy. ... >A typical academic programmer will say 'roll your own'. ... >You sound like a dedicated linux programmer. ... Oh yeah, and also Linux. ...
    (sci.electronics.design)
  • Re: Pig Roast Invite
    ... >>>Everything sounded good until the 18 hour bonfire on top of the pig. ... >> Yeah a few of us mentioned that as th' bonfire was lit off. ... Snarl AH#67 BS#37 SENS ...
    (rec.motorcycles.harley)
  • Re: How to write fixed length records to file.
    ... Yeah, I thought of that after I hit the Send button.... ... I simply can't imagine ANY programmer would write a file like that ... start of the second group. ... I'd suggest you look hi and low for an indication of how the ...
    (microsoft.public.vb.general.discussion)
  • Re: Women Hate Equality (part 2).
    ... On Jul 31, 3:53 pm, John Larkin ... I thought you were a programmer or something. ... Yeah, the year 2000 bug was the easier way to cash in on people's ...
    (soc.men)