Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
466
Web Server - Share Knowledge / Re: MS Sql HSTMT Connection Busy Errors
« on: September 06, 2010, 04:36:34 AM »
Thanks Kevin.
467
Web Server - Share Knowledge / Re: MS Sql HSTMT Connection Busy Errors
« on: September 05, 2010, 11:04:41 PM »
Kev,
Ahhh, thought you meant the SQL Server side.
Yeah, I've been adding routines to remove the files on cancelling of the form. Also have a function that runs on program startup which removes all blank records.
Ahhh, thought you meant the SQL Server side.
Yeah, I've been adding routines to remove the files on cancelling of the form. Also have a function that runs on program startup which removes all blank records.
468
Web Server - Share Knowledge / Re: MS Sql HSTMT Connection Busy Errors
« on: September 05, 2010, 09:11:22 PM »
Kev,
Good call. I haven't moved any of that to the Server. Might be a good place to start.
Got any initial tips for moving cascading of delete to SQL server?
Good call. I haven't moved any of that to the Server. Might be a good place to start.
Got any initial tips for moving cascading of delete to SQL server?
469
Web Server - Share Knowledge / Re: MS Sql HSTMT Connection Busy Errors
« on: September 05, 2010, 04:22:06 PM »
I have implemented the FM3 Connect string, and put the same driver string into all files in the dictionary.
In my webserver I have a form for say CONTACT. On the form I have a child browse for CONTACT_ATTRIBUTES, which has a "Cascade on Delete" relationship with CONTACT.
I pre-populate the CONTACT_ATTRIBUTES file on Insert with say 20 records.
On Cancel, I get the following error:
[attachment deleted by admin]
In my webserver I have a form for say CONTACT. On the form I have a child browse for CONTACT_ATTRIBUTES, which has a "Cascade on Delete" relationship with CONTACT.
I pre-populate the CONTACT_ATTRIBUTES file on Insert with say 20 records.
On Cancel, I get the following error:
[attachment deleted by admin]
470
Web Server - Share Knowledge / Re: MS Sql HSTMT Connection Busy Errors
« on: September 03, 2010, 10:02:44 PM »
Does this logic still apply for Clarion 7 + FM3 + MSSQL 2005?
* Also, if you put the MULTIPLE.. line into the FM3 Connect String, should you still set each file in your dictionary (in Clarion 7) with the MARS option?
* Also, if you put the MULTIPLE.. line into the FM3 Connect String, should you still set each file in your dictionary (in Clarion 7) with the MARS option?
471
Web Server - Ask For Help / Re: Bad data sent to NetWebserverworker
« on: July 27, 2010, 05:05:35 PM »
Terry,
Bruce knows about it (cause I logged it with him a few days ago <g>).
Stu
Bruce knows about it (cause I logged it with him a few days ago <g>).
Stu
472
Web Server - Ask For Help / Re: Auto Inc record remains after insertion is cancelled
« on: February 01, 2010, 04:30:09 PM »
Hey hey.
In my experience, it's usually something to do with a couple of checkboxes in the Form.
In the "Advanced" tab (snagit'd an image, but didn't realise i couldn't upload it here), there are the two flags, "Prime Auto Inc if necessary", and "Prime Auto Inc even if not necessary".
Check those two. If you want absolutely no priming, uncheck them. Although if you use the ID field for anything within the form, you'll want it primed.
Cheers,
Stu Andrews
http://stuandrews.com
In my experience, it's usually something to do with a couple of checkboxes in the Form.
In the "Advanced" tab (snagit'd an image, but didn't realise i couldn't upload it here), there are the two flags, "Prime Auto Inc if necessary", and "Prime Auto Inc even if not necessary".
Check those two. If you want absolutely no priming, uncheck them. Although if you use the ID field for anything within the form, you'll want it primed.
Cheers,
Stu Andrews
http://stuandrews.com
473
Available For Hire / NTWS Guru, You Probably Should Hire Me
« on: July 08, 2009, 01:01:51 AM »
G'day Folks.
If you need Nettalk Webserver work done, please contact me.
I have worked on many small and large Nettalk Webserver systems.
I am an excellent "Fix It" developer, and can implement solutions with speed and care.
Please email me, or head over to http://stuandrews.com for further Contact information.
Cheers,
Stu Andrews
stu (dot) andrews (at) codebiscuit (dot) com
If you need Nettalk Webserver work done, please contact me.
I have worked on many small and large Nettalk Webserver systems.
I am an excellent "Fix It" developer, and can implement solutions with speed and care.
Please email me, or head over to http://stuandrews.com for further Contact information.
Cheers,
Stu Andrews
stu (dot) andrews (at) codebiscuit (dot) com
474
Web Server - Share Knowledge / NTWS Guru For Contract Hire
« on: June 11, 2009, 06:09:45 AM »
G'day Folks.
If you need Nettalk Webserver work done, please contact me.
I have worked on many small and large Nettalk Webserver systems.
I am an excellent "Fix It" developer, and can implement solutions with speed and care.
Please email me, or head over to http://stuandrews.com for further Contact information.
Cheers,
Stu Andrews
stu (dot) andrews (at) codebiscuit (dot) com
If you need Nettalk Webserver work done, please contact me.
I have worked on many small and large Nettalk Webserver systems.
I am an excellent "Fix It" developer, and can implement solutions with speed and care.
Please email me, or head over to http://stuandrews.com for further Contact information.
Cheers,
Stu Andrews
stu (dot) andrews (at) codebiscuit (dot) com
475
Web Server - Share Knowledge / Re: Example website created with Clarion/NetTalk/ExtJS
« on: September 23, 2008, 11:25:48 PM »
Patrick,
Been a fan of Ext for a while now, sounds like some great ideas you've got.
Taking a look at the site now.
Stu
Been a fan of Ext for a while now, sounds like some great ideas you've got.
Taking a look at the site now.
Stu
476
Web Server - Ask For Help / Re: Delete link in browse - how?
« on: April 20, 2008, 02:16:35 PM »
Bill!
Awesome to see you on here. Nice posts, good to have your super brain helping people out
.
Stu
Awesome to see you on here. Nice posts, good to have your super brain helping people out
.Stu
477
Web Server - Ask For Help / Re: Delete link in browse - how?
« on: April 20, 2008, 02:12:15 PM »
Nice suggestions Mike. I like them.
Bruce, I'll put my hand up to have links as an option to switch over too. But buttons default.
Stu
Bruce, I'll put my hand up to have links as an option to switch over too. But buttons default.
Stu
478
Web Server - Ask For Help / Re: Regression testing volunteers for version 4.31 wanted
« on: April 16, 2008, 04:45:37 AM »
Bam. I'm in. Now. Send. Now. Do it.
Do it.
Now.
Do it.
Now.
479
Web Server - Ask For Help / Re: Email from a browse using it's data
« on: March 25, 2008, 01:12:56 PM »
Gregg,
In my brain, it's kind of similar to how you'd go about the same problem in a desktop app. You've got an ID (from the browse queue), you need fields from the record, so do a Fetch (get) to retrieve the record (thus those fields), then call the Send Email function/proc. This is all done from "an embed" somewhere around the place. The somewhere would most probably be when you "Send new value to server" on the button click .. Bruce would know that better.
Cheers,
Stu
In my brain, it's kind of similar to how you'd go about the same problem in a desktop app. You've got an ID (from the browse queue), you need fields from the record, so do a Fetch (get) to retrieve the record (thus those fields), then call the Send Email function/proc. This is all done from "an embed" somewhere around the place. The somewhere would most probably be when you "Send new value to server" on the button click .. Bruce would know that better.
Cheers,
Stu
480
Web Server - Ask For Help / Re: Email from a browse using it's data
« on: March 24, 2008, 01:11:28 PM »
Gregg,
Sorry, I'm a little slow .. can you clarify a couple of things?
1. Are you calling the SendMail function from the Form?
2. Is the Subject the key field for retrieving the Email record?
If these are YES with gusto, then I'd just be retrieving the record before calling the SendMail function. But I suspect I'm missing something in your question.
You've got a browse with a bunch of emails in it, and you want to "Send" the selected record in the browse, right?
Sorry, I'm a little slow
.. can you clarify a couple of things?1. Are you calling the SendMail function from the Form?
2. Is the Subject the key field for retrieving the Email record?
If these are YES with gusto, then I'd just be retrieving the record before calling the SendMail function. But I suspect I'm missing something in your question.
You've got a browse with a bunch of emails in it, and you want to "Send" the selected record in the browse, right?