Insert into 'Coffee_Pot' (Scoops) values ('5 large scoops') where
(cval('Computer')) = 'Paul D' and To_Early = '.#now'
Sincerely,
Paul D.
At 10:15 AM 3/30/2010, you wrote:
>Is there an issue using column names that begin with numbers?
>
>e.g:
>
>204lastsent
>204ver
>220recd
>220ver
>
>Thanks in advance.
Hello Emmitt,
Valid column names must start with an alpha character
and can include the following:
. Letters (A-Z)
. Numbers (0-9)
. # (pound sign)
. _ (underscore)
. $ (dollar sign)
. % (percent sign)
For ODBC compliance, it is not recommended to use the
# (pound sign) symbol in a column name even though
R:BASE permits it.
Spaces are NOT permitted.
In R:BASE 7.6 and eXtreme 9.0 (32) a 1 to 18 character
alpha-numeric name for the column can be specified.
For R:BASE Turbo V-8 and eXtreme 9.0 (64), a 1 to 128
character alpha-numeric name can be specified.
John