SQL Queries with Borland Builder C++

Hi,
My goal is to perform a single SQL query (“select xxx from yyyy etc etc”) to a Database over a LAN, using BORLAND C++ 4.5 and managing USERNAME and PASSWORD.

I tried 2 methods so far
:
Method N.1) I used “Tquery”, TdataSource and TDBedit components linked togheter and it works but….I need to manage USERNAME and PASSWORD runtime so I’m trying the following method N.2

Method N.2) I’m using TdataBase. Although I can Open the DataBase I don’t know how to perform the SQL Query. Do I have to use the Tquery component? In which way? How can I refer the Tquery to the Tdatabase component? Can you give me a simple example?
Thank you a lot!

pitopito

Newbie Poster

1 post since Oct 2006

Reputation Points: 10

Solved Threads: 0

5 Years Ago

Another option you might consider is standard ODBC which will make your program more portable to other compilers should you ever decide to change compilers. There are a number of free c++ ODBC class you can download off the net.

Ancient Dragon

Retired & Loving It

Team Colleague

30,049 posts since Aug 2005

Reputation Points: 5,662

Solved Threads: 2,343

This article has been dead for over three months

You