Home » Developer & Programmer » Forms » Problem in insert data / trigger (merged)
Problem in insert data / trigger (merged) [message #218422] Thu, 08 February 2007 03:03 Go to next message
ambreen
Messages: 9
Registered: October 2006
Location: Pakistan
Junior Member

How can i insert many roll nos in single record ?
problem in insert data [message #218427 is a reply to message #218422] Thu, 08 February 2007 03:16 Go to previous messageGo to next message
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
Re: problem in insert data [message #218430 is a reply to message #218427] Thu, 08 February 2007 03:24 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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?
Re: problem in insert data [message #218609 is a reply to message #218430] Thu, 08 February 2007 23:48 Go to previous messageGo to next message
ambreen
Messages: 9
Registered: October 2006
Location: Pakistan
Junior Member

I want to insert student rollnos in a single record .
Re: problem in insert data [message #218613 is a reply to message #218609] Fri, 09 February 2007 00:10 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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).
Re: problem in insert data [message #218618 is a reply to message #218613] Fri, 09 February 2007 00:16 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: problem in insert data [message #218763 is a reply to message #218618] Fri, 09 February 2007 22:03 Go to previous messageGo to next message
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
Re: problem in insert data [message #218864 is a reply to message #218763] Sun, 11 February 2007 12:34 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: problem in insert data [message #219152 is a reply to message #218864] Tue, 13 February 2007 03:10 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: error web client version too old
Next Topic: Forms Installation Query
Goto Forum:
  


Current Time: Sun Dec 04 10:22:51 CST 2016

Total time taken to generate the page: 0.07274 seconds