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.
76
Web Server - Ask For Help / Still battling with SQL identity fields...and loosing
« on: March 05, 2009, 04:02:59 AM »
I have a NetWebForm that updates records in my Jobs table. My jobs table has a child browse showing related records in my JobParcels table. These tables are related using a JOBID field in each table. JOBID in the jobs table is an Identity field. My dictionary is set so that my table has the EmulateAutoNumKey option set to true, and my JOBID field has AutoNumber = 1,1, and IsIdentity = 1
For debugging purposes I'm displaying my JOBID in my form. If I tick the Prime Auto Inc if necessary box my JOBID field DOESN'T get primed, and any child records that I add to JobParcels are orphaned as you would expect. If I tick the Prime Auto Inc even if not necessary, my JOBID is primed, and I can sucessfully add related child records, fantastic
Now the bad news, if I leave the Prime Auto Inc even if not necessary box ticked, and I get any kind of validation errors occuring on the form, reminding me to enter a mandatory field, etc. I can't save the job, because I get Duplicate Key error at the top of my form
Has anybody managed to get this to work, or is it just me doing something silly? This is driving me mad.
I'm using Clarion 6.3 9059 with NetTalk 4.31 PR 32 and MSSQL 2005.
TIA
Neil Porter
For debugging purposes I'm displaying my JOBID in my form. If I tick the Prime Auto Inc if necessary box my JOBID field DOESN'T get primed, and any child records that I add to JobParcels are orphaned as you would expect. If I tick the Prime Auto Inc even if not necessary, my JOBID is primed, and I can sucessfully add related child records, fantastic
Now the bad news, if I leave the Prime Auto Inc even if not necessary box ticked, and I get any kind of validation errors occuring on the form, reminding me to enter a mandatory field, etc. I can't save the job, because I get Duplicate Key error at the top of my form
Has anybody managed to get this to work, or is it just me doing something silly? This is driving me mad.
I'm using Clarion 6.3 9059 with NetTalk 4.31 PR 32 and MSSQL 2005.
TIA
Neil Porter
77
Web Server - Ask For Help / Re: Display an Image from a blob
« on: January 28, 2009, 12:51:31 AM »
Thanks Bruce, that also solves another problem for me aswell.
78
Web Server - Ask For Help / Re: Volunteers Needed to run Test
« on: January 27, 2009, 02:00:24 AM »
Happy to help.
Regards,
Neil.
Regards,
Neil.
79
Web Server - Ask For Help / Priming MSSQL Identity field
« on: January 26, 2009, 06:09:18 AM »
I have a netwebform that I'm using to update records from an MSSQL table called "Jobs".
I have a tab that contains a browse showing child records from a table called "JobParcels"
For some reason I have never been able to get the suggested Clarion 6.3 way of getting the parent identity field value to work, even though I have a table option of EmulateAutoNumKey = True and AutoNumber = 1,1 and IsIdentity = True set against my Identity field in my clarion dictionary.
Becasue I need to prime my child records, I managed to use Geoff Bomford's GWBInsert template, that I use in many other applications. I had to make a few small tweeks to the netwebform to make it work, adding the following code to the PreInsert2 embed:
! Set UpdateJobs:Primed to 1 so that we prevent duplicate checking.
p_web.SetSessionValue('UpdateJobs:Primed',1)
p_web.setsessionvalue('showtab_UpdateJobs',0)
This has been working great until I upgraded my template to 4.31 at the start of this month. Now when I save my charges, my original record is saved as nulls (together with the related child records) and I get a new record inserted in the parent table with all of my keyed values assigned to it.
The wierd thing is, that if I put my template back to 4.30, and recompile (and update my web subfolder) it still doesn't work anymore
I've got 2 production sites where this works absolutely fine, but I now can't recreate it.
Does anyone have any suggestions as to where I might be going wrong. I've been going round in circles now for days.
Regards,
Neil Porter.
I have a tab that contains a browse showing child records from a table called "JobParcels"
For some reason I have never been able to get the suggested Clarion 6.3 way of getting the parent identity field value to work, even though I have a table option of EmulateAutoNumKey = True and AutoNumber = 1,1 and IsIdentity = True set against my Identity field in my clarion dictionary.
Becasue I need to prime my child records, I managed to use Geoff Bomford's GWBInsert template, that I use in many other applications. I had to make a few small tweeks to the netwebform to make it work, adding the following code to the PreInsert2 embed:
! Set UpdateJobs:Primed to 1 so that we prevent duplicate checking.
p_web.SetSessionValue('UpdateJobs:Primed',1)
p_web.setsessionvalue('showtab_UpdateJobs',0)
This has been working great until I upgraded my template to 4.31 at the start of this month. Now when I save my charges, my original record is saved as nulls (together with the related child records) and I get a new record inserted in the parent table with all of my keyed values assigned to it.
The wierd thing is, that if I put my template back to 4.30, and recompile (and update my web subfolder) it still doesn't work anymore
I've got 2 production sites where this works absolutely fine, but I now can't recreate it.
Does anyone have any suggestions as to where I might be going wrong. I've been going round in circles now for days.
Regards,
Neil Porter.
80
Web Server - Ask For Help / Display an Image from a blob
« on: January 26, 2009, 04:06:22 AM »
Does anyone know if it is possible to display an image on a netwebform that is contained in an MSSQL blob field??
Everything that I'm seeing, suggests that I have to display something that is held as an image file in the images folder.
TIA,
Neil Porter.
Everything that I'm seeing, suggests that I have to display something that is held as an image file in the images folder.
TIA,
Neil Porter.
81
Web Server - Ask For Help / Re: PDF Not formatting correctly
« on: December 10, 2008, 05:50:10 AM »
Devan,
Thank you very much. That has worked brilliantly for a Win2003 server, and improved things greatly on a Win2K server.
It looks like I will have to experiment with other printers on the Win2K box, but at least you have given me a vey good push in the right direction.
Thanks Again.
Neil.
Thank you very much. That has worked brilliantly for a Win2003 server, and improved things greatly on a Win2K server.
It looks like I will have to experiment with other printers on the Win2K box, but at least you have given me a vey good push in the right direction.
Thanks Again.
Neil.
82
Web Server - Ask For Help / PDF Not formatting correctly
« on: December 10, 2008, 04:03:45 AM »
I don't think this is a probelm with NetTalk as such, but I'm hoping that someone might have come across this, and be able to advise me.
I've just deployed a pretty simple NetTalk web server onto a customers server, and when it generates a pdf report, a lot of the report fields, overlap each other, and almost seem to have changed font.
When I run the same app on my test machines, and on other customers servers, the reports generate just fine Which suggests to me that there is something specific I'm missing with the server itself, rather than with NetTalk or Clarion.
I'm using really simple fonts like MS San Serif and Arial, which are installed on that particular server, so I don't think that it is a case of the font being substituted.
Has anyone else seen anything similar?
TIA
Neil.
I've just deployed a pretty simple NetTalk web server onto a customers server, and when it generates a pdf report, a lot of the report fields, overlap each other, and almost seem to have changed font.
When I run the same app on my test machines, and on other customers servers, the reports generate just fine
Which suggests to me that there is something specific I'm missing with the server itself, rather than with NetTalk or Clarion.I'm using really simple fonts like MS San Serif and Arial, which are installed on that particular server, so I don't think that it is a case of the font being substituted.
Has anyone else seen anything similar?
TIA
Neil.
83
Web Server - Ask For Help / Re: Hide Tabs on Form
« on: December 10, 2008, 03:50:08 AM »
OK Bruce,
Thanks for the heads up.
If I know that is the case then I can work around it in another way.
I just wanted to make sure that I hadn't missed a trick somewhere.
Cheers!
Thanks for the heads up.
If I know that is the case then I can work around it in another way.
I just wanted to make sure that I hadn't missed a trick somewhere.
Cheers!
84
Web Server - Ask For Help / Re: Hide Tabs on Form
« on: December 09, 2008, 09:36:34 AM »
Kevin, did you ever find a solution to this, as I need to do exactly the same thing?
Regards,
Neil.
Regards,
Neil.
85
Web Server - Ask For Help / Re: NetWebForms - I think I'm missing something fundamental here
« on: October 27, 2008, 07:33:18 AM »
Thanks Bruce, that nailed it
This is certainly an interesting learning curve, but the results are great once you get there. I'm having to think in a very different way to my normal clarion coding.
Is there a document that details all of these p_web methods that I've not found, or is that still work in progress? I don't want to keep posting things on here, and bugging you, if there are docs for me to read through first.
Cheers,
Neil.
This is certainly an interesting learning curve, but the results are great once you get there. I'm having to think in a very different way to my normal clarion coding.
Is there a document that details all of these p_web methods that I've not found, or is that still work in progress? I don't want to keep posting things on here, and bugging you, if there are docs for me to read through first.
Cheers,
Neil.
86
Web Server - Ask For Help / NetWebForms - I think I'm missing something fundamental here
« on: October 27, 2008, 06:34:34 AM »
I'm very new to NetTalk Web Server, so I apologise in advance if what I'm asking here is really dumb.
I have a scenario, where an end user will log into a NetTalk Web site, to book "jobs". To give this end user an estimated cost of this job prior to them submitting the job, I have added a GetPrice button to my NetWebForm with some embedded code attached to it, that I use in a standard clarion application elsewhere. (see attachment 1.jpg)
From looking at the documentation, and other posts on this forum, I thought that I would have to reference session variables in calculation code rather than the fields from my table, as I would do in a standard clarion form.
I’ve looked at a number of the example applications, but focussed on the Calculator mostly, as this seems similar in logic. (see attachment 2.jpg & 3.jpg for my embed code)
My problem is that my session variables don’t appear to be set when I call my calculation routine, unless I have used an unrelated lookup button elsewhere on my form. If I use this lookup, my session variables are populated with the variables that have been entered by the end user.
There is obviously a missing step somewhere in my logic, can anyone point me in the correct direction please.
TIA,
Neil Porter.
[attachment deleted by admin]
I have a scenario, where an end user will log into a NetTalk Web site, to book "jobs". To give this end user an estimated cost of this job prior to them submitting the job, I have added a GetPrice button to my NetWebForm with some embedded code attached to it, that I use in a standard clarion application elsewhere. (see attachment 1.jpg)
From looking at the documentation, and other posts on this forum, I thought that I would have to reference session variables in calculation code rather than the fields from my table, as I would do in a standard clarion form.
I’ve looked at a number of the example applications, but focussed on the Calculator mostly, as this seems similar in logic. (see attachment 2.jpg & 3.jpg for my embed code)
My problem is that my session variables don’t appear to be set when I call my calculation routine, unless I have used an unrelated lookup button elsewhere on my form. If I use this lookup, my session variables are populated with the variables that have been entered by the end user.
There is obviously a missing step somewhere in my logic, can anyone point me in the correct direction please.
TIA,
Neil Porter.
[attachment deleted by admin]