... Oh, thats another thing I have been wondering... does the object name length matter (when keeping query speed in mind)? I do have a habit to use prefixes...
... Really? Is the new over the wire protocol optimized for such a cases (ie when integer value fits into one byte it would be sent as one byte, not as four)? ...
... Won't work for a char(16) though. It's always 16 characters long, with significant trailing blanks on any non-null values that are shorter than 16. ...
... BTW: This only works if stockcode is varchar, for char you would need char_length(trim(stockcode)) <> 16. Mark -- Jetzt kostenlos herunterladen: Internet...
Mark Rotteveel
Avalanche1979@...
Nov 13, 2009 12:23 pm
105484
... I'd go for: where char_length(stockcode) <> 16 Mark -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter...
I have a stockcode field in the stock table which is a char type. Usually it is left padded with 0 and have 16 characters. If I want to varify of there are...
In cases I don't want to reveal the code of the procedure (*given* that users don't really want to decompile the BLR as long as they do see code in the...
... you can delete the trigger, procedure code after compiling BLR. ... I don't think you can realistically not reveal the SYSDBA password. What happens when...
The security of your stored procedures relies on blocking physical access to the database file. (For example: You can always open the database file with...
I'm considering bundling a Firebird database file and Firebird server installer with some vertical market software of ours that is not open source. I'm trying...
It won't make a difference when you have "longer" db object names - it makes sense when you keep them as short as possible. Two, three characters more in names...
... It would send 4 bytes while one would do... as I sayd a lot of those records would be sent back and forth between client and serves and to optimize for...
Hi, What would be the best data type for a 8 bit flags field? My first thought was to use CHAR(1) CHARACTER SET OCTETS (I guess OCTETS should be preferred over...
... I'd say that Ansi Chars is the only way to call the function. Wide Chars won't work. ... If you use isc_dpb_utf8_filename in 2.5 you can use unitode (utf8 ...
Just checking... I can’t call isc_attach_database(@(hdbc^.status), 0,@DATABASE,@(hdbc^.db_handle),i, @dpb); with PAnsiChars for DATABASE and UserName and...
... Probably, but that's an artifact of implementation that may change arbitrarily in the future. Or, horrors, you may find that you've got data where zero or...
I was wondering if there was some way to handle columns with NULL values without using indicator variables. If I were to initialize all host variables to some...
... Thank you for suggestions, but, what I would like to achieve is to log changes within same transaction, I can do that by modifying application code, but it...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
