Sync a Servoy sequence with database from Javascript code.

Discuss all feature requests you have for a new Servoy versions here. Make sure to be clear about what you want, provide an example and indicate how important the feature is for you

Sync a Servoy sequence with database from Javascript code.

Postby mxvanzant » Thu Dec 06, 2007 6:42 pm

Sometimes it is much more efficient to do multiple inserts into a table entirely on the database server, such as inserting from a select statement. But, if the insert table contains a Servoy managed sequence, this sequence must be synced with the now updated table's maximum value for that column. There appears to be no way to do this from Javascript code in Servoy. Maybe this can be a method added to the Database Manager?

Thanks!
Mike VanZant
mxvanzant@yahoo.com
vanzant@orangeloft.com
Orange Loft LLC
mxvanzant
 
Posts: 17
Joined: Fri Aug 24, 2007 5:33 pm
Location: Wheeling, IL (Chicago burb)

Postby patrick » Fri Dec 07, 2007 11:17 am

That could possibly result in a chaos if clients are connected, so I think you cannot expect that addition. In such a situation it is better to not use Servoy sequences. Servoy sequences can only be used (in my eyes) if you are 100% sure that your Servoy app is the only application inserting data...
Patrick Ruhsert
Servoy DACH
patrick
 
Posts: 3703
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany


Return to Discuss Feature Requests

Who is online

Users browsing this forum: No registered users and 16 guests

cron