Code Forums - View Single Post - C++ Builder 6

teknomage1 · 05-03-2006, 07: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.

05-03-2006, 07:01 AM	#4 (permalink)
teknomage1 Jack of all trades Join Date: Feb 2005 Location: Los Angeles Posts: 598	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. __________________ Stop intellectual property from infringing on me