Should have been
jerry
-----Original Message-----
From: ProFox [mailto:[email protected]] On Behalf Of jerry foote
Sent: Saturday, February 02, 2013 5:05 PM
To: 'ProFox Email List'
Subject: RE: implement auto increment
IN This example I have scattered the contents of my table to working and set
controlsource of my input boxes to thisform.working.........
IF MESSAGEBOX("Save Changes", 20)=6
SELECT (thisform.aliasis)
IF thisform.working.id>0
= SEEK(thisform.working.id, thisform.aliasis, "ID")
GATHER MEMO NAME thisform.working FIELDS EXCEPT Id
ELSE
APPEND BLANK
GATHER MEMO NAME thisform.working FIELDS EXCEPT Id
ENDIF
ELSE
GOTO thisform.current_record IN thisform.aliasis
ENDIF
SCATTER MEMO NAME thisform.working
Jerry
-----Original Message-----
From: ProFox [mailto:[email protected]] On Behalf Of Gary Jeurink
Sent: Saturday, February 02, 2013 1:13 PM
To: 'ProFox Email List'
Subject: implement auto increment
When I upgraded from vfp-6 to vfpr-9 I was looking forward to the auto
increment to generate the primary keys for many of my tables. I tried
changing the data type from integer to auto increment (no problem) but on my
forms my current INSERT INTO statement generates a duplicate primary key
violation.
I know it's something simple but I can't find an example how to do it.
Gary Jeurink
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/0DA109BF936149EA82AB45AF21824A41@jerryfootePC
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
