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.
Pages: [1]
1
Web Server - Ask For Help / Re: Locators
« on: February 20, 2015, 06:43:17 AM »
Thanks Bruce for your response
1º yes I knew what you say to customize the locator prompt in the settings of the server procedure but when I do this my text is added to the text that appear when I select the locator column, and the problem is if i have various locators in the app, i woud like to customize each one individually. For example :
This is how i see the prompt after customization :
Nº Artículo/Cód Barras : Nº Artículo:
Nº Artículo/Cód Barras : my customization
Nº Artículo : Added when i select the locator field, its the same as the column heading
If i hide the prompt locator all disappear.
2º the idea that i have in mind is that when i enter 19600 and the searh begins it refresh the locator content to 0000019600, using contains as you say it works fine but don't complete the locator content as i would like
Thank you very much
Ruben
1º yes I knew what you say to customize the locator prompt in the settings of the server procedure but when I do this my text is added to the text that appear when I select the locator column, and the problem is if i have various locators in the app, i woud like to customize each one individually. For example :
This is how i see the prompt after customization :
Nº Artículo/Cód Barras : Nº Artículo:
Nº Artículo/Cód Barras : my customization
Nº Artículo : Added when i select the locator field, its the same as the column heading
If i hide the prompt locator all disappear.
2º the idea that i have in mind is that when i enter 19600 and the searh begins it refresh the locator content to 0000019600, using contains as you say it works fine but don't complete the locator content as i would like
Thank you very much
Ruben
2
Web Server - Ask For Help / Locators
« on: February 20, 2015, 03:08:03 AM »
Hi all
Two questions
1º Is possible to customize the locator prompt ?
2º This locator is over a string(10) field (NroArticulo). The contents of that filed in the database is completed with leading zeros, for example the Nro = 19600 is saved in the database as 0000019600.
Is posible in the locator enter 19600 and it automplete with leading 0s for doing the search ?
Thank you very much
Ruben Caporossi
Two questions
1º Is possible to customize the locator prompt ?
2º This locator is over a string(10) field (NroArticulo). The contents of that filed in the database is completed with leading zeros, for example the Nro = 19600 is saved in the database as 0000019600.
Is posible in the locator enter 19600 and it automplete with leading 0s for doing the search ?
Thank you very much
Ruben Caporossi
3
Web Server - Ask For Help / Re: size of browse column
« on: February 20, 2015, 01:51:25 AM »
Bruce,
Thank you for your response. You are right this column is not necesay in the browse for ordering, i delete it and the order is working ok.
This is a calculated column in an immemory,not a file column, i suppose (wrong) that this column was necesary to populate in the browse for ordering
Thank you very much again
Ruben Caporossi
Thank you for your response. You are right this column is not necesay in the browse for ordering, i delete it and the order is working ok.
This is a calculated column in an immemory,not a file column, i suppose (wrong) that this column was necesary to populate in the browse for ordering
Thank you very much again
Ruben Caporossi
4
Web Server - Ask For Help / size of browse column
« on: February 19, 2015, 04:21:57 PM »
Hi all
I need hide a column in a netbrowse, i'm using it for ordering so i need it to stay but hide. Is it possible ?
Thanks
Ruben Caporossi
I need hide a column in a netbrowse, i'm using it for ordering so i need it to stay but hide. Is it possible ?
Thanks
Ruben Caporossi
5
Web Server - Ask For Help / Re: Where populate an immemory
« on: February 18, 2015, 03:21:34 PM »
Great !!! it's work fine adding SessionID to the unike key of the inmemory file
Thank you very much CaseyR
Thank you very much CaseyR
6
Web Server - Ask For Help / Re: Where populate an immemory
« on: February 18, 2015, 03:09:02 PM »
Thanks for your response CaseyR
The problem is that the original file is untouchable, but I could define in the inmemory a new key that involves the sessionid. I'll try this ...
Ruben Caporossi
The problem is that the original file is untouchable, but I could define in the inmemory a new key that involves the sessionid. I'll try this ...
Ruben Caporossi
7
Web Server - Ask For Help / Where populate an immemory
« on: February 18, 2015, 04:31:37 AM »
Hi all
I developed a web server application based in a file that has 39000 registers. All works fine. But due i need to order the browse in a special format i decided to use an inmemory file in which i can add special fields for doing the special order. I added a field SessionID in the inmemory file to save the session id,ok
I populate the inmemory in the 1.Generate browse embed point, this works fine, but when i try to make a second access to the web browse (for example from my ipad) the server gives me a duplicated key error, i suppose that is because it is populating the data in the immemory file twice.
My question is where is convenient populate the inmemory, is there a place where it populates only one time for all the conections or i'm wrong width this concept. ?
I try to compare how works the browse over a disk file and over an imemory file but don't understand how it is
Other thing that i noted, using a browse disk file is faster comparing with the inmemory use
It's correct what i'm doing ? I hope you understand my problem
Thank you
Ruben Caporossi
I developed a web server application based in a file that has 39000 registers. All works fine. But due i need to order the browse in a special format i decided to use an inmemory file in which i can add special fields for doing the special order. I added a field SessionID in the inmemory file to save the session id,ok
I populate the inmemory in the 1.Generate browse embed point, this works fine, but when i try to make a second access to the web browse (for example from my ipad) the server gives me a duplicated key error, i suppose that is because it is populating the data in the immemory file twice.
My question is where is convenient populate the inmemory, is there a place where it populates only one time for all the conections or i'm wrong width this concept. ?
I try to compare how works the browse over a disk file and over an imemory file but don't understand how it is
Other thing that i noted, using a browse disk file is faster comparing with the inmemory use
It's correct what i'm doing ? I hope you understand my problem
Thank you
Ruben Caporossi
8
Web Server - Ask For Help / Re: Updating a Browse contents from a spinner control
« on: August 15, 2013, 03:51:05 AM »
Thanks Bruce
I'll try all the things you say
Cheers
Ruben
I'll try all the things you say
Cheers
Ruben
9
Web Server - Ask For Help / Re: Updating a Browse contents from a spinner control
« on: July 30, 2013, 08:00:06 AM »
OK Bruce
After fixing the errors you told me, nothing happens, the browse don't refresh after changing the year in the spinner. Other thing i noted is if i press the last button after changing then year in the spinner, the browse refresh but when i press again it works wrong. I see the contents for the 2013 year at startup but then the refresh don't work.
Really i don't know what to do ...
Ruben
After fixing the errors you told me, nothing happens, the browse don't refresh after changing the year in the spinner. Other thing i noted is if i press the last button after changing then year in the spinner, the browse refresh but when i press again it works wrong. I see the contents for the 2013 year at startup but then the refresh don't work.
Really i don't know what to do ...
Ruben
10
Web Server - Ask For Help / Re: Updating a Browse contents from a spinner control
« on: July 29, 2013, 11:44:41 AM »
OK Bruce thank you for your response.
The situation is :
Spinner and LOC:Year both fields of the netwebform
In the ValidateValue Routine of LOC:Year ... Start, the following code
p_web.SetSessionValue(LYear,LOC:Year)
In the generate form 1.Start
p_web.setsessionvalue(LOC:Year,YEAR(TODAY()))
p_web.setsessionvalue('LOC:Year',YEAR(TODAY()))
If i comment the second line, the value of LOC:Year don't appear in the control in the screen. Why ?
In the NetWebBrowse Procedure Setup
LYear = p_web.GetSessionValue(LOC:Year)
Cargar_IMBuques(p_Web,LYear)
Cargar_IMBuques is a Source procedure that contains the Query for loading the inmemory that i use in the netwebbrowse
Then in the Client-side of LOC:Year in the NetWebForm i included in the Reset List Cargar_Buque and tick Value
Cargar_IMBuques Proc
p_web and pyear : parameters
p_web._trace('Loading from Firebird : ' & PYear) ! Here PYear is well received when i change the value in the spinner
DO OpenFiles
CLEAR(SQL)
LOC:Query = 'SELECT NROORDEN,CODPUERTO,BUQUE,VIAJE,SIGLA,TEMPORADA FROM BUQUES WHERE TEMPORADA = ' & PYear
SQL{PROP:SQL} = LOC:Query
IF FILEERRORCODE()
SETCLIPBOARD(LOC:Query)
MESSAGE('ATENCION !!! : ERROR de Lectura. ' & FILEERROR(),'ERROR',ICON:HAND,BUTTON:OK)
MESSAGE(LOC:Query)
ELSE
LOOP UNTIL ACCESS:SQL.NEXT()
IMBUQ:NROSESSIONID = p_Web.SessionID
IMBUQ:NROORDEN = DEFORMAT(SQL:C1)
IMBUQ:CODPUERTO = SQL:C2
IMBUQ:BUQUE = SQL:C3
IMBUQ:VIAJE = SQL:C4
IMBUQ:SIGLA = SQL:C5
IMBUQ:TEMPORADA = DEFORMAT(SQL:C6)
Access:IMBUQUES.Insert()
END
END
DO CloseFiles
Cheers
Ruben
The situation is :
Spinner and LOC:Year both fields of the netwebform
In the ValidateValue Routine of LOC:Year ... Start, the following code
p_web.SetSessionValue(LYear,LOC:Year)
In the generate form 1.Start
p_web.setsessionvalue(LOC:Year,YEAR(TODAY()))
p_web.setsessionvalue('LOC:Year',YEAR(TODAY()))
If i comment the second line, the value of LOC:Year don't appear in the control in the screen. Why ?
In the NetWebBrowse Procedure Setup
LYear = p_web.GetSessionValue(LOC:Year)
Cargar_IMBuques(p_Web,LYear)
Cargar_IMBuques is a Source procedure that contains the Query for loading the inmemory that i use in the netwebbrowse
Then in the Client-side of LOC:Year in the NetWebForm i included in the Reset List Cargar_Buque and tick Value
Cargar_IMBuques Proc
p_web and pyear : parameters
p_web._trace('Loading from Firebird : ' & PYear) ! Here PYear is well received when i change the value in the spinner
DO OpenFiles
CLEAR(SQL)
LOC:Query = 'SELECT NROORDEN,CODPUERTO,BUQUE,VIAJE,SIGLA,TEMPORADA FROM BUQUES WHERE TEMPORADA = ' & PYear
SQL{PROP:SQL} = LOC:Query
IF FILEERRORCODE()
SETCLIPBOARD(LOC:Query)
MESSAGE('ATENCION !!! : ERROR de Lectura. ' & FILEERROR(),'ERROR',ICON:HAND,BUTTON:OK)
MESSAGE(LOC:Query)
ELSE
LOOP UNTIL ACCESS:SQL.NEXT()
IMBUQ:NROSESSIONID = p_Web.SessionID
IMBUQ:NROORDEN = DEFORMAT(SQL:C1)
IMBUQ:CODPUERTO = SQL:C2
IMBUQ:BUQUE = SQL:C3
IMBUQ:VIAJE = SQL:C4
IMBUQ:SIGLA = SQL:C5
IMBUQ:TEMPORADA = DEFORMAT(SQL:C6)
Access:IMBUQUES.Insert()
END
END
DO CloseFiles
Cheers
Ruben
11
Web Server - Ask For Help / Re: Updating a Browse contents from a spinner control
« on: July 26, 2013, 06:40:24 AM »
Thanks Kevin and Bruce.
The problem was the variables i'm using. After some changes with the Trace y verified that the content of LOC:Year is ok in the Query to the database. If I modifiy the spinner contents the correct value arrives to the query, but in this moment the problem is that the browse don't refresh in the browser. Using hand-coded programming what do I do for refreshing the browse contents ?
Navigating across the browse i noted that the registers read when i change the spinner are appended to the browse, i need to see only the filtered for this year. I tried to clean the immemory file but the problem persists ...
Thank you very much
Ruben Caporossi
The problem was the variables i'm using. After some changes with the Trace y verified that the content of LOC:Year is ok in the Query to the database. If I modifiy the spinner contents the correct value arrives to the query, but in this moment the problem is that the browse don't refresh in the browser. Using hand-coded programming what do I do for refreshing the browse contents ?
Navigating across the browse i noted that the registers read when i change the spinner are appended to the browse, i need to see only the filtered for this year. I tried to clean the immemory file but the problem persists ...
Thank you very much
Ruben Caporossi
12
Web Server - Ask For Help / Updating a Browse contents from a spinner control
« on: July 25, 2013, 11:22:16 AM »
Hi All
Situation : One NetWebForm procedure with a spinner and a browse hand coded. The browse is using an inmemory driver that is loaded using a query at the procedure setup to a Firebird database. The query is filtered with a PYear variable All works fine. I initialize the year in the spinner and at the first time when the page opens i see all the registers corresponding to that year. But when i modify the spinner content, the browse doesn't refresh. Please something knows in what embed point of the spinner i can read the variable used in it ?
From the Form to the browse i'm using the value queue for passing the parameters. In the form, previous to the call to the browse if i force the value of the variable it works fine, but using the spinner no
Thank you
Ruben Caporossi
Situation : One NetWebForm procedure with a spinner and a browse hand coded. The browse is using an inmemory driver that is loaded using a query at the procedure setup to a Firebird database. The query is filtered with a PYear variable All works fine. I initialize the year in the spinner and at the first time when the page opens i see all the registers corresponding to that year. But when i modify the spinner content, the browse doesn't refresh. Please something knows in what embed point of the spinner i can read the variable used in it ?
From the Form to the browse i'm using the value queue for passing the parameters. In the form, previous to the call to the browse if i force the value of the variable it works fine, but using the spinner no
Thank you
Ruben Caporossi
Pages: [1]