Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from his
foreign key (Order.OrderNo) ?
Thanks.
6  1164 
"Seth Bourne" <se*****@yahoo.comwrote in message
news:uc**************@TK2MSFTNGP03.phx.gbl...
Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from
his foreign key (Order.OrderNo) ?
Thanks.
Sort your sytem clock out. Moving it ahead 24 hours is likely to result in
people avoiding providing help. All you are doing in effect is "queue
jumping".
Yep i am sick of these people with 'wrong clocks' only way we will get you
guys to learn is to not help until your clock is sorted.
"Seth Bourne" <se*****@yahoo.comwrote in message
news:uc**************@TK2MSFTNGP03.phx.gbl...
Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from
his foreign key (Order.OrderNo) ?
Thanks.
really sorry guys.. there's a problem with my clock...
"Daniel" <Da*****@vestryonline.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Yep i am sick of these people with 'wrong clocks' only way we will get you
guys to learn is to not help until your clock is sorted.
"Seth Bourne" <se*****@yahoo.comwrote in message
news:uc**************@TK2MSFTNGP03.phx.gbl...
>Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from
his foreign key (Order.OrderNo) ?
Thanks.
really sorry guys.. there's a problem with my clock...
"Daniel" <Da*****@vestryonline.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Yep i am sick of these people with 'wrong clocks' only way we will get you
guys to learn is to not help until your clock is sorted.
"Seth Bourne" <se*****@yahoo.comwrote in message
news:uc**************@TK2MSFTNGP03.phx.gbl...
>Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from
his foreign key (Order.OrderNo) ?
Thanks.
not the case here, but there's always the chance he's in australia, then his
date (not time) would have been correct
anyhow, take a look at working with data in asp.net 2.0 on the asp.net site
"Daniel" <Da*****@vestryonline.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
Yep i am sick of these people with 'wrong clocks' only way we will get you
guys to learn is to not help until your clock is sorted.
"Seth Bourne" <se*****@yahoo.comwrote in message
news:uc**************@TK2MSFTNGP03.phx.gbl...
>Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible that
the value of orderNo (from orderDetail table) insert automatically from
his foreign key (Order.OrderNo) ?
Thanks.
You would never have to worry about your closk if you used SNTP to set the
clock time. SNTP stands for "Simple Network Time Protocol," and it allows
computers on the Internet to synchronize via SNTP servers across the world,
of which there are many. Support for SNTP is built into Windows. See: http://www.ntp.org/ntpfaq/NTP-s-def.htm
--
HTH,
Kevin Spencer
Microsoft MVP
Bit Player http://unclechutney.blogspot.com
Expect the unaccepted.
"Seth Bourne" <se*****@yahoo.comwrote in message
news:et**************@TK2MSFTNGP04.phx.gbl...
really sorry guys.. there's a problem with my clock...
"Daniel" <Da*****@vestryonline.comwrote in message
news:%2****************@TK2MSFTNGP02.phx.gbl...
>Yep i am sick of these people with 'wrong clocks' only way we will get
you guys to learn is to not help until your clock is sorted.
"Seth Bourne" <se*****@yahoo.comwrote in message
news:uc**************@TK2MSFTNGP03.phx.gbl...
>>Lets say i've 2 table. Order and OrderDetail.
Order table is contain OrderNo(PK), OrderName.
orderDetail contain orderDetailID(PK), OrderNo(FK), item and qty.
and i had finish related the two of table in dataset. Is it possible
that the value of orderNo (from orderDetail table) insert automatically
from his foreign key (Order.OrderNo) ?
Thanks.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Terrence Brannon |
last post by:
I don't know what Postgres considers a relation and had no intention of
creating one when piping my schema to it... I always DROP TABLE before
CREATE TABLE, so here are the ERRORS emitted when...
|
by: Sharon |
last post by:
I have two tables in the DataSet, the first present rooms and the other
furniture kinds.
Furniture kind, like chare, can be in more then one room. And specific room
can contain more then one...
|
by: Wayne Brantley |
last post by:
I have found what appears to be an error in streaming with Datasets. It
causes an error of 'Cannot find relation 0' when recreating the dataset from
a stream.
Here is how you reproduce it.
...
|
by: jaYPee |
last post by:
I have tried almost everything I know but still I can't find a way on
how to resolve this problem.
I'm using ImportRow to copy some record from 1 table to another table.
Here are my code that...
|
by: Juris Krumins |
last post by:
I have a problem with postgresql tables. periodicaly, I would say
frequently about 5-10 time per hour i have such errors in my server log
file:
2004-04-14 12:23:32 ERROR: cache lookup of...
|
by: brookhartc |
last post by:
I am working on a program where I am retrieving data from an Access
database through one common dataset. I have already put the database
connection component on the form as well as the two data...
|
by: Ambica Jain |
last post by:
I have a data grid called Files, which has some columns like FileName, Col1,
Col2, ... , Col8. Then i have a combobox which allows user to select from
Col1 to Col8 and based on this selection, i...
|
by: Ginger Estherskip |
last post by:
I'm setting up a dataset using the GUI to have a Parent Data Table and a few
Child Data Tables.
I then have a form that uses that dataset, and I can fill the appropriate
datatables et. al., but...
|
by: bugboy |
last post by:
I'm inserting a new word into table 'w' and a definition into table 'c' which are linked in table 's' which is the relation table for the many to many relationship between 'w' and 'c'.
I've been...
|
by: Miro |
last post by:
VS2008
I have created 3 tables.
Vendors
Customers
PhoneNumbers
each have their own key
Vendor has: VendorID - int unique identifier
Customer has: CustomerID - int unique identifier
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
