Problem with SDAC Query component used along with ClientDataSet
Posted: Thu 03 May 2007 10:13
Hi,
I am using SDAC 3.80 liecensed version of components in one of my migration projects.
I am having following coponents on my form - ClientDataSet, Provider, DataSource and query component attached to each other. I also have a Db Grid, and the data source of the DB grid is the data source component which i have on the form.
Now on Click of a button i am setting the ClientDataset's Active property to True. Now i am trying to add a new row to the dataset. At this time i am filling some fields of the new row so that user dont need to enter them. But i am not filling all the mandatory fields. But without filling all the mandatory fields i am trying to append the ClientDataSet and trying to add another row as it is necessary.
I am not filling all the mandatory fields as i am expecting the end user to fill them.
Now the problem is when i am trying to Append the clientDataSet for adding the Second row SDAC components do a Post which is Causing an error. The reason for the error is all the mandatory fields required for doing post are not filled.
Now can i have solution for this. Can i stop SDAC's components from doing post during appending the DataSet?
Regards
I am using SDAC 3.80 liecensed version of components in one of my migration projects.
I am having following coponents on my form - ClientDataSet, Provider, DataSource and query component attached to each other. I also have a Db Grid, and the data source of the DB grid is the data source component which i have on the form.
Now on Click of a button i am setting the ClientDataset's Active property to True. Now i am trying to add a new row to the dataset. At this time i am filling some fields of the new row so that user dont need to enter them. But i am not filling all the mandatory fields. But without filling all the mandatory fields i am trying to append the ClientDataSet and trying to add another row as it is necessary.
I am not filling all the mandatory fields as i am expecting the end user to fill them.
Now the problem is when i am trying to Append the clientDataSet for adding the Second row SDAC components do a Post which is Causing an error. The reason for the error is all the mandatory fields required for doing post are not filled.
Now can i have solution for this. Can i stop SDAC's components from doing post during appending the DataSet?
Regards