Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Tue, Nov 18 2008 5:32 AM	Permanent Link
"Al Vas"	Hi, Is it possible to update a field value that is an autoinc using SQL? DBISAM V3.30 Thanks Alex
Tue, Nov 18 2008 9:45 AM	Permanent Link
"Robert"	"Al Vas" <noreply@noreply.com> wrote in message news:AD6DE88D-D7FD-4A86-A580-3B40149EE2BE@news.elevatesoft.com... > Hi, > > Is it possible to update a field value that is an autoinc using SQL? > DBISAM V3.30 > Try it? most folks don't have 3.3 anymore. Robert
Tue, Nov 18 2008 1:42 PM	Permanent Link
"John Hay"	Alex > > Is it possible to update a field value that is an autoinc using SQL? DBISAM > V3.30 You need to use NOAUTOINC eg UPDATE Table SET Autoincfield=x WHERE Autoincfield=y NOAUTOINC. I think you get an error if you try to set it to an existing number. Cheers John
Tue, Nov 18 2008 2:42 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Alex, << Is it possible to update a field value that is an autoinc using SQL? DBISAM V3.30 >> Via SQL, or code ? If SQL, then see John's answer. -- Tim Young Elevate Software www.elevatesoft.com