pls pls pls help me out!!!!!!!!! Append new field in the existing table using ADO.

Hi everybody,

I want to append new Column 'firstname1' into the existing table say
"geo" its already having 2 columns name 'salcode', and 'salary'.I used
following code its run perfectly without any error but when I opened
the database its not having new column?
Is this not work.



/* _bstr_t name("firstname1");
FieldsPtr fields;
FieldPtr field;*/

//pRstTitles->get_Fields(&fields);

/* pRstTitles->Fields->Append(name, adVarChar , 15,
adFldUnspecified);
pRstTitles->CursorLocation = adUseClient ;
pRstTitles->LockType = adLockOptimistic ;
pRstTitles->Open("geo",
_variant_t((IDispatch *)pConnection,true), adOpenStatic,
adLockOptimistic, adCmdTable);*/


Thanks in Advance Guys..
Pls pls pls pls pls help me out!!!!!!!!!!
I need it very urgently

.

Relevant Pages

  • Re: Parameter dialog box pops up
    ... > I need to update my Access database from an Excel list. ... The question is how do I append each field from ... > append query for each table from my TableN and run them separately). ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: form to email document
    ... >> append the Session ID for that user Session to the file name. ... >> name uploaded.This can come from a simple text file or a database. ... >>> I was hoping for something like the procedure used to upload a form, ...
    (microsoft.public.frontpage.programming)
  • Re: Populating Databse
    ... that wasn't an Access database for sure! ... Same with SSN and so on. ... you can use the Append query; ... to append some clearly unreasonable date into the datefield (which you ...
    (microsoft.public.access.tablesdbdesign)
  • Re: [OT] PostgreSQL: bytea help needed.
    ... >> Well, you draw the data in, and then append it to the field. ... > the database from my local filesystem for example. ... > Well I wanted to grab binary data off my filesystem directly from the ... > COPY command which is used to pull text data in. ...
    (comp.os.linux.misc)
  • Re: Possible Project Bug: All Projects in Database are Deleted upon Save
    ... prompts with Append or overwrite message. ... best practices and Project VBA ... > DELETION of the current database. ... I understand that there is an option with the DisplayAlerts ...
    (microsoft.public.project.vba)