C++ Builder 6 - Database Search

Rowin · 05-02-2006, 02:32 AM

Hi,

I have a table called event in my database.
I have 2 fields called Event_Id and Project_Id.
I want to search the table to find out if there's event_id=27 for a project_id.

Kind Regards,
Rowin

teknomage1 · 05-02-2006, 03:57 PM

Does it use SQL?

Rowin · 05-03-2006, 12:49 AM

Yes I'm using SQL.

kind Regards,
Rowin

teknomage1 · 05-03-2006, 06:01 AM

Code:

SELECT Project_id, Event_id FROM event WHERE Event_id = 27 AND Project_id = <your_project_id>;

Just replace <your_project_id> with whatever project id variable you have. Note that while SQL commands (select,where, from) are case insensititve, table names and fields are case sensitive.

Rowin · 05-03-2006, 07:09 AM

I need to write the code in my C++ Builder 6 application.
How to insert the SQl in C++?

Kind Regards,
Rowin

DJMaze · 05-04-2006, 04:46 AM

Start -> Search -> find: bcb6.hlp

You should find info about TQuery inside that help

Rowin · 05-04-2006, 05:03 AM

Thanks.

Kind regards,
Rowin