how to get row ID

[Marian]

I have found a solution to update and insert rows via webservice (if some
wants I can send him the solution) in sql (after 3 days), but I really can't
figure out how to return inserted row Id (this row is generated in sql)
right after its been inserted. Of course I am returning from sql the id to
webservice. Is there a "standart" way to get this id and refresh form ?

 

[Paresh]

I have found a solution to update and insert rows via webservice (if some
wants I can send him the solution) in sql (after 3 days), but I really can't
figure out how to return inserted row Id (this row is generated in sql)
right after its been inserted. Of course I am returning from sql the id to
webservice. Is there a "standart" way to get this id and refresh form ?

Hi Marian,

I have also done the same way for returning the autogenerated ID from
SQL to the IP form.
I think, this is the right approach. Do let me know your view about
this, if any.


Thanks,
Paresh

 

[Marian]

Hi Paresh,

I think I had a not the correct approach on this problem. I am now able to
receive data from sql and all I had to do is to change the submit
dataconnection to receive dataconnection
to get the Id. Then I have changed in Tools->Submit Options->Perform custom
action using Rules->Add->Add action-> Action Query using a data connection
and I have set Data connection to my former "submit datasource " (now it's
receive datasource )->click ok-> Add Action (for the second time)->Set a
field's value-> Choose the Id field in form and choose Value that you click
Insert field or group go to your datasource and choose dataFields and choose
the return field
I have forgot that now I can't submit the data because something happened
to fields . I am working on it right now