problem with sql statement

[omri]

hello there,

i have a problem with the sql statement, when i want to recive a variable from out side i write(for example):

select ........
from .......
where drivers.id= :id

and it gives me an argument that used in the select is not defined.
plesae help me with that stupid thing .

omri

carpe diem

[markmazza]

Omri,

If this is embeded SQL inside of a PB script you have end all SQL with a semicolon ; Try adding a semicolon after your Where clause

Mark