[firebird-support] Re: stored procedured with insert ... returning
talorigo...@yahoo.co.uk [firebird-support] a écrit : > The table does have a EMPID column defined and if I type the insert statement > and execute it, it does work. eventually use return value named EMPID in the procedure -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Re: in new API
09.06.2018 13:52, Norbert Saint Georges n...@tetrasys.eu [firebird-support] wrote: > so he must miss something but what? Whole chapter "Database information request buffer and result buffer" in Interbase API Guide. Don't let chapter name to confuse you: buffer formats are the same for all info calls. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: in new API
Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit : >> transaction id (= current_transaction) > > /* jrd\inf_pub.h ok, we erase everything and we take the sources of UIB. var item : ansichar; data: packed record item: AnsiChar; len: word; case byte of 0: (vByte: Byte); 1: (vSmallint: Smallint); 2: (vInteger: Integer); 3: (dummy: array[0..5] of byte); end; fresult : integer; begin item :=ansichar(4); tra.getInfo(st,1,@item,sizeof(data),@data); if (data.item = item) then case data.len of 0: ; 1: fresult := data.vByte; 2: fresult := data.vSmallint; 4: fresult := data.vInteger; else raise exception.Create('Unexpected data size.'); end else raise exception.Create('Invalid item identifier.'); works very well. -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: in new API
Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit : > transaction id (= current_transaction) /* jrd\inf_pub.h /*/ /* Transaction information items */ /*/ #define isc_info_tra_id 4 #define isc_info_tra_oldest_interesting 5 #define isc_info_tra_oldest_snapshot6 #define isc_info_tra_oldest_active 7 #define isc_info_tra_isolation 8 #define isc_info_tra_access 9 #define isc_info_tra_lock_timeout 10 #define fb_info_tra_dbpath 11 */ getmem(items,8); val := 4 ; move(items[0],byte(val),1); val := 5 ; move(items[1],byte(val),1); val := 6 ; move(items[2],byte(val),1); val := 7 ; move(items[3],byte(val),1); val := 8 ; move(items[4],byte(val),1); val := 9 ; move(items[5],byte(val),1); val := 10 ; move(items[6],byte(val),1); val := 11 ; move(items[7],byte(val),1); tra.getInfo(st,length(items),itemsptr,bufferlenght,bufferptr); result in buffer = 3,5,0,13,21,0,0,20,3,5,0,240,21,0,0,20,3,5,0,173,21,0,0,20,3,5,0,186,21,0,0,20,3,5,0,13,21,0,0,20,3,5,0,240,21,0,0,20,3,5,0,173,21,0,0,20,3,5,0,186,21,0,0,20,3,5,0,171,21,0,0,20,1,.. either here (if I understand correctly): 1283 13 335544341 1283 240 335544341 1283 173 335544341 and 335544341 is equal to ( 13,240,173,..I have not found yet) = -901335544341 infunk Unknown information item ok ;-), so he must miss something but what? -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: in new API
>>> Almost the same way as with ISC API: use ITransaction::getInfo() and >>> IAttachment::getInfo() >> I search since but can not find any info on items: byteptr. >> in dot net sources, i found a constant isc_info_next_transaction: = 107 >> but does not exist in firebird.pas. > I assumed you already know how to get this info using ISC API, seems i was > wrong. Well no :-) I do tests and get things wacky or the error number 335544341 >Anyway, below is what you are looking for: >isc_info_attachment_id = 22 >isc_info_tra_id = 4 >All constants can be found at \include\ibase.h a big thank you, I look here. -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: in new API
---In firebird-support@yahoogroups.com, wrote : >>> and connection (= current_connection)? >> Almost the same way as with ISC API: use ITransaction::getInfo() and >> IAttachment::getInfo() >I search since but can not find any info on items: byteptr. >in dot net sources, i found a constant isc_info_next_transaction: = 107 >but does not exist in firebird.pas. I assumed you already know how to get this info using ISC API, seems i was wrong. Anyway, below is what you are looking for: isc_info_attachment_id = 22 isc_info_tra_id = 4 All constants can be found at \include\ibase.h Regards, Vlad PS Feel free to ask more, if needed