OraFAQ Forum: Forms » Problem in insert data / trigger (merged)

Home » Developer & Programmer » Forms » Problem in insert data / trigger (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in insert data / trigger (merged) [message #218422]

Thu, 08 February 2007 03:03

ambreen
Messages: 9
Registered: October 2006
Location: Pakistan

Junior Member

How can i insert many roll nos in single record ?

Report message to a moderator

problem in insert data [message #218427 is a reply to message #218422]

Thu, 08 February 2007 03:16

ambreen
Messages: 9
Registered: October 2006
Location: Pakistan

Junior Member

i have to insert single comments when i insert or update mutiple roll nos how can i do this

Report message to a moderator

Re: problem in insert data [message #218430 is a reply to message #218427]

Thu, 08 February 2007 03:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you, please, repeat the question using English language (as much as possible), using punctuation where needed? Because, I didn't understand a word.

What are 'roll nos'? What, exactly, is a problem here?

Report message to a moderator

Re: problem in insert data [message #218609 is a reply to message #218430]

Thu, 08 February 2007 23:48

ambreen
Messages: 9
Registered: October 2006
Location: Pakistan

Junior Member

I want to insert student rollnos in a single record .

Report message to a moderator

Re: problem in insert data [message #218613 is a reply to message #218609]

Fri, 09 February 2007 00:10

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Once again, I have no idea what "roll nos" or "rollnos" is/are. I can't even imagine how should it look like. Can you draw it, or - perhaps - use more than one single sentence to explain the problem. I'm really sorry, but I can't help you at all. Maybe you'll be more lucky with other forum members (who understand what you are talking about).

Report message to a moderator

Re: problem in insert data [message #218618 is a reply to message #218613]

Fri, 09 February 2007 00:16

Frank
Messages: 7901
Registered: March 2000

Senior Member

Same here. No idea what actually is asked.

Show us your table layout. Describe your form. Explain what it is you want to do and use AT LEAST three sentences for that.

Report message to a moderator

Re: problem in insert data [message #218763 is a reply to message #218618]

Fri, 09 February 2007 22:03

ambreen
Messages: 9
Registered: October 2006
Location: Pakistan

Junior Member

student table contains roll no like ME-024 ME-025 ....
How can i insert these muliple roll nos in single record in another table 'userlog' colummn comments.
Comments column should insert roll nos like ME-024,ME-025,ME-026 and so on

Report message to a moderator

Re: problem in insert data [message #218864 is a reply to message #218763]

Sun, 11 February 2007 12:34

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Check this Ask Tom page about the STRAGG function, or use CONCAT_ALL function. Whichever you like should do the job.

Report message to a moderator

Re: problem in insert data [message #219152 is a reply to message #218864]

Tue, 13 February 2007 03:10

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I think the OP needs to have a subordinate (detail) table to hold the 'roll nos' for the master record.

David

Report message to a moderator

Previous Topic:	error web client version too old
Next Topic:	Forms Installation Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 19:18:07 CST 2025