 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Eric
Guest
|
 Posted: Tue Dec 30, 2003 12:37 am Post subject: MySql |
 |
|
Hi,
I know it 's SQL server but I don't know where I can retrieve informations
for MYSQL.. Maybe someone knows?
Here my problem:
I have a problem with a primary autoinc field in a MySql table... The
value generated by the server never come back to my query until I close it.
Thank you very much
|
|
| Back to top |
|
 |
Vell
Guest
|
| Posted: Tue Dec 30, 2003 6:26 am Post subject: Re: MySql |
|
|
I did not get what you want to say.
About MySQL maybe better ask You question at mysql mailing lists
heres one:
[email]win32 (AT) lists (DOT) mysql.com[/email]
"Eric" <edumont (AT) pelluc (DOT) com> wrote
| Quote: | Hi,
I know it 's SQL server but I don't know where I can retrieve
informations
for MYSQL.. Maybe someone knows?
Here my problem:
I have a problem with a primary autoinc field in a MySql table... The
value generated by the server never come back to my query until I close
it.
Thank you very much
|
|
|
| Back to top |
|
|
Rick van Dijk
Guest
|
| Posted: Tue Dec 30, 2003 10:01 am Post subject: Re: MySql |
|
|
Another good MySQL discussion place is the forum at tek-tips.com:
http://www.tek-tips.com/threadminder.cfm?spid=436&newpid=436
--
Rick van Dijk
Datanamic Solutions BV
http://www.datanamic.com : DeZign, easy-to use database design tool
"Eric" <edumont (AT) pelluc (DOT) com> schreef in bericht
news:3ff0c909$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Hi,
I know it 's SQL server but I don't know where I can retrieve
informations
for MYSQL.. Maybe someone knows?
Here my problem:
I have a problem with a primary autoinc field in a MySql table... The
value generated by the server never come back to my query until I close
it.
Thank you very much
|
|
|
| Back to top |
|
|
Tony J Hopkinson
Guest
|
| Posted: Tue Dec 30, 2003 9:55 pm Post subject: Re: MySql |
|
|
On Mon, 29 Dec 2003 19:37:44 -0500, "Eric" <edumont (AT) pelluc (DOT) com> wrote:
| Quote: | Hi,
I know it 's SQL server but I don't know where I can retrieve informations
for MYSQL.. Maybe someone knows?
Here my problem:
I have a problem with a primary autoinc field in a MySql table... The
value generated by the server never come back to my query until I close it.
Thank you very much
www.mysql.com is a good place to start. |
As for your autoinc primary key, it won't be created until the the
insert is executed on the server and then requeried.
if you are opening a query, going into edit mode and then posting it,
you won't get the data back until you execute the query again, given
that the record just inserted would be returned by the query in the
first place.
IMHO, you should only use an autoinc key to maintain a PK in a table
when and only when you never ever ever ever want to know what it is.
Ever DBMS implements them differently, they cause the sort of
nightmare you are having on a regular basis. They also mess you up
cursor wise.
I always code round this.
e.g. If say order number is generated automatically. I have a table
with next or last order number used in it. pick it up add 1 and put it
back. then create the order in the orders table. I'll admit that if
the next order number value goes tit's up, you'll have a problem, but
it's tried trusted, and while not foolproof it's definitely vendor
proof.
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
