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.
271
Web Server - Ask For Help / View with hand coded join
« on: April 27, 2009, 01:42:48 PM »
Hi,
I have a view with many related files that works well and I see my records in a web browse.
I add a table (actually the alias of a table) to the View and write a join statement ( left outer join ) and now the Web Browse tells me that "there are no records".
I tried binding the field in the primary field but still no joy. Using C3.9054 .
My Primary table field is: JPSS:alt_prov_id
My alias table is : APROV
My Alias table is : APR:Provider_key ( keyed on APR:Number and unique)
My "Custom join" is: APR:Provider_Key, APR:Number=JPSS:alt_prov_id
Only a few records have a value for JPSS:alt_prov_id. Anyway, with a left outer join, it should present all the records in the primary View filter irregardless of the JPSS:alt_prov_id value.
Something is not right - is it my Custom Join Statement or does Net Talk not play well with Custom Joins on Alias tables???
Thanks,
Ron Jolda
I have a view with many related files that works well and I see my records in a web browse.
I add a table (actually the alias of a table) to the View and write a join statement ( left outer join ) and now the Web Browse tells me that "there are no records".
I tried binding the field in the primary field but still no joy. Using C3.9054 .
My Primary table field is: JPSS:alt_prov_id
My alias table is : APROV
My Alias table is : APR:Provider_key ( keyed on APR:Number and unique)
My "Custom join" is: APR:Provider_Key, APR:Number=JPSS:alt_prov_id
Only a few records have a value for JPSS:alt_prov_id. Anyway, with a left outer join, it should present all the records in the primary View filter irregardless of the JPSS:alt_prov_id value.
Something is not right - is it my Custom Join Statement or does Net Talk not play well with Custom Joins on Alias tables???
Thanks,
Ron Jolda
272
Web Server - Ask For Help / Run process on Server Side
« on: April 19, 2009, 02:29:09 PM »
Hi,
I need to run two processes on the server side - is this possible either with Net Talk or Net Talk to an outside Clarion exe on server that does the work....
1. I want to return a record for insert into a table - and on the server side I need to take pieces of it and populate two other tables.
2. I want to identify a group of records, each record having a link to a pdf file. I want to return the selected records to the server and have the server build a PDF file out of all the individual PDF files. I am using Tracker PDF tools to do the PDF build.
How could I get these two tasks done?
Thanks,
Ron Jolda
I need to run two processes on the server side - is this possible either with Net Talk or Net Talk to an outside Clarion exe on server that does the work....
1. I want to return a record for insert into a table - and on the server side I need to take pieces of it and populate two other tables.
2. I want to identify a group of records, each record having a link to a pdf file. I want to return the selected records to the server and have the server build a PDF file out of all the individual PDF files. I am using Tracker PDF tools to do the PDF build.
How could I get these two tasks done?
Thanks,
Ron Jolda
273
Web Server - Ask For Help / Re: Multiple users, multiple file sets
« on: March 30, 2009, 11:58:43 AM »
OK,
I follow you so far.
At the web handler level, do you query the Global queue based on the session ID and then set the path appropriately for each request - this assumes that the file is opened and closed with each thread. Is this the correct thought process?
Thanks,
R Jolda
I follow you so far.
At the web handler level, do you query the Global queue based on the session ID and then set the path appropriately for each request - this assumes that the file is opened and closed with each thread. Is this the correct thought process?
Thanks,
R Jolda
274
Web Server - Ask For Help / Multiple users, multiple file sets
« on: March 30, 2009, 03:01:29 AM »
Hi,
I am trying to understand on a high level, how the Net talk sever operates.
I would like to have different user groups log onto different directories with their respective data.
I can Set the path with the login by the company name.
I am trying to understand how the server handles each file request.
Does the server keep the files open ?
Are they open on a thread for each session?
Are they open and closed for each request?
DO I need to store the fully qualified file name in a session variable and send it with each request?
TIA,
Ron Jolda
I am trying to understand on a high level, how the Net talk sever operates.
I would like to have different user groups log onto different directories with their respective data.
I can Set the path with the login by the company name.
I am trying to understand how the server handles each file request.
Does the server keep the files open ?
Are they open on a thread for each session?
Are they open and closed for each request?
DO I need to store the fully qualified file name in a session variable and send it with each request?
TIA,
Ron Jolda
275
Web Server - Ask For Help / Re: icon or picture in browse
« on: March 29, 2009, 02:59:10 PM »
Hi,
It looks like we have to use a variable to hold the name of the image file - is that correct?
Do the sizes have to be set here?
Thanks,
R Jolda
It looks like we have to use a variable to hold the name of the image file - is that correct?
Do the sizes have to be set here?
Thanks,
R Jolda
276
Web Server - Ask For Help / icon or picture in browse
« on: March 28, 2009, 01:48:52 PM »
Hi,
I have a True/False field in my browse . If it is True, I want to display a checkmark.ico. If it is false, I want to display a cancel type icon.
How does one get these into the browse templates?
TIA,
Ron Jolda
I have a True/False field in my browse . If it is True, I want to display a checkmark.ico. If it is false, I want to display a cancel type icon.
How does one get these into the browse templates?
TIA,
Ron Jolda
277
Web Server - Ask For Help / setting value to use as filter in later browse
« on: March 27, 2009, 04:13:13 PM »
Hi,
I want to have the user give a numeric value when they log in. This will be the Site_id.
When they browse the records, I want to have them filtered by "site_id" so that they see only the records for their site.
Question:
When they enter their Site_Id at login, do I set it as a value in the session Queue?
Where do I set the embed to do that?
If I do, then how do I use that in the filter expression in the browse???
TIA,
R Jolda
I want to have the user give a numeric value when they log in. This will be the Site_id.
When they browse the records, I want to have them filtered by "site_id" so that they see only the records for their site.
Question:
When they enter their Site_Id at login, do I set it as a value in the session Queue?
Where do I set the embed to do that?
If I do, then how do I use that in the filter expression in the browse???
TIA,
R Jolda