Re: [firebird-support] Blob field to Array
Hi, first what do you mean it contain array of boolean you mean e.g 5 bytes and first byte is first boolean, seconf byte is second boolean..? And for this you probably need udf or convert to string regards, Karol Bieniaszewski From: maartenjanbak...@gmail.com [firebird-support] Sent: Thursday, May 11, 2017 1:03 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Blob field to Array Hi, I've got a blobfield which contains an array of boolean. I would like to get a value from a certain position from this array to use in a stored procedure. Does someone know how this is done? I've searched the internet for it, but can't get it to work. Thanks in advance, Maarten --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus
[firebird-support] Blob field to Array
Hi, I've got a blobfield which contains an array of boolean. I would like to get a value from a certain position from this array to use in a stored procedure. Does someone know how this is done? I've searched the internet for it, but can't get it to work. Thanks in advance, Maarten
Re: [firebird-support] Table Size
Hi Ed, There is IBAanalyst tool (now it is a part of HQbird), it shows sizes of tables and associated indices, see column Size http://ib-aid.com/images/iba_tables.gif Regards, Alexey Kovyazin IBSurgeon HQbird www.ib-aid.com I have a number of growing databases on my server and would like to occasionally see how much space each table is taking in the database--there may be some log files that could be cleaned up now and then. Many of my tables include blob fields, so this becomes different than just doing record count times the amount of data in a record. Does anyone have any tools that they can recommend that could help me easily manage this? much appreciated, Ed Dressel
Re: [firebird-support] Table Size
11.05.2017 1:56, dres...@tbinc.com [firebird-support] wrote: > The results are pretty raw data--something like a pie chart would be nice. IIRC, IBSurgeon have a graphical tool for that. Look at www.ibsurgeon.com. -- 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/