Article View: borland.public.vdbase.data.sql
Article #1045Re: Using Interbase Server
From: Keith G. Chuvala (TeamB)
Date: Thu, 14 May 1998 00:00
Date: Thu, 14 May 1998 00:00
33 lines
2315 bytes
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-mailReferences:
<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