Click here to Skip to main content
15,910,471 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: parallel ports PinPopular
Dalek Dave25-Apr-10 22:08
professionalDalek Dave25-Apr-10 22:08 
GeneralRe: parallel ports Pin
Simon_Whale25-Apr-10 23:15
Simon_Whale25-Apr-10 23:15 
GeneralRe: parallel ports Pin
Luc Pattyn26-Apr-10 1:14
sitebuilderLuc Pattyn26-Apr-10 1:14 
GeneralRe: parallel ports Pin
Pete O'Hanlon26-Apr-10 1:20
mvePete O'Hanlon26-Apr-10 1:20 
GeneralRe: parallel ports Pin
Dalek Dave26-Apr-10 1:24
professionalDalek Dave26-Apr-10 1:24 
GeneralRe: parallel ports Pin
Pete O'Hanlon26-Apr-10 1:28
mvePete O'Hanlon26-Apr-10 1:28 
GeneralRe: parallel ports Pin
Dalek Dave26-Apr-10 1:29
professionalDalek Dave26-Apr-10 1:29 
QuestionFetch Autonumber from Firebird ? Pin
ksenthilbabu24-Apr-10 4:38
ksenthilbabu24-Apr-10 4:38 
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
AnswerRe: Fetch Autonumber from Firebird ? Pin
Md. Marufuzzaman24-Apr-10 20:44
professionalMd. Marufuzzaman24-Apr-10 20:44 
GeneralRe: Fetch Autonumber from Firebird ? Pin
Henry Minute25-Apr-10 12:23
Henry Minute25-Apr-10 12:23 
GeneralRe: Fetch Autonumber from Firebird ? Pin
ksenthilbabu26-Apr-10 19:59
ksenthilbabu26-Apr-10 19:59 
GeneralRe: Fetch Autonumber from Firebird ? Pin
Md. Marufuzzaman26-Apr-10 23:26
professionalMd. Marufuzzaman26-Apr-10 23:26 
QuestionASP Pin
twinkle124-Apr-10 3:07
twinkle124-Apr-10 3:07 
AnswerRe: ASP Pin
Richard MacCutchan24-Apr-10 3:18
mveRichard MacCutchan24-Apr-10 3:18 
GeneralRe: ASP Pin
Dalek Dave24-Apr-10 3:36
professionalDalek Dave24-Apr-10 3:36 
GeneralRe: ASP Pin
twinkle126-Apr-10 7:22
twinkle126-Apr-10 7:22 
GeneralRe: ASP Pin
Richard MacCutchan26-Apr-10 7:58
mveRichard MacCutchan26-Apr-10 7:58 
AnswerRe: ASP Pin
Dalek Dave24-Apr-10 3:41
professionalDalek Dave24-Apr-10 3:41 
QuestionASP Pin
twinkle124-Apr-10 3:05
twinkle124-Apr-10 3:05 
AnswerRe: ASP Pin
Ashfield25-Apr-10 22:54
Ashfield25-Apr-10 22:54 
GeneralRe: ASP Pin
twinkle126-Apr-10 7:16
twinkle126-Apr-10 7:16 
GeneralRe: ASP Pin
Dave Kreskowiak26-Apr-10 8:01
mveDave Kreskowiak26-Apr-10 8:01 
GeneralRe: ASP Pin
Ashfield26-Apr-10 10:25
Ashfield26-Apr-10 10:25 
GeneralRe: ASP Pin
twinkle126-Apr-10 7:25
twinkle126-Apr-10 7:25 
GeneralRe: ASP Pin
Ashfield26-Apr-10 10:26
Ashfield26-Apr-10 10:26 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.