Hans (and all), I implemented this solution but I'm contemplating about the following: 1) What situations cause the Default setting in FB to be ignored, as ...
... The DEFAULT clause is only used if you fail to include the columns in the INSERT clause. ... You could have a single trigger (for insert and update) that...
... Did you realise that the default constraint applies only in the following circumstances: 1) when inserting; AND 2) when the said column is NOT included...
Helen Borrie
helebor@...
Jun 1, 2006 7:34 am
38814
... No, it's DB rules. The default applies only to inserts, and only when the defaulted column is not present in the INSERT statement. You can involve the...
Helen Borrie
helebor@...
Jun 1, 2006 7:41 am
38815
Helen, many thanks for your answer. ... Sorry, little mistake: It should be IBManager. ... For I can not be sure, that there is allways a commit in the script,...
... On the surface, yes. My main caution is about running DDL and DML in the same script. I would rather run the DDL script, committing and intercepting the ...
Helen Borrie
helebor@...
Jun 1, 2006 8:20 am
38817
I decided to distribute for testing a part of my application on another PC and met the following problem : The code to connect to the database that runs...
... the ... the ... great. ... In fact, I think I have progressed. It seems that it is a problem of password. My password is in lower case and it is...
Hi Sorry to bother people with this again, I thought I had it working but.. Just switched form SS to classic to test that our backups (using TIBOBackupService)...
... Not reading the release notes? Classic on Windows doesn't take local connections (cpLocal) and TCP/IP (cpTCP_IP) doesn't take a serverless connection. I...
Hi Helen Sorry I am not understanding. I am aware Classic doesn't support localhost, thats why I specified cpTCP_Ip. I also thought I had specified a server...
... No, that's quite untrue. Classic doesn't support "Windows local" connections, a.k.a. IPServer, or cpLocal, in IBO terminology. ... Correct, you should. ...
... It sounds as though you are providing extra stuff that is turning into and invalid connection string for the service manager. Reality check: Servername...
I have not solved yet my problem of connection to a database. The installed version of my program + database runs correctly on my PC. But I have an error on...
Hello Group, There's the following scenario: A Query is displayed in a Grid. After you scroll in the Grid, there's a high possibility that the data has been ...
Daniel Albuschat
d.albuschat@...
Jun 2, 2006 8:58 am
38829
... No, the problem is not caused by IBO. You have something configured incorrectly in your application. Tell us about the location of the database on the...
... In a TIB_DataSource, you can use OnDataChange. This fires for all columns, but gives you enough information about which field actually changed. -- ...
Daniel Albuschat
d.albuschat@...
Jun 2, 2006 9:26 am
38831
The location of the database on the new machine is : C:\Program Files\Cocagne_Gest_Prod\Database\BDCOCAGNE_PLC.FDB The Server, Path and Protocol properties for...
... If you are going to deploy this with a hard-wired location in a directory tree with spaces in the names, i.e. "Program Files" then at least do it properly...
Thanks a lot for your comments. They make things clear. Sorry but I have a few more questions : 1) How will I read the aliases.conf file ? Do I just have to...
... You don't. It is done by fbclient.dll. ... No. It does NOT belong to the AliasName property which should, in my opinion, be removed. AliasName has...
Thanks to Helen and Rita. I create an alias in the aliases.conf : cocagneFC = c:\DataCocagne\BDCOCAGNE_PLC.FDB and wrote the following code in my app : with...
hello, ... IB_Connection1.DatabaseName := 'cocagneFC'; The Path property is automatically set by the component, based on the DatabaseName value, and you...
Daniel this is a common problem for me in displaying data in grids. One general way to handle presenting up-to-date data is to allow the user to press a button...
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.
