Thank you for all your help and support guys. Ive really been blown away.
@jrbbldr - I have been using the !EMPTY check by itself and it is working as i had hoped. So thank you very much.
My final final final question (i promise!):
I have been adding this extra code to other currency fields...
PERFECT! (Well nearly!)
Thank you jrbbldr. I have ended up with:
ALLTRIM(TRANSFORM(VAL(STRTRAN(<method>,',','')),'999,999,999.99'))
Note: VALUE() was throwing an error, but googling around i found VAL() which works
The only issue is now, where before if i had inserted a blank line for...
Thanks for the continued support - i appreciate you all bearing with me!
@jrbbldr - I used your code (and have backups!) and oddly it returned "U"?! What datatype is that?!
As i said above, i can look into the data environment and locate the value of it_price which is not the same as the value...
Thank you for all your help - i really do appreciate it.
@MikeLewis - The problem with the code i had is that it doesnt always produce the right values when testing with old reports.
VERY oddly it seems as though the value it_value stores a price in cents (i.e. when the currency being quoted...
Thanks for the help jrbbldr
Ive opened the FRX file with VFP 9 and it looks pretty much the same as from within the ERP (guess it has VFP editor inbuilt) - but i still cant find a way to look at the source code and find these class definitions? Am i looking at the right file (i have an FRT and...
@OlafDoschke - Sorry i didnt see your reply before i posted. Thank you for the help.
Im editing the code within our ERP system (which to my knowledge, i cant introduce break points / debugg / copy or paste), should i be using some Visual Fox Pro Studio of some sorts?
What do you mean about...
Thank you for the response.
Is there any way i can find where the method (im guessing thats dispunit?) is defined?
I see what you are saying, but the old expression certainly seems very over the top wouldnt you agree? I would really like to understand and improve it
Hello Guys,
I have absolutely no experience with VFP but am trying to edit some of our reports (ie invoices, quotations etc).
The expression i am looking at pulls a price from a table (as a number) and then converts (divides by 100) to a currency. I wanted to clean up the code (as to me it...
Thanks for the replies guys. I followed intelwizrd's instructions but ran into a few problems (when the user logged in for a second time there was an access denied message on logon). This was all complicated by the fact that Windows had created a temporary profile that it kept forcing on the...
Hello all,
I have an XP Pro SP3 client with a corrupt profile. On right clicking My Computer > Properties > Advanced > Profiles, the profile has status "Backup"
What is the best way to restore this? I know there are lots of guides online (which i have read), but they dont seem to go into much...
Hello all,
Having an odd issue. Setup my SBS 2003 server fine, and tested all RWW and Exchange etc.
Now, im in the US for a couple of weeks, and when i logon on to my computer via RWW, i am prompted for my Username and Password, which is fine. I then select my personal computer and connect. I...
Heya,
This is really puzzling me... id really appreciate some help. Im starting to tear my hair out.
Setup:
Windows SBS 2003 R2 SP1 Server
Windows XP Pro SP2 Clients
Problem:
There are hundreds of Event ID 1091's logged in the clients event viewer, and new ones seem to appear around every 2...
Hello,
I want to achieve the following, and wonder if you could help:
1. A way that users can all have access to a shared mailbox (sales@company.com), where they can all send messages as sales@company.com and view the emails that are sent to that mailbox.
2. Setup a shared contacts folder, so...
OK... i already had the openDNS IPs in my Forwarders tab, and i added the servers from cache.dns to the root hints (servers A to M i think) and i *think* that seems to be the end of my constant 7062's! Hooray!
The only thing ive noticed so far is a couple of Event ID 113... is that anything to...
Sorry about the myriad of posts, but i removed my server from root hints and then, did the following to try to repopulate the list:
"right click the server name in DNS manager, choose all Task, configure a DNS server. The wizard will start up... click next then choose Configure root hints. It...
Thanks for the replies.
Ive removed the default gateway in TCP/IP properties so it is left blank. However, im still getting the 7062s and i think i can see sort of why. Ive been google'ing around, and i see in my server's root hints the only entry is the server itself.
Looking here...
I ran dcdiag, and netdiag, and ive attached the results. DCDiag looks fine. Not too sure about NETDIAG though.
I think the problem could be something to do with my defualt gateway or switch? The switch is a DLink DGS-1008D that i dont think has an IP address or management console.
Would it be...
Thank you for your reply.
Ive run the wizard, and am still getting these errors. Ive checked in DNS and to be honest i dont know what im looking at. I can post a screen shot if that would help. However, there is an _msdcs in the forward lookup zone only.
Im about to run DCDIAG and ill post any...
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.