473,799 Members | 2,885 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem of copying records

Rex
In a table, I have number of records belonging to a particular ID now
if I enter a value in one of the fileds of this table I want it to be
copied in all the records belonging to this particluar ID. for example

ID Name
--------------------------
1 xyz
1
1
1
2
2
2
When I enter "xyz" for any one of the record of ID# 1.. I want all the
other records (with ID# 1) to have the name field as "xyz" so after
this.. the table would look like this

ID Name
--------------------------
1 xyz
1 xyz
1 xyz
1 xyz
2
2
2

I know this is not possible in table itself.. However I presume it
would be possible to do this in a form. But I dont know HOW

cheers
Rex

Oct 5 '06
38 1816
"Granny Spitz via AccessMonster.c om" <u26473@uwewrot e in
news:676fd89644 923@uwe:
David's not interested in anything I have to say. I won't be getting
a second chance.
Your posts give good advice. There's no need to be modest about them.

David seldom takes advice, so from the point of view of being helpful his
plonking you or anyone else is irrelevant.

I think we have exhausted the usefulness of this thread and should let it
fade away. I plan to do so.

--
Lyle Fairfield
Oct 8 '06 #31
Lyle Fairfield wrote:
Your posts give good advice. There's no need to be modest about them.
The advice I give is at a different level than David's on. He doesn't need
it. It's the discussions between CDMA posters that are valuable, so cutting
off communication between certain posters cuts off some of the exchange of
ideas and points of view.
I think we have exhausted the usefulness of this thread and should let it
fade away. I plan to do so.
Very wise.

--
Message posted via http://www.accessmonster.com

Oct 8 '06 #32
"Larry Linson" <bo*****@localh ost.notwrote in
news:7IYVg.401$ Gp4.5@trnddc08:
"Granny Spitz via AccessMonster.c om" wrote
LOL! Thank you, Lyle! You made my day!

You two DO know that you are taking all the sting that David
intended right out of his <PLONK>, don't you? :-) Why, you seem
to be having fun with it!
How could they be accomplishing that if I've plonked both of them,
and won't be seeing their posts?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 8 '06 #33
"Larry Linson" <bo*****@localh ost.notwrote in
news:MnZVg.709$ i84.85@trnddc01 :
"Lyle Fairfield" <ly***********@ aim.comwrote in message
news:11******** ************@i3 g2000cwc.google groups.com...
>Granny Spitz via AccessMonster.c om wrote:
>>Yes indeed! But David will never know what's going on. He's
plonked us both.

Of course, he won't. Suggesting that he does know or will know
would imply that he uses <PLONK!only for effect, to demonstrate
his capacity for incisive action. I'm sure David is much too
genuine for that, and I should know. After all he's plonked me
several times ... hmmmm ... ?
When people quote you, Lyle, I see your posts.
Ah, ha! Term-limited plonks?
My newsreader allows me to set my kill settings for a limited number
of days (the default is 30) or permanently. Lyle and Granny are
permanent members of my killfile. I'll occasionally retrieve one of
Lyle's posts and reply to it when he says something interesting that
is quoted by someone else.

The reason for the time-limited plonk is that it allows one to cool
off for a while, and to give someone a second chance.

I generally don't use it, since I don't plonk people until they've
shown themselves to be completely impossible.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 8 '06 #34
David W. Fenton wrote:
"Larry Linson" <bo*****@localh ost.notwrote in
news:7IYVg.401$ Gp4.5@trnddc08:
"Granny Spitz via AccessMonster.c om" wrote
LOL! Thank you, Lyle! You made my day!
You two DO know that you are taking all the sting that David
intended right out of his <PLONK>, don't you? :-) Why, you seem
to be having fun with it!

How could they be accomplishing that if I've plonked both of them,
and won't be seeing their posts?
It's really too bad if you don't get the chance to show how vulnerable
DiscountAsp.Net SQL Hosting is. I know you won't see this but maybe
some one will alert you to the opportunity.

Oct 8 '06 #35
"David W. Fenton" wrote
How could they be accomplishing that
if I've plonked both of them, and won't
be seeing their posts?
But, now that you know they are having fun with it, actually enjoying it.
IMNSHO, that, in itself, diminishes the value of a PLONKing. Even though a
PLONK is primarily for protecting the plonker from seeing posts; it's also a
"statement" to the plonkee.

Maybe you should take a look at Lyle's responses to the same post I
referenced here, as he's talking about your opportunity to demonstrate the
vulnerability of that website. I don't "have a dog in that fight," but,
well, I thought this was a rather interesting thread for a while.

Larry

Oct 8 '06 #36

"David W. Fenton" <XX*******@dfen ton.com.invalid schreef in bericht news:Xn******** *************** ***********@127 .0.0.1...

I generally don't use it, since I don't plonk people until they've
shown themselves to be completely impossible.
Sometimes you are just plain wrong in your judgement.
But I guess you plonk yourself also once in a while ??

Arno R
Oct 8 '06 #37
David W. Fenton wrote:
LOL! Thank you, Lyle! You made my day!

You two DO know that you are taking all the sting that David
intended right out of his <PLONK>, don't you? :-) Why, you seem
to be having fun with it!

How could they be accomplishing that if I've plonked both of them,
and won't be seeing their posts?
Does that mean Lyle can't laugh behind David's back, because David won't
*see* him laughing? Does that rule apply to everybody, even to Canadians?

--
Message posted via http://www.accessmonster.com

Oct 8 '06 #38
"Granny Spitz via AccessMonster.c om" wrote
David W. Fenton wrote:
>LOL! Thank you, Lyle! You made my day!

You two DO know that you are taking all the sting that David
intended right out of his <PLONK>, don't you? :-) Why, you seem
to be having fun with it!

How could they be accomplishing that if I've plonked both of them,
and won't be seeing their posts?

Does that mean Lyle can't laugh behind David's back, because David won't
*see* him laughing? Does that rule apply to everybody, even to
Canadians?

"If a tree laughs in the woods, and nobody hears it, did it make any sound?"

I can't think of another answer to this question that isn't likely to get me
added to somebody's "bad list." :-)

Larry
Oct 8 '06 #39

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
2841
by: Google Mike | last post by:
I have RH9 and am using the PHP and MySQL that came with it. I was doing fine with all manner of my web pages for this app until I started having this very strange problem. It's a work order mgmt system. I have 3 tables for the orders: TicketsOpen, TicketsVoided, and TicketsResolved. When one wants to void a ticket, they click it, choose Void, and it is copied to the TicketsVoided table, then removed from the TicketsOpen. And I can...
9
1503
by: Zoo Keeper | last post by:
For some reason, the Python preprocessing balks on the "\" line continuation character. Any ideas/thoughts? Is it just that my version of gcc is not supported? I don't "need" numeric in my current project, but it is a nice package to have! Apps that do not need to be compiled install and run fine. Actually, SQLite built and installed fine... Thanks, in advance.
6
683
by: Club-B42 | last post by:
i've compiled my programm using command "python setup.py py2exe >1" python script works fine, but .exe version fails with ===================================================================== D:\\Scripts\B-4-2\la2luncher\dist>la2launcher.exe Traceback (most recent call last): File "la2launcher.py", line 9, in ? File "config.pyc", line 11, in ? File "config.pyc", line 8, in u LookupError: no codec search functions registered: can't find...
3
2669
by: Jason | last post by:
In enterprise manager I am copying a table from one database to another. I am using the dts wizard to import the data. After I successfully import the data, I open both tables to compare the records to make sure they are the same. I right click on a field and click "last" for both tables. However, the record is different for both. If I do a query the record is still there but they do not show up in the same order. Why does'nt the...
2
2078
by: Vince | last post by:
I have a very specific problem to solve but I cannot find a data structure for it. I don't know if I am posting on the good newsgroup but I cannot find a software.design group. I would like to declare a smart structure initialized via a XML file. The goal of this structure is to store data from a smart card. My XML file describes the file structure of my smart card. On a smart card file are identified by number(sfid) and not by their...
5
2470
by: Nathan Sokalski | last post by:
I am writing an ASP.NET application in which I need to copy DataRows from one DataTable to another. When I use code such as the following: temprows = nodes.Select("state='PA'") temptable.Clear() For Each row As DataRow In temprows temptable.Rows.Add(row) Next
8
2066
by: Howard, Steven | last post by:
I have created a web app that stores and displays all the messages from my database maintenance jobs that run each night. The web app uses Java servlets and has PostgreSQL 7.0 as the back end. When the user requests the first page, he gets a list of all the servers with maintenance records in the database, and a drop down list of all the dates of maintenance records. If the user chooses a date first, then the app uses a prepared...
2
1596
by: Neil | last post by:
I'm using Access 2000 with a SQL 7 back end. I recently implemented some code in a form's AfterUpdate event which calls a stored procedure which copies the contents of the current record to a history table. The code works fine when the user edits and saves the record. However, if the user performs a Find and Replace, the code hangs. At first I thought the code was hanging because of multiple records being replaced. But when I debugged...
1
1557
by: Jan | last post by:
Hi: I've been tearing my hair out over this one for a few days; did a search of the archives and found similar questions but no real answers. Here goes: This is an application for a retail store. There are transactions, transaction details, and then, depending on the type of detail, related records in other tables. So when I'm entering a new transaction, I open a new form (dialog mode) in which additional detail is entered. I need...
0
9685
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9538
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10249
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10219
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10025
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6804
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5584
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4138
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2937
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.