Independence of the data source type with BDE

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

Article #39

Back to borland.public.vdbase.data.sql Previous Next

#39

From: Semen L. Meshcheryakov
Date: Mon, 22 Feb 1999 00:00

24 lines
1307 bytes

Dear BDE experts,

I'm trying to write SW with external data source descriptions.
Making correct SQL statements is SW (not user) job.
So, SW must be as much as possible SQL dialects independent.

My steps:
 - I try to use DbiGetProp(..., dbQUOTECHAR...) to be SQL dialects
independent
 - when I was Ok with read queries (based on DbiQExecDirect), I was enforced
   to use DbiQAlloc-DbiSetProp(hStmt, stmtLIVENESS,
wantLIVE)-DbiQPrepare-DbiQExec chain
   to make updateable cursors
 - but all my efforts with SQL dialects was waste -> after DbiSetProp(hStmt,
stmtLIVENESS, wantLIVE)
    DbiQPrepare must be conformed with BDE local SQL

I think that "Independence of the data source type with BDE" is a common and
valuable item.
The guide about this will be very useful. Any references/suggestions will be
appreciated.

Thanks,
Semen

Technical Details

Message-ID: <919677963.535469@is.kiev.ua>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,839ad94e95b6e4f,start
X-Google-Attributes: gidff5a1,public
From: "Semen L. Meshcheryakov" <smesh@is.kiev.ua>
Subject: Independence of the data source type with BDE
Date: 1999/02/22
Message-ID: <919677963.535469@is.kiev.ua>
X-Deja-AN: 447017349
Organization: Intelligent Systems
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.vdbase.data.sql