Forum Discussion

Ram_N's avatar
Ram_N
Contributor
17 years ago

DataSink - Inserting to external DB -- how to ??

Hi

I am trying to write to Databse ( sql Servicer 2005 )

Datasink has two properties  apcode, apcity.

I want to write these two properties into Database table ( apupdate)... how do I do ?

I wrote like this:  insert into apupdate values(apcode = ?, apcity = ?)

which did not work... could please help me....  again... this is also for Demo I am presenting...

1 Reply

  • omatzura's avatar
    omatzura
    Super Contributor
    Hi!

    what error did you get with this? You probably need to surround the question-marks with single quotes, ie

    insert into apupdate values(apcode = '?', apcity = '?')

    Maybe that helps!?

    regards,

    /Ole
    eviware.com