I am looking at servoy as a potential frontend to a wages app. Data input of approx 200-300 records daily. Main form would be record view only. There is a number of calcs per form per record and these need to be saved to the database. Navigation would be by section then employee.
I thought I read there was an issue how servoy deals with calculations on forms
I asume servoy works with the connected data rather than disconnected data per dotnet?
I have already written something similar in vb.net but not happy with the flexibility and complexity.
Has anyone developed production apps for sql server?
I have read thru the manuals and it does not appear to have such a steep learning curve as dotnet .
I have setup my repositery on sql but before diving in I would be grateful
for any thoughts.
Hi Eric. We have developed and deployed one app under SQL Server and are in the process of building another. No issues to speak of. Make a reasoned choice about your primary keys, though (Servoy Sequence vs. DB Identity). If you’re not familiar with the pros and cons, check out the forum threads on the subject. Good luck!
Eric-- We used stored procedures, but not interactively with Servoy. This application had a Perl-driven web front end that called the stored procedures for various purposes, including record creation. We built the administrative GUI in Servoy. The fact that we needed to create records via web interaction led to our use of DB Identity for PK generation, rather than using Servoy Sequences for that purpose. FYI–it is possible to interact with stored procedures from within Servoy; we haven’t needed to do that yet.
Every time I complete the DBServers Preferences to connect to my existing MS SQL Server database, I get “Cannot Setup Server” with “error establishing socket”… I’m going a little crazy. The settings are correct – I’ve double checked that 12 ways. SQL Server is running on port 1433. I’ve tried connecting from both a second machine on my network and the server itself, both instances of Servoy give the same error in result.
I have port scanned the server and 1433 appears to be closed. I cannot find WHERE though on the Windows Server 2003 Standard Edition. The personal firewall in the network control panel is not turned on. I tried turning it on and opening 1433 – that didn’t work.
I use SQL Server every day with Servoy with no problems.
Here’s where you can check the settings:
Start Menu → All Programs → Microsoft SQL Server → Server Network Utility
Make sure TCP/IP is set on the RIGHT side
Click on TCP/IP on the right side - click the poperties button and make sure the default port is set to 1433
Open up Servoy
Go to Edit → Preferences → DB Servers
From the bottom pop-up menu “Auto Setup Server” in the dialog - choose “MS SQL”
Change the name of the connection to “test” (Server Name)
Put in sa and nothing (blank) for the username and password (should be the default)
ONLY CHANGE the <database_name> in the Database Server URL
Click OK
If you get out of the dialog successfully, then all is well. This assumes that SQL Server is running on your local machine. Make sure you start the database (so it shows up in your task bar with a green arrow) OR start up Enterprise Manager and connect to the local instance of SQL Server.
In the past I have used stored procedures for adding updating data etc in .net they have been bound to the underlying dataset and then passed as parameters to the stored procedures
Basically records are pulled out into dataset and added amended as needed then returned to sql server
How do I bind the results of a dataset or query to the individual fields/labels on a form.
I have been looking at the Database Manager and jsdataset