Board index » delphi » Re: Interbase support for current date and time function, and other functions

2006-11-28 12:24:36 AM
delphi40
Enquiring Mind writes:
www.borland.com/downloads/registered/download_delphi.html
Scroll down until you see Delphi 7.1 updates. Click that, then log in
using the account you used to register Delphi (if you haven't
registered Delphi, you must do that before you can get any updates).
Agree to the EULA, then when you see the list of update scroll way down
until you see the IB 6.5 documentation update.
-Craig
--
Craig Stuntz [TeamB] ?Vertex Systems Corp. ?Columbus, OH
Delphi/InterBase Weblog : blogs.teamb.com/craigstuntz
How to ask questions the smart way:
www.catb.org/~esr/faqs/smart-questions.html
 

"Craig Stuntz [TeamB]" <XXXX@XXXXX.COM [a.k.a. acm.org]>wrote
in message news:456b0776$XXXX@XXXXX.COM...
give syntax definitions for IB SQL dialect. The detailed PDF files that
constitute the manual seem to be missing. Can the PDF files be downloaded
from anywhere? Without the manuals, it is very difficult to work with
Interbase, given the lack of comprehensiveness of the help files.
Enquiring Mind
 

Chapter 7 of the InterBase 7 Data Definition Manual.
Enquiring Mind writes:

Enquiring Mind writes:
Look at the papers that Craig (I think it is him) has on his web site.
Especially the info on Transactions. These guys can save you and
enormous amount of time if you read their papers. (Bill Todd, Craig et
al...)
www.interbase-world.com/en/
and get most of the white papers from the BDN and the Interbase Section
of Borland.
bdn.borland.com/interbase/design/database
and for eg.
bdn1.borland.com/borcon2004/article/0,1944,32280,00.html
blogs.teamb.com/craigstuntz/category/21.aspx
www.interbase-world.com/en/articles/532.php
www.ibphoenix.com/main.nfs
www.cvalde.net/index.htm
www.ibobjects.com/
www.interbaseworkbench.com/
www.clevercomponents.com/products/datapump/ibdatapump.asp
It takes a few days to get through all the papers but it will save you a
lot of time.
And of course -- just follow some of the sig lines...
Hope that helps a bit...
--
Will R
PMC Consulting
 

"WillR" <willrNo.Spam.pmccl.noSpam.com>writes
discovering that the documentation in my possession is so-so, so these
pointers are much appreciated.
Do any of these web sites, or any others for that matter, provide an
objective appraisal of the perceived strengths and weaknesses of Interbase
in comparison with other SQL Server systems?
Enquiring Mind
 

Enquiring Mind writes:
I actually don't recall one that wasn't. :-)
One of the great strengths of Interbase is the transaction/versioning
system -- do learn to use it.
Make sure that you commit transactions as soon as the data is usable to
other users in the network. Many of the problems I read about here
result from people not committing the transactions on a "regular" basis.
Unresolved transactions are the bane of _any_ SQL server.
I have a collection of every paper I could find and collected them in a
three ring binder. Really useful for a quick review.
I have been writing working with SQL server systems since 1980 -- I am
pretty happy with Interbase and not likely to switch unless I am forced
to switch by a client.
Read the Borland paper on Interbase vs. MYSQL server -- a bit dated --
but enlightening on what to look for. I think there is a comparison to
MS SQL as well -- a but dated as well...
IMHO import/export sucks -- but there are third party tools available to
move data around. (Data pump mentioned elsewhere.)
If you do not have a CASE tool -- get one -- well worth the price I use
Case studio
www.casestudio.com/enu/default.aspx
Perhaps other people can comment on good CASE tools for Interbase -- now
that they have been purchased by Quest and want another few hundred
dollars I may as well consider other modeling tools.
Get what you want for a Case Tool -- Just make sure it has a decent
interface into Interbase.
One of the systems I am working on has 18000 lines of sql to generate
the DB and triggers and procedures and UDF functions -- a little
daunting by hand... but a snap with CaseStudio -- and when I update the
DB I just use the IBexpert Data pump combination to move the test data.
The combination with Delphi 7 is also an excellent fit for the client
systems. But each to his own...
Check my other post for comments on tools. Hopefully people will add to
that list as well.
--
Will R
PMC Consulting