scatter name oName

[EzLogic]

i have a table, but, it has an IID autoinc value in it.

sele myTable
scatter name oName

oName.IID exists now, but, i do not want it.

what's the best way to drop it?



Ali Koumaiha
TeknoPCS Inc.
Dearborn heights, MI 48127

 

[DSummZZZ]

Try this:
REMOVEPROPERTY(oName, 'IID')

You can always add it later if you need it for reference:
ADDPROPERTY(oName, 'IID')



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[markros]

If you have a default function in your database, then you can try

oName.IID = NewID() && Custom function.

 

[Mike Lewis]

Another option:

SET FIELDS TO <every field except the ID>
SCATTER NAME ... etc.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[Mike Lewis]

Or, better still:

SCATTER FIELDS EXCEPT ID NAME ... etc.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[EzLogic]

thanks guys!



Ali Koumaiha
TeknoPCS Inc.
Dearborn heights, MI 48127