Re: [firebird-support] Service Manager SPB (Parameter Buffer)
On 18-07-12 20:56, dve83 wrote: Hi, busy connecting to the service manager via the API. According to Interbase 6 API Guide I need to prep the SPB with the following isc_spb_version1 isc_spb_current_version isc_spb_user_name Length(6) of Username username isc_spb_password Length(9) of password password my result in AnsiString looks likes this #1#2#$1C#6'SYSDBA'#$1D#9'masterkey' SPBLength = 21 this seems correct according to the spec in the API, however I keep getting the following Interbase message ' Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long' To me this means that either section 'username' or 'password' is beyond the length of the buffer. HOWEVER, if I remove the isc_spc_current_version and decrease SPBLength by 1, all is good and the connection to Service Manager is made. What am I missing? Hi, I don't know if it's anything to do with your problem, but AFAIK, Firebird passwords are max. 8 characters long. Regards, Koenraad Lelong
Re: [firebird-support] Service Manager SPB (Parameter Buffer)
Hi thanks. I noticed that.. Will check it out, but figured I'd still post the question as the next step after attaching to the service manager is to start some action - and I get the same issue there. So if there is something in general Im doing wrong - id like to find out :-) but yes, I will check the password . thx On Thu, Jul 19, 2012 at 9:56 AM, Koenraad Lelong firebir...@ace-electronics.be wrote: ** On 18-07-12 20:56, dve83 wrote: Hi, busy connecting to the service manager via the API. According to Interbase 6 API Guide I need to prep the SPB with the following isc_spb_version1 isc_spb_current_version isc_spb_user_name Length(6) of Username username isc_spb_password Length(9) of password password my result in AnsiString looks likes this #1#2#$1C#6'SYSDBA'#$1D#9'masterkey' SPBLength = 21 this seems correct according to the spec in the API, however I keep getting the following Interbase message ' Invalid clumplet buffer structure: buffer end before end of clumplet - clumplet too long' To me this means that either section 'username' or 'password' is beyond the length of the buffer. HOWEVER, if I remove the isc_spc_current_version and decrease SPBLength by 1, all is good and the connection to Service Manager is made. What am I missing? Hi, I don't know if it's anything to do with your problem, but AFAIK, Firebird passwords are max. 8 characters long. Regards, Koenraad Lelong [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
[firebird-support] Re: Extract metadata to xml?
I also think that your government wants to have it in a specific XML schema, not just 'in XML'. Mark Umm no :) I've just called them, they say 'ok' to any kind of metadata in a readable format. Thank you.
Re: [firebird-support] Re: Extract metadata to xml?
I also think that your government wants to have it in a specific XML schema, not just 'in XML'. Mark Umm no :) I've just called them, they say 'ok' to any kind of metadata in a readable format. Thank you. Define readable. ;-) Do they just need some kind of documentation (ER diagram) or something reproducable/runnable in case the man in charge of the database leaves the project/company etc. -- With regards, Thomas Steinmaurer http://www.upscene.com/
Re: [firebird-support] Re: Extract metadata to xml?
On 19-7-2012 13:17, arda wrote: I also think that your government wants to have it in a specific XML schema, not just 'in XML'. Mark Umm no :) I've just called them, they say 'ok' to any kind of metadata in a readable format. Thank you. Then stick something like ?xml version=1.0? data= before the output you get from e.g. Flamerobin metadata export and after, and you're done. (Ok, that won't be XML because you'd have to escape invalid characters etc, but I hope you get my point). I really don't think that is what they have in mind. They must want to *do* something with that metadata. For that, they will need to read it. For that, they will need to have a fixed format so they can read it consistently, or build a custom parser for each person handing in the XML files?!?!? I think the key word you're missing is they said *readable* format. What formats are readable to them?
[firebird-support] Perl, Firebird, and empty Where clause
I'm trying to have an existing perl program, that is using the DBI system for theoretical database interoperability, to use Firebird. I've discovered that, as a standard, this program executes statements such as, select * from table where pkey='' That apparently works with Mysql - doing such a select with a specified empty where clause will return the full table. Firebird - probably more correctly - does a comparison for empty/null and returns...nothing. Without changing the perl script, is there a way I can have Firebird actually return the table using the above SQL? -- Daniel
Re: [firebird-support] Perl, Firebird, and empty Where clause
I'm trying to have an existing perl program, that is using the DBI system for theoretical database interoperability, to use Firebird. I've discovered that, as a standard, this program executes statements such as, select * from table where pkey='' That apparently works with Mysql - doing such a select with a specified empty where clause will return the full table. Firebird - probably more correctly - does a comparison for empty/null and returns...nothing. Without changing the perl script, is there a way I can have Firebird actually return the table using the above SQL? I suppose that you could change the field to NOT NULL DEFAULT ''. Then would a comparison with empty string work. Josef ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
[firebird-support] Re: Extract metadata to xml?
Thanks, Turkish health ministry now wants to keep track of health related software. So first you have to register your software as a property of some company or individual. They want at least 25 pages of code and database structure (with data!) that can identify your software and identify it belongs to you. I said I can't give away any health related data! :) They said that's ok :) I asked if it's ok if I give the first 25 pages of database structure in txt format, they said it's ok. So I extracted the db structure with marathon db tool as I'm used to. They will probably accept .doc, .docx and .txt
[firebird-support] Re: SELECT statement runs at different speeds
Further testing (over subsequent days) shows that moving the field position of the BLOB fields to the bottom of the list (highest index number) makes no difference in performance. The second table (with BLOBs) is still executed much slower than the table without the BLOBs.
Re: [firebird-support] Perl, Firebird, and empty Where clause
Hello Daniel, I'm trying to have an existing perl program, that is using the DBI system for theoretical database interoperability, to use Firebird. I've discovered that, as a standard, this program executes statements such as, select * from table where pkey='' That apparently works with Mysql - doing such a select with a specified empty where clause will return the full table. I can assure you that not even MySQL would do something as outrageous as that *. At least not current versions. It must be something in an application layer or library (DBI?). This kind of behaviour sometimes makes sense in the backend of a user interface, where the user may fill in filter terms. If he leaves a field open, the program assumes that any value for that field is OK (as opposed to only the empty string). * (unless, of course, every record in the table has pkey=''. But that doesn't seem likely, since pkey is probably the primary key.) BTW, where pkey='' is not an empty where clause. It's a perfectly valid search condition - provided that pkey is a text field. Firebird - probably more correctly - You can leave out the 'probably'. There is only one correct behaviour here. does a comparison for empty/null and returns...nothing. Firebird will look for '' (empty string) in this case, *not* for null, which is something different. If there are records where pkey = '', it will return them. Otherwise, it will return an empty result set. Without changing the perl script, is there a way I can have Firebird actually return the table using the above SQL? No. You would have to intercept the SQL at some point and change it. If you want the whole table, leave out the WHERE clause and if that isn't possible, use a tautology, e.g. ...where 1=1 (or append or 1=1 to the existing clause). Good luck, Paul Vinkenoog
[firebird-support] How to use DELETE with LEFT JOIN
Hi, I'm newbie with Firebird. Now I try to delete some orphand records using: DELETE CUEN_DET01.* FROM CUEN_DET01 LEFT JOIN FACTF01 ON (CUEN_DET01.NO_FACTURA = FACTF01.CVE_DOC) AND (CUEN_DET01.CVE_CLIE = FACTF01.CVE_CLPV) WHERE FACTF01.CVE_DOC Is Null without a good result. I'm using IBexpert to do that. Please help.