Search results for query: *

Hi all, I'm having an issue with a "DELETE FROM... HAVING"... How can I make this command work please? delete * FROM bell_lns where newtob = .T. and HAVING COUNT('custno')>1 and custno in (sele custno from test1) Thanks, FOXUP

Hi All, I can't seem to remember the numeric equivalent of space () in a select. Here is my command: SELECT custno, SPACE(3) as type, SPACE(10) as bill_stat from test123 WHERE resto='5103' I need to add another field as numeric in there, so something like: SELECT custno, SPACE(3) as...

Hi, I have a strange behavior in a VFP Report that I never encountered before. Basically, when I do a print to "Microsoft Print to PDF" it comes out fine. When I do a print to "Adobe PDF" it comes out enlarged/magified and it's cut off. Am I missing something. Is there a setting in print...

Hi, I'm sending emails out thru VFP9 using CDO's. Everything works perfectly except that as of Feb-2024, Google insists that every email sent to Gmail users must have a DKIM signature. How do I add the DKIM signature to this code please. accno='000-000000' has_txt=.F. has_pdf=.F...

Hi, I have this script that works great except when I send to people who have there email at "anybody@google.ca". I've been reading that it's a TLS or SSL problem with my script. How do I fix it so that it uses TLS or SSL? Here is the script: LOCAL iMsg,iConf DECLARE SHORT...

Hi everybody, I need a simple optimization for these 4 lines of code. I would like to have it into 1 command instead (if possible). These are the 4 lines of code: USE C:\union\BOUNCE_SUP990\SOURCE sele id, VAL(callpathnm) as cps from C:\union\bounce_sup990\source WHERE val(callpathnm)>0...

Hello, I haven't used this in a while but what's the NUMERIC equivalent of SPACE(2) in an SQL command. I would need help with this example. Example: SELECT remark, min_users, SPACE(2) as temp FROM DBF() gives me a new Character Field of 2 characters long named "temp". I would...

Hi All, I'm getting "string too long to fir error" when I do this code: FOR i = 1 TO THISFORM.List1.LISTCOUNT IF THISFORM.List1.SELECTED(i) lcMessage = lcMessage + THISFORM.List1.LIST(i) + CHR(13) IF !EMPTY(lcMessage) xcount=xcount+1 ENDIF ENDIF NEXT cThisFileStr=''...

Hi, I have a particular issue with my Outlook. Here is what my Outlook looks like: 1 have 3 accounts, 1 is a GSuite account, the other 2 are IMAP. I can send and receive with all 3, easy peasy. I can't reply or forward with the 2 IMAPS. It gives me an error "Outlook could not...

Hi, Is there a variant of the VFP "COPY FILE" command where I can copy files that have changed on or after the specified date ? Example in DOS: XCOPY *.*/D:m-d-y Example in VFP: COPY FILE /D or something of the sorts? What would be the paramters in VFP if any? I don't see anything in the...

hi, I have recently changed my PC to windows 10 with outlook 2010. I have this code which worked fine on Windows 7-64 bit with outlook 2003. oOutLookObject = CREATEOBJECT("Outlook.Application") olNameSpace = oOutLookObject.GetNameSpace("MAPI") olFolder="G Suite - myname.myname@domain.ca"...

Hi All, Simple dbf with 2 fields (num, origin). I need to find the ones that origin = "P" only. P's with not C's. P's can only be alone. Sample dbf and sample result. can it be done in one query? sample ------ 123456789C 123456789P 587448988P 455774441P 147477991C result would be...

Hi all, I seem to have an issue with "alt-nnnn" keys result. When I press "Alt-159" in the vfp command window or in Notepad, I get the latin "f" symbol (ƒ) which is what I need. When i press "alt-159" in a character field in vfp , I get a "black square". Why is that and how can I get the...

Hi, A long time since I've asked for help but for some reason, this Query is racking my brain. MY.DBF looks like this PSRV, PSRVHOS, PLOCASOF, PLOCTO 3601 62619 01/01/2017 31/01/2017 3631 62619 01/01/2017 31/01/2017 35XD 62619 01/01/2017 35JY 62619 01/01/2017 3400 62620...

hi guys, I have a country_rate.dbf with 2 fields (country, rate). Here is an example data: country rate 1246 0.20 1246 0.23 1246 0.11 44 0.01 44 0.15 44 1.18 etc. I would need the result to be: country rate 1246 0.23...

Hi All, I have DBF called (USS.DBF) with 3 fields called (City, Prov, Pcode) (no index set, but the records are already in order by 'PCODE'). Here are 7 sample records: WESTWOOD, NJ, 07675 OLD TAPPAN, NJ, 07675 RIVER VALE, NJ, 07675 RIVERVALE, NJ, 07675 WOODCLIFF LAKE, NJ, 07677 WESTWOOD...

Hi All, I have code below that works perfectly. I would simply need to change the "FONT TYPE & FONT SIZE" of the body of the email body being sent. Here is my code: has_txt=.F. LOCAL iMsg,iConf DECLARE SHORT InternetGetConnectedState IN wininet.DLL; INTEGER @lpdwFlags, INTEGER dwReserved...

Hi, I have a table (dbf file) that contains 15 fields. One field is a unique field called "ID", another field is the one called 'callpath' which is a numeric value of 1-500. What I would need is fairly simple but can't seem to be able to wrap my head around is basically a copy of that exact...

Hi All, I have a .DBF which has 4 fields. They are: "ID", "HGROUP", "LEVEL", "EMAIL". What I would like to get is the "email" by finding the lowest of the "LEVEL", then "ID" for a particular "HGROUP". Here is an extract of .DBF values: ID HGROUP LEVEL EMAIL 237 44 2...

Hi, I have questions about the 2 GIG .DBF size limit. Has anybody passed or obtained that ? I mean what happens exactly @ 2 GIG? Has anybody passed it? Is it "exactly" 2 GIG (aka 2,097,152 KB exactly). The reason I ask is that I have a DBF that is 2,091,808 KB. Can anybody descrive the...