PowerPoint Presentation

Single-Row Select Statements

int getPrice(char *name) {

EXEC SQL BEGIN DECLARE SECTION;

char n[20];

int p;

char SQLSTATE[6];

EXEC SQL END DECLARE SECTION;

strcpy(n, name); /* copy name to local variable */

EXEC SQL SELECT price INTO :p

FROM Product

WHERE Product.name = :n;

return p;

}