Home » Developer & Programmer » Forms » Map checkbox to database-items (Was: One-Time-Only Procedure) (oracle 9i,forms 4.5,xp)
Map checkbox to database-items (Was: One-Time-Only Procedure) [message #328659] Sat, 21 June 2008 04:54 Go to next message
mohan1760
Messages: 59
Registered: June 2008
Member
Hi all,

i m developing a form which has several checkboxes, with textboxes which are connected to database 9i,
how can i map the checkboxes which are non databases items to the textboxes which are database items.

i want to update the database records according to checkbox status.

i m using forms 4.5

Thanks in advance.



[Mod-edit: Frank changed the topic title to something that DOES resemble the contents of your post]

[Updated on: Tue, 24 June 2008 02:19] by Moderator

Report message to a moderator

Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #329585 is a reply to message #328659] Wed, 25 June 2008 23:47 Go to previous messageGo to next message
mohan1760
Messages: 59
Registered: June 2008
Member
cmon please reply guys,its already been 6 days since i post this request. Mad
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #330017 is a reply to message #328659] Fri, 27 June 2008 06:06 Go to previous messageGo to next message
averno9
Messages: 30
Registered: June 2008
Location: Spain
Member
Explain a bit more what you want to do. A good thing would be a practice example.

PS: We are not your teachers, we are not forced to help you. If you don't like it, search in google or read documentation
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #330022 is a reply to message #330017] Fri, 27 June 2008 06:20 Go to previous messageGo to next message
mohan1760
Messages: 59
Registered: June 2008
Member
let me explain ,
there are more than 300 records records in table,as

emp1 chkbox

emp2 chkbox

emp3 chkbox

:

:

NEXT button(to display next 10 records).

i am displaying 10 records at at a time,

Now i want to update only those employee names where the checkbox in front of that record is checked , else it should remain as it is.

the employee name are obviously are database items ,whereas chkbox are non databse items.

now the problem is that how can i map these checkboxes to the records as there is no any relation between them.

waiting for reply.


Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #330027 is a reply to message #330022] Fri, 27 June 2008 06:29 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
What do you mean, there is no relation between them?
The checkboxes are part of the records in Forms, aren't they?
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #330248 is a reply to message #330027] Sat, 28 June 2008 03:30 Go to previous messageGo to next message
mohan1760
Messages: 59
Registered: June 2008
Member
if i am right then according to me,

The checkboxes are part of the records in Forms only when they are used as database items,
but
i am using them here only as a flag(non database items)
and accordign to flag i want to update database fields which displayed in textboxes.

waiting for reply.
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #330305 is a reply to message #330248] Sun, 29 June 2008 03:57 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
But if you do add them to the (Forms)records, database-item or not, they _are_ related to the rest of the record, so you can relate them to that.
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #330377 is a reply to message #330305] Mon, 30 June 2008 00:22 Go to previous messageGo to next message
mohan1760
Messages: 59
Registered: June 2008
Member
if you have example(.fmb file) related to this can you send it to me?
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #337161 is a reply to message #330377] Wed, 30 July 2008 01:27 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #337785 is a reply to message #337161] Fri, 01 August 2008 03:56 Go to previous messageGo to next message
mohan1760
Messages: 59
Registered: June 2008
Member
yes Smile
Re: Map checkbox to database-items (Was: One-Time-Only Procedure) [message #337789 is a reply to message #328659] Fri, 01 August 2008 04:00 Go to previous message
averno9
Messages: 30
Registered: June 2008
Location: Spain
Member
Could you explain us how did you did it? If it works, it works, but maybe someone could tell you a better way to do it, or no.

Congratulations and keep on that way.
Previous Topic: How to apply the format mask to number contains character
Next Topic: Forms 10g installation
Goto Forum:
  


Current Time: Sun Feb 09 07:10:58 CST 2025