🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1045

Re: Using Interbase Server

#1045
From: Keith G. Chuvala (TeamB)
Date: Thu, 14 May 1998 00:00
33 lines
2315 bytes
> Does that mean a 'broader' SQL command set which can be coded right into a
> VDB app?  I guess this is where some of my confusion lies.

Sure.  In 5.x local SQL was week, so I used SLQExec() a fair amount to get
things done on my particular back end, which is an AS/400.  When working at
home or on my laptop, I kept a model of key tables in a local Interbase
database and could mimic most everything I needed from my production
environment simply by changing a single global property (the name of the
database to open).  I used the so-called "Data pump" to do a fair amount of
that at one time, and it worked pretty well, creating Interbase tables from
AS/400 data sources.  As long as they were flat tables there were no
problems.  Multi-member tables were another story, but they're problematic for
ODBC anyway, so I already had logical files (akin to SQL views) set up on the
AS/400 for those situations.

7.x has addressed some of the limitations of 5.6's local SQL, but there are
still things you might want to do on a back end that are beyond it's scope
(for me that's frequently subselects and calls).   I don't really need the
capability as much these days, but I keep local Interbase loaded just in case.
:)

>> Kens marketing-minded reply <G>
> -------------------------
> He may have provided me with more 'marketing' information than I ever
> received from Borland on this.  <bg>

A trait endemic to the Borlander species, no doubt.  And no doubt the Inpriser
one shows the same tendencies.  Anyway, Ken's back on TeamB now, so we expect
his level of marketing schlock to decrease as his level of jovial inanity
increases. :)

kgc
Technical Details
Message-ID: <355B4E0C.231F8262@DELETE_THIS.hit.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <MPG.fc387b37fa019889896b4@forums.borland.com> <355A1481.77B48194@DELETE_THIS.hit.net> <MPG.fc4e70b6df9871c9896b5@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,fc503cab205dbfe0
X-Google-Attributes: gidff5a1,public
From: "Keith G. Chuvala (TeamB)" <kgc@DELETE_THIS.hit.net>
Subject: Re: Using Interbase Server
Date: 1998/05/14
Message-ID: <355B4E0C.231F8262@DELETE_THIS.hit.net>
X-Deja-AN: 353301747
Content-Transfer-Encoding: 7bit
References: <MPG.fc387b37fa019889896b4@forums.borland.com> <355A1481.77B48194@DELETE_THIS.hit.net> <MPG.fc4e70b6df9871c9896b5@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: First Intermark Corp.
Newsgroups: borland.public.vdbase.data.sql