Re: D7 ADO + ACCESS
- From: "Claude" <livreplus@xxxxxxxx>
- Date: Thu, 5 Oct 2006 17:38:36 +0200
Thanks very much
regards
claude
"Viatcheslav V. Vassiliev" <support@xxxxxxxxxxxxxxx> a écrit dans le message
de news: 4524bfa0@xxxxxxxxxxxxxxxxxxxxxxxxx
Access places records at end of table. However SELECT without ORDER BY
does not always return rows as they are in table, usually rows are
returned according PK. If you need to return rows in SELECT as they were
inserted into table, create autoincrement PK and use ORDER BY.
//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"claude.lec" <cllec@xxxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:45241552@xxxxxxxxxxxxxxxxxxxxxxxxx
D7 ADO With access
Hi
Can someone tell me the way accesse adds the records.
In a dbase table, the records are put at the end of the file.
So if you I take the record nr 5 . If I add a new records in the table,
the records nr 5
doesn't move.
I notice by acces it doesn't work that way. If you have a records in
position 5 with say
"Loulou" in it, if you add a records "loulou" got in the 6th positioN.
Have someone an idea if I do something wrong?
laude
.
- References:
- D7 ADO + ACCESS
- From: claude.lec
- Re: D7 ADO + ACCESS
- From: Viatcheslav V. Vassiliev
- D7 ADO + ACCESS
- Prev by Date: Re: Programatically adding Fields to an existing Database (using SQL)
- Next by Date: Re: D7 ADO + ACCESS
- Previous by thread: Re: D7 ADO + ACCESS
- Next by thread: Re: D7 ADO + ACCESS
- Index(es):
Relevant Pages
|
