Hi everybody, In previous version of FB 1.5 (+IBX) and connect directy security.fdb and retrieve all logins. But now, using FB2(+IBO4) it's does not possible. ...
Hi Again, I found and I did install IBOAdmin, but studing your properties I conclude that to retrieve all users : var ResultList:TStringLIST; n:Integer; begin ...
I found a solution, IBOAdmin does not requer UserName and Password as property, but as TParams. if I fill Username and Password then 'SPB constant not...
Hi Attempting to install IBO4_8_7 into D2007 so it co-exists with D6. Unzipped installer and ran install. Did the first part OK then went onto installing into...
... I run 4 versions of Delphi on the same machine, though not D2007, with a variety of IBO versions. I keep a separate source folder for each Delphi/IBO...
Hi Helen Thank you for your reply I tried it again following your advice and it worked ;-) second attempt anyway. First time I went through every package and...
... I had written ... Ach! sorry! I should have said "dcp", not "dcu". In all cases my dcu's are left in the same folder as the source units (so that they...
Hi, Try this: UserName := 'isc_spb_user_name=YOUR_USER_NAME' Password := 'isc_spb_password=your_password' Edison PS: é bom ver gente conhecida na lista :D ...
I have a TIB_Query that uses the aggregate function MAX: SELECT P.NAME, P.BIRTHDATE, MAX(R.RECORDDATE) AS LASTDATE FROM PATIENT P, RECORDING R WHERE P.PATNUM =...
... Use the orindal value instaed of the fieldname (alias) So use 3 in place of lastdate, the orderinglinks generator will use the alias by default you need to...
Please also add the below calls to BeginBusy and EndBusy as they will eliminate the SQL Hourglass flickering. Jason Wharton ... try IB_DSQL.BeginBusy( false );...
... It would be helpful to know what database you are using. InterBase has a new feature that allows batch execution which might be helpful to increase your...
... 1) You can put data from ClientDataSet into external IB/FB table 2) Insert data from this external table into database table(s). (via SP or in another way)...
Hi, What i want is: -automatically compress data when written to a specific blob column via insert/update -automatically decompress data of a blob column when...
... Have a look at the contributed code section at IBObjects website, there is a library there for the compression/decompression of blob data on the fly. It...
... I found ZipFilterBlob.zip. But thats not what i wanted. Its client-side compression/decompression. ... that's what i found out too :-( ... I did. ... ...
... It would be nicer if you could use blob filters in SQL, for example: select cast(myblobcolumn as subtype -2) and then the blobfilter from subtype <as...
I could likely use ColumnAttributes to make this easier. I already work with blob filters for converting BLR to text. This can be seen in the IB_SQL tool where...
Hi, Apologies if I do any mistakes or if this is a FAQ (if so I haven't found it :). I've got a Windows service which connects to a firebird database. To do...
... [ ... ] ... I'll comment on this first, as it is extremely important. A "connection" is a logical object, representing a live connection between one...
Thanks a bunch for the *very* thorough walk-through of all the things I need to consider. You are probably right that I should take a few steps back and throw...
Hi everybody. I migrate from IBO 4.3a to 4.8.7, and now my TIB_Connection does open if Local Conection is selected. I try this example : with IB_Connection1 do...
... Does open? or does NOT open? ... No. "Localhost" is the TCP/IP local loopback server. It needs cpTCP_IP protocol and cannot work with cpLocal. The "empty...
Hi Server:='localhost'; Protocol:=cpLocal; in IB_Connection1 does not open connection, raise "unavaliable database". But in IBO 4.3a runs OK with the same...
Ive got a table with 100,000 records, and 300 fields. Ive got a very simple read only app, that loops from the top down, looking doing some price analysis on...