I use a lot of stored procedures and use COMMIT TRANSACTION a lot. It seems to work fine for me. You do know, after you commit, and then call a stored procedure, you have to RE-READ the record to get any changes.
Bruce
Search found 1476 matches
- Fri May 10, 2024 12:11 am
- Forum: General discussion and questions about Aware IM
- Topic: COMMIT TRANSACTION does not work?
- Replies: 2
- Views: 84
- Wed May 08, 2024 2:10 pm
- Forum: General discussion and questions about Aware IM
- Topic: Conference Talk on SQL and Aware
- Replies: 0
- Views: 43
Conference Talk on SQL and Aware
I have 2 sessions where I will share what I learned about using stored procedures with Aware. If you are attending do feel free to bring questions regarding slow aware processes where you would like to move the heavy lifting to SQL or just cases where you are not sure that using Aware for your appli...
- Tue May 07, 2024 7:55 pm
- Forum: General discussion and questions about Aware IM
- Topic: Conference Session - CSS
- Replies: 9
- Views: 327
Re: Conference Session - CSS
Ditto. I can't even spell "CSS". Always ready to fill my brain with more useful info.
Bruce
Bruce
- Tue Apr 23, 2024 9:04 pm
- Forum: General discussion and questions about Aware IM
- Topic: Error: This combination of host and port requires TLS when using Client Server
- Replies: 1
- Views: 382
Re: Error: This combination of host and port requires TLS when using Client Server
FYI, I switched to "Configurator over internet" and it works fine now.
Bruce
Bruce
- Mon Apr 22, 2024 10:59 pm
- Forum: General discussion and questions about Aware IM
- Topic: Error: This combination of host and port requires TLS when using Client Server
- Replies: 1
- Views: 382
Error: This combination of host and port requires TLS when using Client Server
Switch my Aware server to ssl on port 8443. I use the client / server configuration to remotely program aware and in my UIConfig.props file I have "webserver port=8443" However when I open a query I get a "bad request" with the above error and it does not display the query. So question is: how do I ...
- Wed Apr 10, 2024 3:40 pm
- Forum: General discussion and questions about Aware IM
- Topic: DISPLAY URL stopped working after adding SSL to Aware
- Replies: 1
- Views: 486
DISPLAY URL stopped working after adding SSL to Aware
So, I changed the server.xml file in tomcat so that Aware now runs SSL. All is good, except I have a lot of "DISPLAY URL" commands in processes and they just display a blank page. Works fine when I access aware through the normal non ssl port. Any suggestions?
Thanks
Bruce
Thanks
Bruce
- Mon Mar 18, 2024 7:56 pm
- Forum: General discussion and questions about Aware IM
- Topic: Configurator does not load most current version
- Replies: 5
- Views: 1790
Re: Configurator does not load most current version
How are you connecting to the server? RDP or Client Server mode or is it local?
I have had issues with client server occasionally but never RDP or local.
Bruce
I have had issues with client server occasionally but never RDP or local.
Bruce
- Fri Mar 15, 2024 5:59 pm
- Forum: Tips and Tricks
- Topic: Generic event handler for row operations working with records from Stored Procedure
- Replies: 7
- Views: 1562
Re: Generic event handler for row operations working with records from Stored Procedure
This is very nice and very useful. (Way above my pay grade, but I am pretty good at copy and paste).
Thanks for sharing.
Bruce
Thanks for sharing.
Bruce
- Fri Mar 15, 2024 5:53 pm
- Forum: General discussion and questions about Aware IM
- Topic: Can I "EXPORT DOCUMENT" to a folder on the Server
- Replies: 3
- Views: 1811
Re: Can I "EXPORT DOCUMENT" to a folder on the Server
Just to confirm. This can be a folder on the server, so if it points to c:\output then the reports will go to the SERVER C drive and not the Clients C Drive?
Bruce
Bruce
- Fri Mar 15, 2024 5:52 pm
- Forum: General discussion and questions about Aware IM
- Topic: Configurator does not load most current version
- Replies: 5
- Views: 1790
Re: Configurator does not load most current version
Just to confirm, when you are on the last build (59.11) and you right click and then select load, it does NOT load that version? I have not been able to duplicate that functionality.
Bruce
Bruce
- Fri Mar 15, 2024 5:50 pm
- Forum: General discussion and questions about Aware IM
- Topic: what is the URL to see all the versions
- Replies: 2
- Views: 1864
Re: what is the URL to see all the versions
thank you.
- Thu Mar 14, 2024 7:36 pm
- Forum: General discussion and questions about Aware IM
- Topic: what is the URL to see all the versions
- Replies: 2
- Views: 1864
what is the URL to see all the versions
I once knew it. but forgot. Want to see what the latest build is and any notes on it.
Thanks
Bruce
Thanks
Bruce
- Thu Mar 14, 2024 4:35 pm
- Forum: General discussion and questions about Aware IM
- Topic: Can I "EXPORT DOCUMENT" to a folder on the Server
- Replies: 3
- Views: 1811
Can I "EXPORT DOCUMENT" to a folder on the Server
It looks like I can give it a drive and folder i.e. "C:\output" But, without mapping a drive on the server, can I have a document exported to a folder on the server?
Thanks
Bruce
Thanks
Bruce
- Wed Mar 06, 2024 4:13 pm
- Forum: General discussion and questions about Aware IM
- Topic: There are 2 diff ways to use SSL with Tomcat. What is the difference
- Replies: 0
- Views: 4255
There are 2 diff ways to use SSL with Tomcat. What is the difference
OK, a lot more than 2 ways, but in the following code, the 1st one (that is NOT commented out) works and the other one does not. Can someone tell me if one is a more preferred way, or should I just be happy that it works. <!-- Define an SSL/TLS HTTP/1.1 Connector on port 8443 This connector uses the...
- Wed Mar 06, 2024 3:49 pm
- Forum: General discussion and questions about Aware IM
- Topic: Installing SSL on Window Server - Tomcat
- Replies: 2
- Views: 1595
Re: Installing SSL on Window Server - Tomcat
Thanks, my buddy google finally found a site that showed me how to just use the .CRT files. Think it is working.
Bruce
Bruce