help me please - SQL syntax problem...newbie
Posted on 2003-12-08
this should be a simple one guys...
I have a table for room service called guest_trans. I have a canvas with a tabular data block (guest_trans) with four fields from that table (room_num, description, rate, trans_date)....simple enough. It displays 5 records with a scrollbar. I did all this with the wizard. Now, I created another data block on the same canvas (room_num) with one text field (room_num) and one command button.
I want when you enter a room_num in the text field and hit the command...it display all the room service charges for that room number. here is my code that is giving me fits.
--get room_service info
if :room_num.room_num is not null then
select room_num, description, rate, trans_date
into :guest_trans.room_num, :guest_trans.description, :guest_trans.rate, :guest_trans.trans_date
where room_num = :room_num.room_num;