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 / Help with Parent-Child Reports
« on: January 17, 2011, 04:34:46 PM »
Hi ,
Using C7,2,7653 and NetTalk 5.02
I have a Report on a Parent file - works fine.
I added a child file and a Parent child relationship.
In the desktop version of the app I modified the report to put in a break on the parent and the report prints the Parents their children correctly.
I went to the Net Talk version of the same app and modified the Same report In Net Talk and added related child file and The Group Break on parent. However the NET TALK APP Report tends to repeat the child records several times ( incorrectly). The desktop version of the same report set up the same way prints the Child items correctly ( i.e. if there are two items, it prints only two items...). The Net Talk App may print the each of the two child items 3 times each?
?
Is this a known problem with Parent --> Child reports in Net Talk.
Have tried several ways to configure the Net Talk report but can't get it to come out right....
Has this been addressed in a newer version of Net Talk.
Thanks,
Ron Jolda
Using C7,2,7653 and NetTalk 5.02
I have a Report on a Parent file - works fine.
I added a child file and a Parent child relationship.
In the desktop version of the app I modified the report to put in a break on the parent and the report prints the Parents their children correctly.
I went to the Net Talk version of the same app and modified the Same report In Net Talk and added related child file and The Group Break on parent. However the NET TALK APP Report tends to repeat the child records several times ( incorrectly). The desktop version of the same report set up the same way prints the Child items correctly ( i.e. if there are two items, it prints only two items...). The Net Talk App may print the each of the two child items 3 times each?
?Is this a known problem with Parent --> Child reports in Net Talk.
Have tried several ways to configure the Net Talk report but can't get it to come out right....
Has this been addressed in a newer version of Net Talk.
Thanks,
Ron Jolda
77
Web Server - Ask For Help / Handling Threads???
« on: September 15, 2010, 11:58:54 AM »
Hi,
Trying to get a handle on how to Thread or Not to Thread in Net Talk Application.
I shall give an example to illustrate:
Browse with list of companies is on the screen.
User selects a company and starts entering a transaction ( Transaction ID #1) - this TransactionID can be stored in the Session Queue and then retrieved to link the OrderedItems to this Transaction.
Suppose that the user does not complete TransactionID #1 because the phone rings and they get interrupted.
Now they go to the main Company Browse and they start a new transaction (Transaction ID #2) - they start entering OrderItems for this TransactionID #2 and Transaction ID#2 is stored in the Session queue.
Now, how do they handle Transaction #1 which has not yet been completed - Transaction ID #2 information is stored in the Session Queue?
What is the best way to handle this ?
Start Each transaction on a New Thread? Can you retrieve the SessionQueue values by the thread ID?
Other Ways?
Trying to get my head around how to manage this with Net Talk as the end users do not always complete the task at hand and may jump between tasks.
Thanks for any insight.
Ron Jolda
Trying to get a handle on how to Thread or Not to Thread in Net Talk Application.
I shall give an example to illustrate:
Browse with list of companies is on the screen.
User selects a company and starts entering a transaction ( Transaction ID #1) - this TransactionID can be stored in the Session Queue and then retrieved to link the OrderedItems to this Transaction.
Suppose that the user does not complete TransactionID #1 because the phone rings and they get interrupted.
Now they go to the main Company Browse and they start a new transaction (Transaction ID #2) - they start entering OrderItems for this TransactionID #2 and Transaction ID#2 is stored in the Session queue.
Now, how do they handle Transaction #1 which has not yet been completed - Transaction ID #2 information is stored in the Session Queue?
What is the best way to handle this ?
Start Each transaction on a New Thread? Can you retrieve the SessionQueue values by the thread ID?
Other Ways?
Trying to get my head around how to manage this with Net Talk as the end users do not always complete the task at hand and may jump between tasks.
Thanks for any insight.
Ron Jolda
78
Web Server - Ask For Help / Dynamically changing EIP for a field - string, drop or none.....
« on: August 26, 2010, 04:54:01 AM »
Hi,
Using C7.1 and NT5. I have a browse with a field that sometimes can take a value depending on how the data row is set up. The field is a string. Sometimes it can take a String ENTRY and sometimes it can be populated from a pre-defined set of DROP values. The rest of the time, it cannot be edited.......
Trying to dynamically set my browse for EIP of no EIP and for the r_val field to be Editiable or Non Editable. If Editable, it will be a String ENTRY or DROP Queue.
I have taken the code for the string Entry and Drop Entry and no entry and made my own routine to display the AIT1:r_val field in the Browse line. It displays the FIRST set of data Fine. The problem is that when I click NEXT, LAST it HANGS. So, something is not right. Can anyone shed any light on it?
Thanks,
Ron Jolda
_____________________________________________________________________________________
Here it the code:
Template field: AIT1:r_val
Field:
Use Equate:
Type:String
Display: ''
Picture: '@s1'
Allow Edit in Place: checked on
EIP condition: loc:eiptype > 0
Refresh browse row DATA after server Code runs: checked on ( no server code )
value::AIT1:r_val Routine
data
loc:extra String(256)
loc:disabled String(20)
loc:FormOk Long(1)
loc:options String(OptionsStringLen) ! options for jQuery calls
loc:fieldClass String(255)
loc:javascript String(JavascriptStringLen)
code
!! !loc:eiptype = 0,1,2
if upper( AIT1:r_contype) = 'ENTRY'!
loc:eiptype = 1
elsif upper(AIT1:r_contype) = 'DROP LIST'
loc:eiptype = 2
else
loc:eiptype = 0
end
! End of "Before a Cell value is calculated"
if false
else
packet = clip(packet) & p_web._DivHeader('AIT1:r_val_'&AIT1:IH_ID,,net:crc)
If loc:eiptype > 0
loc:fieldclass = ''
! Start of "Generating Browse Field"
! [Priority 5000]
if loc:eiptype = 1 !string
loc:javascript = 'onchange="B_AimTMP2.eip(this,'''&p_web._jsok('AIT1:r_val')&''','''&p_web._jsok(loc:viewstate)&''');"'
packet = clip(packet) & p_web.CreateInput('text','inp'&p_web.crc32('AIT1:r_val'&AIT1:IH_ID),AIT1:r_val,p_web.combine(p_web.site.style.browseentry,,loc:fieldclass),0,,'@s49',loc:javascript,,,,) & '<13,10>'
elsif loc:eiptype = 2 !drop
! --- DROPLIST ---
loc:javascript = 'onchange="B_AimTMP2.eip(this,'''&p_web._jsok('AIT1:r_val')&''','''&p_web._jsok(loc:viewstate)&''');"'
packet = clip(packet) & p_web.CreateSelect('AIT1:r_val'&AIT1:IH_ID,p_web.combine(p_web.site.style.browseDrop,,loc:fieldclass),,,,,loc:javascript,)
packet = clip(packet) & p_web.CreateOption('Clear',0,choose(0 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
packet = clip(packet) & p_web.CreateOption('Female',1,choose(1 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
packet = clip(packet) & p_web.CreateOption('Male',3,choose(3 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
packet = clip(packet) & p_web.CreateOption('Other',4,choose(4 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
end
! End of "Generating Browse Field"
Else
packet = clip(packet) & p_web._DivHeader('AIT1:r_val_'&AIT1:IH_ID,,net:crc)
packet = clip(packet) & Left(Format('','@s49'))
End
End
packet = clip(packet) & p_web._DivFooter(Net:NoSend)
! Start of "After a Cell value is calculated"
! [Priority 5000]
! End of "After a Cell value is calculated"
if loc:eip = 1
do SendPacket
end
EXIT
if false
else
packet = clip(packet) & p_web._DivHeader('AIT1:r_val_'&AIT1:IH_ID,,net:crc)
If loc:eiptype > 0
loc:fieldclass = ''
loc:javascript = 'onchange="B_AimTMP2.eip(this,'''&p_web._jsok('AIT1:r_val')&''','''&p_web._jsok(loc:viewstate)&''');"'
packet = clip(packet) & p_web.CreateInput('text','inp'&p_web.crc32('AIT1:r_val'&AIT1:IH_ID),AIT1:r_val,p_web.combine(p_web.site.style.browseentry,,loc:fieldclass),0,,'@s1',loc:javascript,,,,) & '<13,10>'
Else
packet = clip(packet) & Left(Format('','@s1'))
End
End
packet = clip(packet) & p_web._DivFooter(Net:NoSend)
!stop('we should not be here')
if loc:eip = 1
do SendPacket
end
! --------------------------------------------------------
Using C7.1 and NT5. I have a browse with a field that sometimes can take a value depending on how the data row is set up. The field is a string. Sometimes it can take a String ENTRY and sometimes it can be populated from a pre-defined set of DROP values. The rest of the time, it cannot be edited.......
Trying to dynamically set my browse for EIP of no EIP and for the r_val field to be Editiable or Non Editable. If Editable, it will be a String ENTRY or DROP Queue.
I have taken the code for the string Entry and Drop Entry and no entry and made my own routine to display the AIT1:r_val field in the Browse line. It displays the FIRST set of data Fine. The problem is that when I click NEXT, LAST it HANGS. So, something is not right. Can anyone shed any light on it?
Thanks,
Ron Jolda
_____________________________________________________________________________________
Here it the code:
Template field: AIT1:r_val
Field:
Use Equate:
Type:String
Display: ''
Picture: '@s1'
Allow Edit in Place: checked on
EIP condition: loc:eiptype > 0
Refresh browse row DATA after server Code runs: checked on ( no server code )
value::AIT1:r_val Routine
data
loc:extra String(256)
loc:disabled String(20)
loc:FormOk Long(1)
loc:options String(OptionsStringLen) ! options for jQuery calls
loc:fieldClass String(255)
loc:javascript String(JavascriptStringLen)
code
!! !loc:eiptype = 0,1,2
if upper( AIT1:r_contype) = 'ENTRY'!
loc:eiptype = 1
elsif upper(AIT1:r_contype) = 'DROP LIST'
loc:eiptype = 2
else
loc:eiptype = 0
end
! End of "Before a Cell value is calculated"
if false
else
packet = clip(packet) & p_web._DivHeader('AIT1:r_val_'&AIT1:IH_ID,,net:crc)
If loc:eiptype > 0
loc:fieldclass = ''
! Start of "Generating Browse Field"
! [Priority 5000]
if loc:eiptype = 1 !string
loc:javascript = 'onchange="B_AimTMP2.eip(this,'''&p_web._jsok('AIT1:r_val')&''','''&p_web._jsok(loc:viewstate)&''');"'
packet = clip(packet) & p_web.CreateInput('text','inp'&p_web.crc32('AIT1:r_val'&AIT1:IH_ID),AIT1:r_val,p_web.combine(p_web.site.style.browseentry,,loc:fieldclass),0,,'@s49',loc:javascript,,,,) & '<13,10>'
elsif loc:eiptype = 2 !drop
! --- DROPLIST ---
loc:javascript = 'onchange="B_AimTMP2.eip(this,'''&p_web._jsok('AIT1:r_val')&''','''&p_web._jsok(loc:viewstate)&''');"'
packet = clip(packet) & p_web.CreateSelect('AIT1:r_val'&AIT1:IH_ID,p_web.combine(p_web.site.style.browseDrop,,loc:fieldclass),,,,,loc:javascript,)
packet = clip(packet) & p_web.CreateOption('Clear',0,choose(0 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
packet = clip(packet) & p_web.CreateOption('Female',1,choose(1 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
packet = clip(packet) & p_web.CreateOption('Male',3,choose(3 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
packet = clip(packet) & p_web.CreateOption('Other',4,choose(4 = AIT1:r_val),p_web.combine(p_web.site.style.browseDropOption,,loc:fieldclass),,)&'<13,10>'
end
! End of "Generating Browse Field"
Else
packet = clip(packet) & p_web._DivHeader('AIT1:r_val_'&AIT1:IH_ID,,net:crc)
packet = clip(packet) & Left(Format('','@s49'))
End
End
packet = clip(packet) & p_web._DivFooter(Net:NoSend)
! Start of "After a Cell value is calculated"
! [Priority 5000]
! End of "After a Cell value is calculated"
if loc:eip = 1
do SendPacket
end
EXIT
if false
else
packet = clip(packet) & p_web._DivHeader('AIT1:r_val_'&AIT1:IH_ID,,net:crc)
If loc:eiptype > 0
loc:fieldclass = ''
loc:javascript = 'onchange="B_AimTMP2.eip(this,'''&p_web._jsok('AIT1:r_val')&''','''&p_web._jsok(loc:viewstate)&''');"'
packet = clip(packet) & p_web.CreateInput('text','inp'&p_web.crc32('AIT1:r_val'&AIT1:IH_ID),AIT1:r_val,p_web.combine(p_web.site.style.browseentry,,loc:fieldclass),0,,'@s1',loc:javascript,,,,) & '<13,10>'
Else
packet = clip(packet) & Left(Format('','@s1'))
End
End
packet = clip(packet) & p_web._DivFooter(Net:NoSend)
!stop('we should not be here')
if loc:eip = 1
do SendPacket
end
! --------------------------------------------------------
79
Web Server - Ask For Help / EIP - changing how it works for each record
« on: August 15, 2010, 05:22:39 AM »
Hi,
I have a Browse and a field that I want to do EIP with - but only if a value is requested -
so first question - I have the logic so I just need to know how to turn EIP on or off for each record . Can I set loc:EIP = 0 if no EIP and loc:EIP = 1 if EIP is to be turned on?
Second question. Sometimes the EIP value is a string and sometimes it comes from a drop list table that is pre filled with choices. So, once I have turned on EIP for the field for that record, how can I set the EIP for a STRING entry or to use a DROP list?
Thanks,
Ron Jolda
I have a Browse and a field that I want to do EIP with - but only if a value is requested -
so first question - I have the logic so I just need to know how to turn EIP on or off for each record . Can I set loc:EIP = 0 if no EIP and loc:EIP = 1 if EIP is to be turned on?
Second question. Sometimes the EIP value is a string and sometimes it comes from a drop list table that is pre filled with choices. So, once I have turned on EIP for the field for that record, how can I set the EIP for a STRING entry or to use a DROP list?
Thanks,
Ron Jolda
80
Web Server - Ask For Help / Use queue for Edit in Place?
« on: August 02, 2010, 03:11:48 PM »
Hi,
I want to edit a field in place. Can I have a pop up queue of values that I can pick from for the value of the field? How do I do that?
Is there an example?
Thanks,
Ron Jolda
I want to edit a field in place. Can I have a pop up queue of values that I can pick from for the value of the field? How do I do that?
Is there an example?
Thanks,
Ron Jolda
81
Web Server - Ask For Help / Concepts on hiding and unhiding objects/fields on forms
« on: August 01, 2010, 04:10:31 PM »
HI All,
Trying to understand the concepts of hiding / unhiding fields and objects - drop lists and Option boxes.
On Update form - some records allow an entry to be picked from an option box or a drop list and some do not. How do it hide / unhide option boxes and drop lists depending on the record being updated?
THanks,
Ron Jolda
Trying to understand the concepts of hiding / unhiding fields and objects - drop lists and Option boxes.
On Update form - some records allow an entry to be picked from an option box or a drop list and some do not. How do it hide / unhide option boxes and drop lists depending on the record being updated?
THanks,
Ron Jolda
82
Web Server - Ask For Help / Changing options in Option box in a form
« on: July 28, 2010, 04:58:20 PM »
Hi
I want to change the options ( usually 3 choices) in a box on a form when a record is selected for update -depending on the desired allowed choices for that record.
Option Items Text can change :
e.g. for option choices 1, 2 and 3
First Variation: 1. Comment, 2. Yes , 3. No
Another variation: 1. Comment, 2. Positive, 3. Negative
Another Variation: 1. Comment, 2. Negative, 3. Positive
Thanks,
Ron Jolda
I want to change the options ( usually 3 choices) in a box on a form when a record is selected for update -depending on the desired allowed choices for that record.
Option Items Text can change :
e.g. for option choices 1, 2 and 3
First Variation: 1. Comment, 2. Yes , 3. No
Another variation: 1. Comment, 2. Positive, 3. Negative
Another Variation: 1. Comment, 2. Negative, 3. Positive
Thanks,
Ron Jolda
83
Web Server - Ask For Help / conditionally coloring cells in a browse
« on: July 23, 2010, 11:39:42 AM »
Hi,
Trying to get my hands around the CSS and HTML and cell coloring.
I am trying to set the background to yellow on column one ( name ) if column 3 is > 0.
I defined some classes for column one and column 3 and I read the record before it is put into the browse and I set the class name for column1 and column3 depending on the value of column3.
e.g. If col3 > 0, col1 class name = 'c1Y'
If col3 = 0, then col1 class name = 'c1N'
I created a style sheet and added it to my NetWebServer styles and it is being used as I am setting other properties and this new style sheet is being used.
I created some new classes: .c1Y and c1N to set the background color for column1.
In Firebug, I see the class names assigned for the cells - i.e. c1Y or c1N but I don't see my classes .c1Y or c1N being loaded from the CSS style file for these.
Can anyone share their tricks for coloring different cells depending on a value of another field in the same line of the browse?
Are folks using "in line " HTML style to color cells?
Thanks,
Ron Jolda
Trying to get my hands around the CSS and HTML and cell coloring.
I am trying to set the background to yellow on column one ( name ) if column 3 is > 0.
I defined some classes for column one and column 3 and I read the record before it is put into the browse and I set the class name for column1 and column3 depending on the value of column3.
e.g. If col3 > 0, col1 class name = 'c1Y'
If col3 = 0, then col1 class name = 'c1N'
I created a style sheet and added it to my NetWebServer styles and it is being used as I am setting other properties and this new style sheet is being used.
I created some new classes: .c1Y and c1N to set the background color for column1.
In Firebug, I see the class names assigned for the cells - i.e. c1Y or c1N but I don't see my classes .c1Y or c1N being loaded from the CSS style file for these.
Can anyone share their tricks for coloring different cells depending on a value of another field in the same line of the browse?
Are folks using "in line " HTML style to color cells?
Thanks,
Ron Jolda
84
Web Server - Ask For Help / Browse line item Classes and Identifiers for Selectors
« on: June 29, 2010, 11:35:20 AM »
Hi,
How / where do we put in class names and or Identifiers in each line of the browse so that the css class or identifer selector will be able to see it and color it appropriately for each COLUMN???
Thanks,
Ron Jolda
How / where do we put in class names and or Identifiers in each line of the browse so that the css class or identifer selector will be able to see it and color it appropriately for each COLUMN???
Thanks,
Ron Jolda
85
Web Server - Ask For Help / Coloring fields in Browse based on value in record?
« on: June 07, 2010, 12:37:30 PM »
Hi,
What is the technique to color a field in a browse based on a field value.
i.e. if Yes - color field1 Green. If NO, color field 1 Red.
Is this getting into the CSS?
If it is, then what do I need to modify in the CSS and how do I call it for that browse field?
Thanks,
Ron Jolda
What is the technique to color a field in a browse based on a field value.
i.e. if Yes - color field1 Green. If NO, color field 1 Red.
Is this getting into the CSS?
If it is, then what do I need to modify in the CSS and how do I call it for that browse field?
Thanks,
Ron Jolda
86
Web Server - Ask For Help / Net:message and Net:popups
« on: June 05, 2010, 05:22:01 AM »
Hi,
I see these routines in the help but not sure how to use them. Are these used in any of the examples . If not, how are they used?
<!--Net:message-->
<!--Net:popup-->
Thanks,
Ron Jolda
I see these routines in the help but not sure how to use them. Are these used in any of the examples . If not, how are they used?
<!--Net:message-->
<!--Net:popup-->
Thanks,
Ron Jolda
87
Web Server - Ask For Help / Open message window.
« on: June 04, 2010, 12:12:38 PM »
Hi All,
I have a process ( in a browse) that takes about 5 - 10 seconds. I want to open a new window with a message that says" Build is completed" and a button to click OK to close this window.
I have tried various permutations but have not been able to achieve this.
What is the easiest and cleanest way to do this??
Thanks,
Ron Jolda
I have a process ( in a browse) that takes about 5 - 10 seconds. I want to open a new window with a message that says" Build is completed" and a button to click OK to close this window.
I have tried various permutations but have not been able to achieve this.
What is the easiest and cleanest way to do this??
Thanks,
Ron Jolda
88
Web Server - Ask For Help / setting up filter
« on: May 31, 2010, 04:17:25 PM »
Hi All,
Trying to set up a filter - three conditions:
1. JPS:Sdate > today() - 30
AND
2a. Prv:ihid =' &p_web.GSV('_providerID')
OR
2b Prv:alt_ihid =' &p_web.GSV('_altproviderID')
Have it set up as :
'JPS:Sdate > today() - 30 and ( & Prv:ihid =' &p_web.GSV('_providerID') & 'OR Prv:alt_ihid =' &p_web.GSV('_altproviderID') & ')'
Compiles OK but DOES NOT WORK!
Suggestions please!!!!!
Thanks,
Ron Jolda
Trying to set up a filter - three conditions:
1. JPS:Sdate > today() - 30
AND
2a. Prv:ihid =' &p_web.GSV('_providerID')
OR
2b Prv:alt_ihid =' &p_web.GSV('_altproviderID')
Have it set up as :
'JPS:Sdate > today() - 30 and ( & Prv:ihid =' &p_web.GSV('_providerID') & 'OR Prv:alt_ihid =' &p_web.GSV('_altproviderID') & ')'
Compiles OK but DOES NOT WORK!
Suggestions please!!!!!
Thanks,
Ron Jolda
89
Web Server - Ask For Help / open and display an HTML document from Menu item
« on: May 20, 2010, 01:14:37 PM »
Hi
I wrote an HTML help file for my app.
I put a menu item on the Main Menu called "help"
I want to open the HTML help file when they click on this menu item.
For the Menu item I put the title of the page 'WPSClinicHelp.html' in the URL for the menu item.
I put '_self' in the window.
I have my help file in the same directory as my app and the directory below.
IE tells me that it cannot find the document when I click on HELP.
Am I doing it correctly or is there a better way to display this HELP file.
Thanks,
Ron Jolda
I wrote an HTML help file for my app.
I put a menu item on the Main Menu called "help"
I want to open the HTML help file when they click on this menu item.
For the Menu item I put the title of the page 'WPSClinicHelp.html' in the URL for the menu item.
I put '_self' in the window.
I have my help file in the same directory as my app and the directory below.
IE tells me that it cannot find the document when I click on HELP.
Am I doing it correctly or is there a better way to display this HELP file.
Thanks,
Ron Jolda
90
Web Server - Ask For Help / Sending file after it is created
« on: May 11, 2010, 04:07:55 AM »
Hi ,
I am calling a procedure to build a large PDF file and returning the name of the file that was created.
If it was created successfully I want it to download to the client.
What are the steps to automagically send the built file to the client?
Thanks,
Ron Jolda
I am calling a procedure to build a large PDF file and returning the name of the file that was created.
If it was created successfully I want it to download to the client.
What are the steps to automagically send the built file to the client?
Thanks,
Ron Jolda