Information générale
Titre:
How do I base a textbox on an SQL statement?
Hi. I have a form with a grid. The grid shows products. I want to add a column to show the average days in the warehouse. My warehouse data contains a date so I want the SQL to be:
select cpartno, avg(date()-indate) as avgdays from whcuinvbin group by 1 having cpartno = THISFORM.THISGRID.COLUMN1.txtPart.Value
I do not want to change this grid to be based on a view, because of the way I need the whole thing to operate. I think I could fool foxpro by creating a combobox but can I do this with a textbox?
Thanks for the help
Sandi
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement