| need help with query [message #374329] |
Wed, 06 June 2001 01:20 |
qatarson
Messages: 1
Registered: June 2001
|
Junior Member |
|
|
Hi , I need to make query for lands table which can be search by two feilds land_no and street_no so when user insert the land 100 on street 10 he get what he looking for . at same time the query form have an insertion block and let the user update the result .
that mean there two block one have land_no and stree_no with query button and the other block have the table feild and save button to help the user saving the date which looking for it . anyone can help ? I did the form and block it work very well but i can't display the result by query button only display when i click F8
i used this select on land_no as below
select land_no into :qe.land_no
from lands
where lands.land_no =:x.land_no;
select qars_no into :qe.qars_no
from lands
where lands.land_no =:x.land_no;
select st_no into :qe.st_no
from lands
where lands.land_no =:x.land_no;
select pin_no into :qe.pin_no
from lands
where lands.land_no =:x.land_no;
select building into :qe.building
from lands
where lands.land_no =:x.land_no;
select owner_name into :qe.owner_name
from lands
where lands.land_no =:x.land_no;
select old_owner into :qe.old_owner
from lands
where lands.land_no =:x.land_no;
select land_date into :qe.land_date
from lands
where lands.land_no =:x.land_no;
select b_date into :qe.b_date
from lands
where lands.land_no =:x.land_no;
select note into :qe.note
from lands
where lands.land_no =:x.land_no;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
