| copy records [message #392724] |
Thu, 19 March 2009 01:38  |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
hi all
I have two schemas in our database named as
1.employee
2.master
In employee schema i have one table.I want to copy the records from employee schema to master schema.
How can i achieve this?......
Thanks and regards
varosh
|
|
|
|
|
|
| Re: copy records [message #392737 is a reply to message #392726] |
Thu, 19 March 2009 02:14  |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
It works fine.
But i call the table in forms all the records show one by one.I gave particular id and click the pushbutton it display the error message like query caused no records in the data base.
How can achieve this?...
thanks and regards
varosh
[Updated on: Thu, 19 March 2009 02:16] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: copy records [message #392805 is a reply to message #392784] |
Thu, 19 March 2009 05:37 |
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
|
Senior Member |
|
|
Hi !
I also tried with the following coding for that push button,
begin
select id,name into :stud.id,:stud.name from student
where id=:stud.id;
exception
when no_data_found then
message('Such Id doesnot exist');
end;
Iam getting the message
when i didnt catch that exception, iam getting
Query caused no records to be retrieved
Thanks
varosh
|
|
|
|
| Re: copy records [message #392818 is a reply to message #392724] |
Thu, 19 March 2009 06:19 |
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Don't replace execute_query with a select statement.
Just make execute_query work.
Using the correct syntax would be a good start - you can find it in the form builder help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
