Hi ,
I have a query based on multiple tables. I have a query based on multiple tables.
This is my query :
'Date Created: 16-Aug-2009 07:26:01 PM
'Last Updated: 16-Aug-2009 08:43:43 PM
'Created By : Cristiano
'Updated By : Cristiano
dim filter as c
dim order as c
dim options as c
dim description as c
dim show_all_flag as L
dim layout_name as c
dim layout_type as c
filter =" (month(data) = 8 ) .and. (inventory->Description = var->ASKC_Prodotto )"
order = "recno()"
options = ""
description = "Saved Query: Qu_8_per product"
show_all_flag = .f. 'user cannot turn off the query
layout_type = "browse" 'to open a form, set this to "form"
layout_name = "brw_invoice" 'This will open the default layout. You can also specify a named layout here
dim args as sql::arguments
if eval_valid("arguments") then
if typeof(arguments) = "P" then
args = arguments
end if
end if
a5_open_layout(layout_type,layout_name,"s_invoice.set",filter,order,description,options,show_all_flag,args)
Now I need to create a calculate field for a single product that was sold in a specific period of time ( normaly 1 month)
Do you have any suggestions, because I tried to create a form based on this query, but the query created 'on fly' it work, the other one created into the form no
How I can create a calculate filed for my query
I have a query based on multiple tables. I have a query based on multiple tables.
This is my query :
'Date Created: 16-Aug-2009 07:26:01 PM
'Last Updated: 16-Aug-2009 08:43:43 PM
'Created By : Cristiano
'Updated By : Cristiano
dim filter as c
dim order as c
dim options as c
dim description as c
dim show_all_flag as L
dim layout_name as c
dim layout_type as c
filter =" (month(data) = 8 ) .and. (inventory->Description = var->ASKC_Prodotto )"
order = "recno()"
options = ""
description = "Saved Query: Qu_8_per product"
show_all_flag = .f. 'user cannot turn off the query
layout_type = "browse" 'to open a form, set this to "form"
layout_name = "brw_invoice" 'This will open the default layout. You can also specify a named layout here
dim args as sql::arguments
if eval_valid("arguments") then
if typeof(arguments) = "P" then
args = arguments
end if
end if
a5_open_layout(layout_type,layout_name,"s_invoice.set",filter,order,description,options,show_all_flag,args)
Now I need to create a calculate field for a single product that was sold in a specific period of time ( normaly 1 month)
Do you have any suggestions, because I tried to create a form based on this query, but the query created 'on fly' it work, the other one created into the form no
How I can create a calculate filed for my query
Comment