Oh it is ok. I am sorry I did not know that you were busy.Any way Thank you very much for letting me know that and when ever you will find a time you can give me a Reply.
Thanks a million.
srinivas gandrath
Last Activity: Nov 20 '08, 02:40 AM
Joined: Nov 13 '08
Location:
-
Hi Delerna,
I can upload the pdf file directly from the java application with out using the stored procedure.(usin g prepared statement in java)
But the problem here is I can not get the identity column value to my application which I need to return it to another application.
And one more thing when I tried to execute the sp's through my application I am only getting the out parameter incremented but the...Leave a comment:
-
[QUOTE=Delerna]Ditto to what ck said.
Hi Delerna,
Thanks for your reply. Here I am doing some think like you said before.Please check the code I have writen.
# create proc Update2Tables
# @Action varchar(50),
# @Doc int OUTPUT,
# @Dte datetime,
# @FileName varchar(50),
# @DispName varchar(50),
# ...Leave a comment:
-
Hi Delerna,
I just confirmed with my team lead that we should make use of the stored procedure,Becau se the font end we are using is JAVA right now.We are just creating a helper class in java(which make use of these sp's in the database and call them) and giving it to the other vendor who can actually make use of that code.In the future if the client want to implement this service class with another .NET or some other language they...Leave a comment:
-
Hi Delerna,
If I do not use the stored procedure, I need to update these tables through my application right?
If so I need to join these 2 tables and do the insert/update from my application.
Can you send me sql query to join these 2 tables. Like I mentioned more than one state can have the same benefit details.
How can I do it? through join or any other way?
Please help ...Leave a comment:
-
inserting/updating multiple tables through stored procedures
Hi all,
I am having trouble to writing stored procedure to insert and update the 2 tables in sql server 2005. Here is my problem.
I have 2 tables with following columns.
TableName:BENEF IT_PDF
1)DOCUMENT_CK
2)EFFECTIVE_DAT E
3)PDF_FILE_NAME
4)PDF_DISPLAY_N AME
5)PDF_IMAGE
another TableName: PLAN_PDF
1)DOCUMENT_CK
2)PLAN_ID
3)STATE
...
No activity results to display
Leave a comment: