|
HI
I have Master Table and Child Table. Master table had identity column on inserting record to Master table capture the identity id and inserting in to child table. This is happening in a stored procedure.Now problem is if I call the same procedure for multiple times. It should update only one Identity value to all the multiple records. When called the stored procedure. Check for existence of previously inserted id and not insert any records to Master table and same Id should be inserted to child table. So, How do I handle this.
|
|
|
|
|
This forum is for questions about writing articles to be published on the CodeProject site.
I suggest you post your question in the "Quick Answers" section[^]. However, you'll need to provide much more detail, including the definition of the stored procedure, and the code that calls it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Did ... the author fix one themselves? I think an editor got the other one
Thanks,
Sean Ewington
CodeProject
|
|
|
|
|
thanks
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Hello Editors,
I am composing an article, which to my utter surprised is published
[^]
I am still composing the article and i have no clue how it has got published???
Please unpublish this article till I am done with my article. Else it gives no meaning at this stage with the theme and current state.
Please help me.
|
|
|
|
|
I think you should be able to do it yourself. Edit the article and change the status (top right) to "Composing".
|
|
|
|
|
|
Because it was published I've changed the status to "InReview." This means only the people with the URL can see it.
Thanks,
Sean Ewington
CodeProject
|
|
|
|
|
@Sean-ewington can you have a look here[^] please?
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I made it better
Thanks,
Sean Ewington
CodeProject
|
|
|
|
|
thanks
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
@Sean-Ewington please have a look this blog[^]
Blogs are always a bit tricky for me... since it is quite grey zone regarding "spam / site driving"
I think the big button "download here" in Iframe (that btw is failing...) is a bit too much for me.
As I am not sure I opted for posting here instead of doing it in S&A
If allowed... then it needs help
If not allowed, you can handle it
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
What a mess. I would say that we would ideally remove the download button because it doesn't adhere to our article template. I've removed it in this case and done a little tidying.
Thanks,
Sean Ewington
CodeProject
|
|
|
|
|
Thanks
I have written him a message asking him to be careful in the future.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Quote: Dear Ravi,
I want to add Google Translate facility on my PHP application
How?, Can you give me the source code?
, Please ..
Thank you for your attention
|
|
|
|
|
Ravi isn't here right now. He told me to tell you that you can find it under the third rock on the right; the one beside the garden gnome.
Godot
This space for rent
|
|
|
|
|
You should ask this question in the article's forum, and not a random forum. It's by pure chance that I came across your question - this is my first (and likely last!) visit to the Article Writing forum.
Anyway, although the solution I've provided is written in C#, I see no reason why it couldn't be translated to PHP. Sorry, but I can't provide more guidance as my knowledge of PHP is minimal.
/ravi
|
|
|
|
|
When we submit an article or tips, how is it reviewed before it is finally published publicly. Is it a technical review or only a review of the format and guideline compliance?
|
|
|
|
|
It depends on the reviewer. If you get good reviewers, they generally look to make sure that it fits the site guidelines and that it seeks to address what you say it should address. If they have domain knowledge, they will generally offer practical advice if necessary. If you get a bad reviewer, they will either criticise your submission without really reading it or they will approve it when it needs work done on it.
This space for rent
|
|
|
|
|
Thanks Pete for your quick response. I understand, depending on the kind of reviewer he may choose to ignore it but what is expected from the reviewer? Is he supposed to do a technical review also or it is left to his discretion?
|
|
|
|
|
As I said, it's best if the technical review is done by someone with domain knowledge. So, while I will read through and approve (or not) articles on F#, as an example, I am in now way an F# expert so it's pointless me trying to correct you technically unless there is something that really jumps out at me. If, however, you're writing about something like C# or WPF, then as I have extensive experience in these, I will generally look deeper in the content.
This space for rent
|
|
|
|
|
Article reviews are carried about by any CodeProject member with the required permission levels. It will first be a format/presentation review, and if that is all satisfactory then the reviewer will check it for technical merit.
|
|
|
|
|
Thanks Richard, this answers my query.
modified 23-Jul-16 2:41am.
|
|
|
|
|
The general process of approving is described at "23. Why is there content moderation at the CodeProject?" in the Code Project Article FAQ[^].
Because pending articles are reviewed by different persons, it depends on them what they do. It would be fine if articles are also technical reviewed. I for example will not approve articles where I did not know much about the topic hoping that others with more knowledge can evaluate the technical aspects.
There are actually also members approving articles even without checking for basic requirements like formatting and external images (see the post below).
But in general the author is responsible for being technical correct. He should be familar with the subject and invest some time for research if necessary. If there are technical errors, articles will usually get corresponding comments and may be voted accordingly. So any author would be well advised to be technical correct.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
