problem with sql statement

If you are a Power Builder developer and have any questions about using our products from Power Builder here is the place to post them.
Post Reply
omri
Posts: 3
Joined: Tue Jun 08 2004

problem with sql statement

Post by omri » Sun Jun 13 2004

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
Posts: 3
Joined: Tue May 03 2005
Location: Eugene

Semicolon

Post by markmazza » Tue May 03 2005

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

Post Reply