Changing the Length of A Field...

Questions and answers regarding general SQL and backend databases

Changing the Length of A Field...

Postby Providence1 » Thu Feb 17, 2005 12:47 am

What's the best way to do this...

I have a field in my Sybase that I deleted in Developer and recreated with the same name but a longer length. I went from 50 to 5000.

When I upload my Solution to Server I get the standard warning about the field being of different lengths.

I tired going in on Sybase and changing it manually but that didin't work.

Is the best way to change this just to use a field in the same position while deleting the original, making sure the names are different?
Providence
Providence1
 
Posts: 456
Joined: Tue Aug 17, 2004 2:36 am
Location: New York, NY

Postby automazione » Thu Feb 17, 2005 1:05 am

Close developer and use sybase Central to change the field length. Should work...
Enrico Arata
Servoy Italia
automazione
 
Posts: 366
Joined: Thu Apr 24, 2003 11:37 am
Location: Torino, Italy

Postby Providence1 » Thu Feb 17, 2005 1:21 am

I did that. That's what I ment by Sybase. I should have said Sybase Central.

Any other suggestions?
Providence
Providence1
 
Posts: 456
Joined: Tue Aug 17, 2004 2:36 am
Location: New York, NY

Postby ROCLASI » Thu Feb 17, 2005 10:41 am

Did you restart Servoy Server after you changed the table with Sybase Central ?
Or else you won't see any change inside Servoy.
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium


Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 1 guest