Is there any tutorial / sample code is available to learn SQL and ODBC API of pervasive V8.x or V9 versions.
Dynamically create Database , DSN
set connection to server or to workgroup computer.
create tables, modify tables, drop tables
create indexes, foreign keys.
I develop packages using C++
(Compiler dev-c++ or Borland commandline 5-5 free compiler.)
I do not have expertise in MFC or c++Builder.
I have working knowledge of btrieve 6.x API., and, I want to rewrite my existing packages for client-server architecture under Windows 2003 OS (GUI +SQL)
ODBC API is a Microsoft Standard. There are a number of tutorials on the web showing how to do ODBC API calls. The syntax of the SQL statements might be a little difference.
For the rest of the operations:
Dynamically create Database , DSN -- Look at DTI PvCreateDatabase, PvCreateDSN, and SqlConfigDatasource
create DDFs --PvCreateDatabase can do this.
set connection to server or to workgroup computer. --This is done in the ODBC DSN (from a SQL perspective) based on the type of DSN (Engine or Client) used.
create tables, modify tables, drop tables -- Look at CREATE TABLE, ALTER TABLE, and DROP TABLE in the SQL Language Reference in the docs.
create indexes, foreign keys. -- Look in the SQL Language Reference.
Drop index -- Look in the SQL Language Reference.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.