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.
10771
Web Server - Ask For Help / Re: Slightly OT: How much effort to convert database from TPS to MS SQL.
« on: February 07, 2008, 06:39:37 AM »
Hi Mike,
In and of themselves Longs and Strings are no problem in MsSql.
However if another program (not clarion) was to want to share the data then tpically you can change the data type to something more "SQLy". For example changing Dates from LONG to DATE. Strings from String to Cstring (although this is less necessary). and so on.
And of course all this is pretty trivial with Fm3, and can be done down the road if you want to do it.
As far as converting from TPS to SQL - that's also trivial. Work through the docs, and maybe the example as well, and you'll find it's not as bad as it sounds.
Cheers
Bruce
In and of themselves Longs and Strings are no problem in MsSql.
However if another program (not clarion) was to want to share the data then tpically you can change the data type to something more "SQLy". For example changing Dates from LONG to DATE. Strings from String to Cstring (although this is less necessary). and so on.
And of course all this is pretty trivial with Fm3, and can be done down the road if you want to do it.
As far as converting from TPS to SQL - that's also trivial. Work through the docs, and maybe the example as well, and you'll find it's not as bad as it sounds.
Cheers
Bruce
10772
Web Server - Ask For Help / Re: How do I get out of Frames
« on: February 06, 2008, 04:29:34 AM »
Hi Ian,
So, just so I'm sure, what you're thinking of is
a) normal (framed) site with browse in say the Right_Frame
b) Go to Form, but at this point set target to '_top' (hence, just the form appears, no frame) then
c) On save (or cancel) jump back to the FrameSet procedure, and hence have the frames back, with the browse in the right hand side?
Cheers
Bruce
So, just so I'm sure, what you're thinking of is
a) normal (framed) site with browse in say the Right_Frame
b) Go to Form, but at this point set target to '_top' (hence, just the form appears, no frame) then
c) On save (or cancel) jump back to the FrameSet procedure, and hence have the frames back, with the browse in the right hand side?
Cheers
Bruce
10773
Web Server - Ask For Help / Re: Disable insert button
« on: February 06, 2008, 04:21:30 AM »
Hi Bram,
Ok, getting clearer.
So you have a window (a NetWebForm I presume?) , and it has 2 browses.
the one is a child of the other?
You want to limit the number of records in the child browse, depending on the number stored in the parent browse record.
Ok, so the child browse presumably has a filter of some description, limiting it to the parent browse.
Actually, the answer is the same, even if the setup is different.
The short answer is yes, you can use the condition on the "Form" tab, next to the "Insert" checkbox.
Let's say you set this condition to loc:something
then all you need to do is prime loc:something appropriately.
You've got the Session Value, of the parent file's ID field (presumably you're using this in the filter). So to get the "numbers allowed" value you'd need to
Open
Get
loc:something = whatever
Close
Cheers
Bruce
Ok, getting clearer.
So you have a window (a NetWebForm I presume?) , and it has 2 browses.
the one is a child of the other?
You want to limit the number of records in the child browse, depending on the number stored in the parent browse record.
Ok, so the child browse presumably has a filter of some description, limiting it to the parent browse.
Actually, the answer is the same, even if the setup is different.
The short answer is yes, you can use the condition on the "Form" tab, next to the "Insert" checkbox.
Let's say you set this condition to loc:something
then all you need to do is prime loc:something appropriately.
You've got the Session Value, of the parent file's ID field (presumably you're using this in the filter). So to get the "numbers allowed" value you'd need to
Open
Get
loc:something = whatever
Close
Cheers
Bruce
10774
Web Server - Ask For Help / Re: Disable insert button
« on: February 04, 2008, 11:52:14 PM »
Hi Bram,
I'm not really sure what you mean. The number of records? something in the records?
Cheers
Bruce
I'm not really sure what you mean. The number of records? something in the records?
Cheers
Bruce
10775
Web Server - Ask For Help / Re: Automatically bring up first menu item
« on: February 04, 2008, 08:13:52 AM »
Hi Skip,
Yes, in the FrameSet procedure, as part of the setting for each "Frame", there is an option "URL". This is the default "page" that will be loaded when the frame opens.
So for example, in example number 4, the "left_fram" default URL is 'MenuOnLeft', whereas the default for the right_fram is either blank, or possibly loc:RightURL depending on what example you look at.
Cheers
Bruce
Yes, in the FrameSet procedure, as part of the setting for each "Frame", there is an option "URL". This is the default "page" that will be loaded when the frame opens.
So for example, in example number 4, the "left_fram" default URL is 'MenuOnLeft', whereas the default for the right_fram is either blank, or possibly loc:RightURL depending on what example you look at.
Cheers
Bruce
10776
Web Server - Ask For Help / Re: requestreferer Property not working in IE6/7 - ok in FF
« on: February 04, 2008, 08:03:03 AM »
Hi Dave,
I've attached a small altered example app (a modified example 1). I think this is the same context as yours. Can you try it and see what happens? On my side it's identical for IE and FF.
Cheers
Bruce
[attachment deleted by admin]
I've attached a small altered example app (a modified example 1). I think this is the same context as yours. Can you try it and see what happens? On my side it's identical for IE and FF.
Cheers
Bruce
[attachment deleted by admin]
10777
Web Server - Ask For Help / Re: Disable insert button
« on: February 04, 2008, 07:08:36 AM »
Hi Bram,
The most important thing to remember is that the Insert Button is added to the window at _generate_ time. So it's not "trivial" to disable the Insert button depending on which row is highlighted. Possible, but not trivial.
To make the existence of the Insert button conditional, use the Condition, next to the "Insert" setting, on the Form tab of the Browse.
Cheers
Bruce
The most important thing to remember is that the Insert Button is added to the window at _generate_ time. So it's not "trivial" to disable the Insert button depending on which row is highlighted. Possible, but not trivial.
To make the existence of the Insert button conditional, use the Condition, next to the "Insert" setting, on the Form tab of the Browse.
Cheers
Bruce
10778
Web Server - Ask For Help / Re: How do I get out of Frames
« on: February 04, 2008, 06:58:41 AM »
Hi Ian,
>> However I can't set the target frame for a form coming off of a browse.
Do you mean by this...
"I can't determine where the Form opens, when clicking on the Insert / Change button on a Browse"
or
"I can't determine the Frame where the Browse opens when clicking on the Save / Cancel button in a form"
>> How can I detect if a forms running in a frame or not?
Detect where, and why? You can detect in the code of a frame itself using JavaScript. However I'm not sure that's what you're alluding to.
On the server side you can't really tell because the browser doesn't tell you what it's gonna do with the page, it just asks for a page. Of course since you generated the URL in the first place, chances are you know what frame it's going into.
Cheers
Bruce
Cheers
Bruce
>> However I can't set the target frame for a form coming off of a browse.
Do you mean by this...
"I can't determine where the Form opens, when clicking on the Insert / Change button on a Browse"
or
"I can't determine the Frame where the Browse opens when clicking on the Save / Cancel button in a form"
>> How can I detect if a forms running in a frame or not?
Detect where, and why? You can detect in the code of a frame itself using JavaScript. However I'm not sure that's what you're alluding to.
On the server side you can't really tell because the browser doesn't tell you what it's gonna do with the page, it just asks for a page. Of course since you generated the URL in the first place, chances are you know what frame it's going into.
Cheers
Bruce
Cheers
Bruce
10779
Web Server - Ask For Help / Re: Send New Value To Server in a Memory Form
« on: January 31, 2008, 11:27:04 PM »
Hi John,
It seems to me that the error might be in the order numbers you are sending back.
The packet going back to the server needs to be valid xHTML. If all the "Messages" look right, then that's where I'd concentrate my attention.
So the big question,
What does an "order number" look like in your system. I'm guessing it's not 1,2,3,4 etc
Cheers
Bruce
It seems to me that the error might be in the order numbers you are sending back.
The packet going back to the server needs to be valid xHTML. If all the "Messages" look right, then that's where I'd concentrate my attention.
So the big question,
What does an "order number" look like in your system. I'm guessing it's not 1,2,3,4 etc
Cheers
Bruce
10780
Web Server - Ask For Help / Re: requestreferer Property not working in IE6/7 - ok in FF
« on: January 31, 2008, 11:24:03 PM »
Hi Dave,
I ran a test here (described below) but it worked for me exactly the same in IE7 and FF. So I'm thinking maybe something else is different between what you are doing, and what I am doing. Perhaps the issue is _where_ you are testing the p_web.RequestReferer property?
I used example 33 (for no particular reason except that it was handy), AliasFormControl procedure. In the "Start of Processed Code" embed point I put
stop(p_web.RequestReferer)
Then I ran the app, and went to the Alias form page. The stop popped up 4 times (which is to be expected, as the form is called multiple times as the page is generated) but for all browsers, and indeed all times, it displayed the same text - which was the URL of the Alias form page.
Cheers
Bruce
I ran a test here (described below) but it worked for me exactly the same in IE7 and FF. So I'm thinking maybe something else is different between what you are doing, and what I am doing. Perhaps the issue is _where_ you are testing the p_web.RequestReferer property?
I used example 33 (for no particular reason except that it was handy), AliasFormControl procedure. In the "Start of Processed Code" embed point I put
stop(p_web.RequestReferer)
Then I ran the app, and went to the Alias form page. The stop popped up 4 times (which is to be expected, as the form is called multiple times as the page is generated) but for all browsers, and indeed all times, it displayed the same text - which was the URL of the Alias form page.
Cheers
Bruce
10781
Web Server - Ask For Help / Re: Prototype.js
« on: January 31, 2008, 10:52:23 PM »
Hi Devan,
For version 4.31 I'll probably update the underlying libraries.
Cheers
Bruce
For version 4.31 I'll probably update the underlying libraries.
Cheers
Bruce
10782
Web Server - Ask For Help / Re: SOAP Server questions
« on: January 31, 2008, 10:50:49 PM »
Hi Leroy,
The first thing to remember is that by leveraging xFiles it's easy to turn "clarion constructions" into XML. xFiles supports Groups, Files, Queues, and Views as "clarion constructions".
In the SOAP example (42) the program uses Groups, and then a single line turns the group into an xml string. For example the TeacherResult group is morphed using
Xml.Save(TeacherResult)
It's obviously trivial to extend the group to include more fields, and if you want multiple records then use a Queue, File or View as the source.
Using this information let's answer your questions below;
1. >>Normally, that would only be 10-30 records, but the potential is there for up to 1000 records being passed back. What sort of approach should I be looking at to send this data back?
If the data is available in a file, then I would hand-code a VIEW structure, with an appropriate prop:filter & prop:order and simply pass the VIEW to xFiles. If you needed to get more hand-son manipulating the data before it's sent, then build a Queue, or IMM table.
2. >> Is it possible to send back an image and HTML-formatted code as part of the SOAP request,
You can send back anything you like. Add fields to the Group, prime them, send them. At the other end you can enlarge the group, get the data, then do whatever you like with it there.
Because it's XML it's forwards and backwards compatible. Old programs will ignore the extra fields, New programs (getting data from an old Server) will just leave those fields in the group alone.
Cheers
Bruce
The first thing to remember is that by leveraging xFiles it's easy to turn "clarion constructions" into XML. xFiles supports Groups, Files, Queues, and Views as "clarion constructions".
In the SOAP example (42) the program uses Groups, and then a single line turns the group into an xml string. For example the TeacherResult group is morphed using
Xml.Save(TeacherResult)
It's obviously trivial to extend the group to include more fields, and if you want multiple records then use a Queue, File or View as the source.
Using this information let's answer your questions below;
1. >>Normally, that would only be 10-30 records, but the potential is there for up to 1000 records being passed back. What sort of approach should I be looking at to send this data back?
If the data is available in a file, then I would hand-code a VIEW structure, with an appropriate prop:filter & prop:order and simply pass the VIEW to xFiles. If you needed to get more hand-son manipulating the data before it's sent, then build a Queue, or IMM table.
2. >> Is it possible to send back an image and HTML-formatted code as part of the SOAP request,
You can send back anything you like. Add fields to the Group, prime them, send them. At the other end you can enlarge the group, get the data, then do whatever you like with it there.
Because it's XML it's forwards and backwards compatible. Old programs will ignore the extra fields, New programs (getting data from an old Server) will just leave those fields in the group alone.
Cheers
Bruce
10783
Web Server - Ask For Help / Re: How do I get out of Frames
« on: January 31, 2008, 10:41:06 PM »
Hi Ian,
Alan's answer is a good one. Setting the target to '_blank' makes that URL open in a new window.
If your site has frames, and you want to make the frames go away and link to "jsut a page" in the _same_ browser window then set the target of the URL to '_top'.
Cheers
Bruce
Alan's answer is a good one. Setting the target to '_blank' makes that URL open in a new window.
If your site has frames, and you want to make the frames go away and link to "jsut a page" in the _same_ browser window then set the target of the URL to '_top'.
Cheers
Bruce
10784
Web Server - Ask For Help / Re: Multi lines in NetWebBrowse
« on: January 31, 2008, 10:32:27 PM »
Hi Zoltan,
Placing a text & image together, one under the other, is probably not too difficult - I'm guessing it can be done using an appropriate css class for that browse column.
You can split a specific line of text using the <br /> tag. (Note the trailing /, this is very important because browses need to be xHtml, not Html.
To include html in a browse column you need to tick on the option "allow xHtml in column".
You might even find this is suitable for your image / price question.
Cheers
Bruce
Placing a text & image together, one under the other, is probably not too difficult - I'm guessing it can be done using an appropriate css class for that browse column.
You can split a specific line of text using the <br /> tag. (Note the trailing /, this is very important because browses need to be xHtml, not Html.
To include html in a browse column you need to tick on the option "allow xHtml in column".
You might even find this is suitable for your image / price question.
Cheers
Bruce
10785
Web Server - Ask For Help / Re: Insert a form record without leaving the form
« on: January 27, 2008, 10:59:49 PM »
Hi John,
Yes, the issue is how to set the record ID as part of the parameter list, when we don't know the number at the time the URL is generated.
Fortunately there is a way. The command line is essentially going to get read into the parameter queue (ie the _Value_ queue - not the SessionValue Queue). And there is a way to add values to this queue _as long as you are on the same thread_. Let me say that again. _As long as you are on the same thread_.
As it happens, the PostInsert embed of the "Insert Form" is on the same thread as the "Init" part of the Change Form. So you can add the ID as a _Value_ (not sessionvalue) in the PostInsert embed.
The easiest way to make the URL conditional is to simply use a local variable there. Then right-click the procedure, and search for the variable (ie where it is being used.) _Before_ it is used you need to set the contents of the variable appropriately.
Regarding the child browse, and the additional line items. Since it is a "short list" I'd probably recommend a file-loaded browse here anyway. However it should return to the correct line. However we should deal with this problem on a separate thread if you want to take it further.
Cheers
Bruce
Yes, the issue is how to set the record ID as part of the parameter list, when we don't know the number at the time the URL is generated.
Fortunately there is a way. The command line is essentially going to get read into the parameter queue (ie the _Value_ queue - not the SessionValue Queue). And there is a way to add values to this queue _as long as you are on the same thread_. Let me say that again. _As long as you are on the same thread_.
As it happens, the PostInsert embed of the "Insert Form" is on the same thread as the "Init" part of the Change Form. So you can add the ID as a _Value_ (not sessionvalue) in the PostInsert embed.
The easiest way to make the URL conditional is to simply use a local variable there. Then right-click the procedure, and search for the variable (ie where it is being used.) _Before_ it is used you need to set the contents of the variable appropriately.
Regarding the child browse, and the additional line items. Since it is a "short list" I'd probably recommend a file-loaded browse here anyway. However it should return to the correct line. However we should deal with this problem on a separate thread if you want to take it further.
Cheers
Bruce