Our applications connect to both Sqlbase and Sqlserver. We use Timestamp as the rowid.
The only difficulty is that the Decode is a Case and has to be provided for in the TD code. Also the Choose & Find functions require a function written in Sqlserver.
Everything else works with a substitute.
;substitute=not null with default,DEFAULT '0' NOT NULL
;substitute=NOT NULL WITH DEFAULT,DEFAULT '0' NOT NULL
substitute=not null with default,NOT NULL DEFAULT '0'
substitute=NOT NULL WITH DEFAULT,NOT NULL DEFAULT '0'
- Site Admin
- Posts: 289
- Joined: 05 Mar 2017, 20:57
- Location: Tauranga, New Zealand <--> Stroud, England
+1000.Igor Ivanovic wrote:.....The support is really great, I was helped out although sometimes it was not even directly related to OT Gupta products.
Worth every cent I invested in OT Gupta.
ditto. SQLServer is ok, but no way the panecea.Igor Ivanovic wrote:.....SQLServer as I was forced once to use it and for me it was a nightmare being used to work with SQLBase.
Agree ++. Unsure what's classed as 'huge', but we running a 165Gb SQLBase dB - no issues. Some tables/indexes >5m rows, with no ( not many ) dramas. Maybe UNLOAD takes a while thoughFRBhote wrote:.....If the database is not huge it makes no sense to change from Sqlbase..
Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand
But if I have a product that I want to sell for about 2,000 EUR, I have to add about 1,300 EUR for SQLBase if I need more than one user access at the same time. This makes the product unattractive.
Therefore the question about another SQL database, which is suitable for us in small installations (2-5 users). GLS or not, in our case we have all the business logic in the application: no triggers, no stored procedures, no nothing! We only store data and that's it. Unfortunately, this is where the RowId gets in the way, because we use it extensively.
As soon as we have some more time, we will convert the databases to MySQL and/or SQLServer.
Translated with www.DeepL.com/Translator (free version)
Who is online
Users browsing this forum: [Ccbot] and 0 guests