I have been stuck back on Version 9 build 1634 because that is about the last version that still worked without a hitch. I use this everyday and don't even know how to begin to get these bugs out so that I can move forward to Version 10 as the program is used everyday and I can't just stop life to change versions. Well I thought I'd try to see if I could get it to run under V10 and brought home an archive of my data and set out to see if I could make a go of it. Lots of problems with browses and now a function that works fine in version nine doesn't work at all in V10. Can someone look at this and tell me what is wrong with this. Why does it work good in V9 but refuses to Work in V10?
It is a simple function that returns a mark-up multiplier based on the department and cost of an item. What gives?
Also with the new browses, does deleting the browse and then recreating it in V10 fix the issues. Does version 10 have its own format for the browses that V9's will not work properly in them? I searched the forum to see if anyone spelled out the differences between the two version browses but could not find any info. My data files are large and alpha has always been backward compatible since version 2 or 3 and I have just been updating every time without a hitch. But now I got problems that were introduced with the upgrades starting halfway through V9 and now into V10.
If anyone can see a syntax error in this function or has had long running browses that just are now riddled with wierdness that information would be very helpful.
Finally, if I can get this archive copy to work, How do I update all the forms, browses, reports, functions etc. without overwriting my DBF data that is rapidly changing while I am mucking around with the upgrade?? Can someone point to a post or help file for that??
Thanks - Here is the function that only works in V9 and earlier
'Date Created: 06-May-2006 05:40:11 PM
'Last Updated: 06-May-2006 06:19:48 PM
'Created By :
'Updated By :
FUNCTION MU AS N (dept AS C, cost AS N )
dim t as P
dim qry as p
dim x as n
t=table.open("mu_matrix",FILE_RO_SHARED)
query.filter="MU_Chart=dept.and.cost>=lower.and.cost<=upper"
query.order=""
query.options=""
qry=t.query_create()
mu=t.mult
t.close()
END FUNCTION
It is a simple function that returns a mark-up multiplier based on the department and cost of an item. What gives?
Also with the new browses, does deleting the browse and then recreating it in V10 fix the issues. Does version 10 have its own format for the browses that V9's will not work properly in them? I searched the forum to see if anyone spelled out the differences between the two version browses but could not find any info. My data files are large and alpha has always been backward compatible since version 2 or 3 and I have just been updating every time without a hitch. But now I got problems that were introduced with the upgrades starting halfway through V9 and now into V10.
If anyone can see a syntax error in this function or has had long running browses that just are now riddled with wierdness that information would be very helpful.
Finally, if I can get this archive copy to work, How do I update all the forms, browses, reports, functions etc. without overwriting my DBF data that is rapidly changing while I am mucking around with the upgrade?? Can someone point to a post or help file for that??
Thanks - Here is the function that only works in V9 and earlier
'Date Created: 06-May-2006 05:40:11 PM
'Last Updated: 06-May-2006 06:19:48 PM
'Created By :
'Updated By :
FUNCTION MU AS N (dept AS C, cost AS N )
dim t as P
dim qry as p
dim x as n
t=table.open("mu_matrix",FILE_RO_SHARED)
query.filter="MU_Chart=dept.and.cost>=lower.and.cost<=upper"
query.order=""
query.options=""
qry=t.query_create()
mu=t.mult
t.close()
END FUNCTION
Comment