within a stored proc:
use 'bcp' out... then create a variable @currdate-(representing its filename); you might as well implement the dateadd function (to increment date in filename).
avn
rraney,
try storing the parameter value to a variable then use that variable in passing it through a formula.
dim x
x=Stored_proc_param_value
crystal1.storedprodparam(0) = x
crystal1.formula(0)={x} ---> check parameters of this property
avn
mwhalen,
instead of using a recordset, use the querydef property of the crystal control. It is also possible for you to pass your global variable to be use in your crystal report formulas.
e.g.
crystal1.querydef="select * from employee"
crystal1.formula(0)={name_of _d_variable...}
foxpro 2.6 is limitted when it comes to handling open databases. Try closing some of your open databases or rather open the database when needed only then close it immediately. This will free up a big space from your memory.
Hope this make sense...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.