Forum Discussion

Salvatore_Pirre's avatar
Salvatore_Pirre
Occasional Contributor
16 years ago

Datasink to MS SQL Server

Hey guys,

question regarding datasink to Ms SQL Server. When I run my Test case it writes the datasink to the next row in the db table instead of the same row from the datasource grab. it's probably something simple but can someone give me a hand?

thanks..
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Hi,

    looks like you need to add a where clause to select the correct row for updating;

    update Ping(DateTime) values(?) where RCID = ?

    and then add an RCID property which gets its value from the datasource.. does that help?

    regards!

    /Ole
    eviware.com