|Can someone help me with the syntax for eliminating
|and then restoring the expression on a col.
|Alter table client alter categry ......?
|The expression is (sget(clno,1))
=========================================
to revert column client to a regular column ...
ALTER TABLE client ALTER COLUMN categry TO client TEXT (1)
to define column client as a computed column ...
ALTER TABLE client ALTER COLUMN categry = (sget(clno,1,1))
---------------------------------------------------------------------------
Eric M. Bienstock, Ph.D.
Database Development, etc.
Authorized R:BASE Developer
Eric M. Bienstock & Associates, Inc.
day: 212-978-7948 eve: 973-763-8650(8)
FAX: 775-254-2109 [EMAIL PROTECTED]
http://mywebpages.comcast.net/ericmb/
---------------------------------------------------------------------------
----- Original Message -----
From: Bernard Lis
To: [EMAIL PROTECTED]
Sent: Saturday, March 16, 2002 3:07 PM
Subject: syntax for alter command 6.6++ win
Can someone help me with the syntax for eliminating and then restoring the
expression on a col.
Alter table client alter categry ......?
The expression is (sget(clno,1))
Bernie Lis
Megabytes, Inc.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
