|
i am developing a project with VB6 and Firebird 2.1.3. When i update the table tblPartyMaster and examines the adoRsParty!PartyID which is a primary key,autoincrement, unique identifier returns 0 (Zero) instead of New PartyID Value which i need for further processing.
With adoRsParty
.AddNew
!CompanyName="Sample Company"
.Update
msgbox !PartyID
End With
I have create a Generator for PartyID
and a Before Insert Trigger on table tblpartyMaster as
CREATE TRIGGER TR_AI_TBLPARTYMASTER_PARTYID FOR TBLPARTYMASTER
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
NEW.PARTYID = GEN_ID(GEN_TBLPARTYMASTER_PARTYID, 1);
END
Please Suggest me some ideas for fetching the PrimaryKey (PartyID) Value of newly inserted row.
Expecting some advice or ideas or guidance
With regards
K.Senthil Babu
|
|
|
|
|
You can use a storedprocedure, I think trigger is not convenient. Just use an Output parama in your code. If you face any problem please let me know.
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
From my Delphi and Interbase days I remember that the methodology the OP is using (before insert trigger and GEN_ID) is the recommended way of doing things.
Unfortunately I have never tried to access Interbase/FireBird from VB and therefore am unable to help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Thanks Md. Marufuzzaman,
I Created a procedure instead of Trigger along with the generator and called the procedure from the front end for autonumber, it works fine.
Thanks A Lot.
|
|
|
|
|
You are most welcome.. 
Thanks
Md. Marufuzzaman
I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.
|
|
|
|
|
Explain reading contents and writing contents from a file using APS object stream.
|
|
|
|
|
You have posted four homework questions which demonstrate a lack of enthusiasm (on your part) to do the minimum amount of work set by your professor/teacher. If you really cannot understand these questions you should discuss your future with your teacher.
It's time for a new signature.
|
|
|
|
|
Or concentrate on his maths, he will need to make sure he puts the right number of McNuggets in the box.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
iam taking this question but im not able to solved it from a past few months .. its my urgent need because my exams are near ..not intended for lacking enthusiasm..if so then i wont try on here in this community bcause waiting the reply n the reply is like that..is more than homework.
|
|
|
|
|
twinkle1 wrote: its my urgent need because my exams are near
As you say "your exams" not ours. Why should other people do your work so that you can pass exams, as your qualification will be worthless. If you don't understand the question then maybe you are on the wrong course.
It's time for a new signature.
|
|
|
|
|
Stop posting your homework questions.
We do not do homework, we help people who are stuck with specific problems.
You will not pass the course if we do the work, so if you want to be a developer you must knuckle down and do the work yourself.
If, having tried and run into a specific problem, then post, and people will be pleased to help, that's how it works.
But to just say 'Here is my homework, do it for me' indicates you are not going to learn, you are not interested in passing the course and that programming is not for you.
Have you even bothered to attempt the answers?
Now either try to do your own work, or consider a change of career, something clerical perhaps, of something manual, like gardening.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
Write a program for sorting of all student records in a class according to roll no. using ADO and corresponding database.
|
|
|
|
|
No. You write it.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
why u post me reply..if u not interested in writing the answer..iam taking this question as im not able to solved it from a past few months .. for nt listening urs joke here... its my need because my exams are near ..hope u lock it for further !!!
|
|
|
|
|
You didn't ask a questiont hat could be answered. All you did was copy and post your homework assignment. Noone here is going to write it for you, period. You won't learn anything and you definitely are not going to pass your exams if someone else writes it for you.
If you've got specific questions on what you're having trouble with, great. Post them with all the relevant details and code you've written. If you're looking for someone to do your work for you, you've come to the wrong site.
|
|
|
|
|
Why should I do your homework for you?
twinkle1 wrote: its my need because my exams are near
Well, what a suprise. How long have you known when your exams are? Anyway, if I write it for you (its a pretty trivial program after all) can I have your degree and wages for the next few years, because I will have earned them, you won't.
Anyway, at least I hope you fail your exams as then I won't have to worry about fixing your crap over the next few years.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
dont reply ..if u wont solved it.
|
|
|
|
|
Well don't post your crappy homework here then. Have a go yourself and come back with specific problems, not demands to do your work for you, you lazy tyke.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
A program.
There, I did what you asked. Now you just have to add functionality for sorting.
Have a nice day.
|
|
|
|
|
Write a program to display configuration of a local system with the help of VB script.
|
|
|
|
|
Write a program to display the system specifications of client system with the help of VB script.
|
|
|
|
|
You forgot the exclamation mark, "plz" and "urgentz".
Cheers
I don't like signatures
|
|
|
|
|
|
Is that what you have been asked to do?
If so, you should go and do it, otherwise you will never pass your course.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
|
|
|
|
|
ok..but i dont know y u bother abt me..if so then y nt u help out..i had tried it well but nt able to solved ,so iam asking...thanks for ur lecture..but this is nt the lecture community..if u knw my answer u can reply..otherwise there is no preesure to do so.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
