Independence of the data source type with BDE

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Semen L. Meshcheryakov Mon, 22 Feb 1999 00:00

#39

Author: 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

Re: Independence of the data source type with BDE

#41

Author: Ken Mayer [TeamB]
Date: Mon, 22 Feb 1999 00:00

25 lines
1341 bytes

"Semen L. Meshcheryakov" <smesh@is.kiev.ua> wrote:

>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

All of this sounds very much like Delphi -- you need to be asking
these questions in the Delphi newsgroups, not the Visual dBASE
newsgroups.

Ken
---
Ken Mayer [TeamB]
http://www.mindspring.com/~hirschv/dbase/dbase.htm
   If "Bandwidth" error occurs, use mirror site:
http://www.apptools.com/dbase/kenstuff

TeamB: http://www.teamb.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads