O$ ALTER TABLE OMNIS SQL

[Fred Brinkman]

same here...


Fred Brinkman
http://www.euromnis.org

**********************************************
Fred Brinkman Consultancy
B-1000 Brussels

Tel. +32-474-83 80 80
Fax +32-2-330 10 31 (on request)
mailto:fred.brinkman at euromnis.org
*********************************************








Op 21 apr 2009, om 17:16 heeft Keith Bartlett het volgende geschreven:

> Hi
>
> On 21 Apr 2009, at 14:47, sethpaien wrote:
>
>> Hi all,
>>
>> We would like to do an ALTER TABLE using OMNIS SQL DAM connecting  
>> to a DF1
>> File, but without success.
>>
>> Dealing with Omnis documentation, ALTER TABLE can not do anything  
>> but ADD
>> field at the end of table, and with SQL Browser it's the same  
>> problem...
>>
>> Does any one use OMNIS SQL DAM ? and if so, how do you alter table  
>> when
>> needed ? (Change data type, len of a VARCHAR or the name of a field).
>
> We make changes like that to the file itself, then regenerate the  
> schema from the file definition.
>
> Cheers
> Keith
>
> Keith Bartlett
> Adnet Ltd - (0)1491 642133
> www.adnetltd.co.uk
>
>
> This message contains information from Adnet Ltd which may be  
> privileged or confidential.  If you are not the intended recipient  
> be aware that any disclosure, copying, distribution or use of the  
> contents of this mail isprohibited.  If you have received this  
> message in error, please notify usimmediately and then delete this  
> mail from your system.
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com