 ordering form [message #457742] |
Tue, 25 May 2010 16:01  |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
hello,,,,
i create a form for ordering>>>that the person can enter his/her information and isbn book to make the order,but the order id i make it sequencialy!!
well first of all i create a data-block and i insert only the oid
in trigger when-new-item-instance:
i had create the sequence:
declare
create sequence seq1
start with 90
increment by 10;
end;
and i make a view form such of fields that user can enter a details o what he/she want to order!!
1- is that enough???
2- it sems there is an error in creating the sequence??!! i don't know why!! or mabye this is a wrong way to create the sequence!!!
please help me!!
I have to finish my bookstore project for next tue!!! there is no time,,
god bluss u all!!!
|
|
|
|
|
|
| Re: ordering form [message #457747 is a reply to message #457745] |
Tue, 25 May 2010 16:35  |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
i had remove the declare and end!!
the error is:
encountered the symbol "create" ,,!!
is it orrect to put this code just in tigger when new instance
i want as also is made sequencialy when the user wants to make an order in this form!!
did u have any suggetions or somethings to improve or make an advances orderning form!!
thanx for your attention..!!
|
|
|
|
| Re: ordering form [message #457748 is a reply to message #457747] |
Tue, 25 May 2010 16:39 |
purelove
Messages: 32
Registered: May 2010
Location: bahrain
|
Member |
|
|
Do it as the database level. And use that sequence value in the form code?!!!!
i create theat sequence in the sql!!!
but how can call it in the trigger when new instance!!!plz help
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
