I posted here yesterday trying to get parameters into a SQL statement... but I'm now using a completly different method. First, I should mention I'm using Visual Foxpro ODBC using free tables.
I need to pull maximum expiration dates on employee training... and I was successful in doing so...
I'm trying to use parameters within an SQL Query... but I'm not being very successful. The SQL query below is very complex, which is why I'm trying to do this. Should I even try a different method, or is there a way to get parameters in the SQL?
Thanks for any help you have in advance.
(I...
I was hoping to easily draw lines and dots in this window I'm forming. But Visual Foxpro refuses to draw them... in my opinion. :)
CODE PIECE:
thisform.ForeColor = RGB(255, 0, 0)
thisform.ForeColor = RGB(255,255,255)
thisform.ForeColor = RGB(255, 0, 0)
FOR lnI = 1 TO 200
FOR lnJ = 1 TO 200...
I'd like to see the line/column position of all the edit boxes, except I have to go into the code window's edit properties window over and over and over and over...
Is there a sure-fire way to get the line/column position shown on the status bar permanently? Or at least for the entire project...
Mike: thanks for the oForm.show(1)
Craig: Thanks for the _screen suggestion... that worked too. And yes - I'm in the wrong forum - my bad. I'll try to get it right next time.
Thanks for your replies. It works..... sort of.
The form appears, then immediatly vanishes. After this event I'm working with completes execution, for some weird reason, the destroy method gets called.
I also want the code to stop after I do the loForm.show() because I want the...
OK, I'm probably having a duh moment...
I know I can do a:
DO FORM vipervendsel WITH ThisForm.pgfrmPO.pgGenrlInfo.c.txtVendor.value, "C", thisform.pgfrmPO.pgGenrlInfo.c.cboOffice.Value TO lcVendor
But I want this particular form in a class seeing that it's being used by more than one program...
I'm trying to drag a container to anywhere in a form. I'm successful in doing so, but not before having some 150 dragdrop methods in every single control (a three page pageframe that do quite a bit of stuff in each page) that do the same thing:
LPARAMETERS oSource, nXCoord, nYCoord...
Hmmmm... I think I fixed it. It's a WHERE blah IN () clause, and I think inside the parentheses I had numbers that should have had quotes on both sides, but didn't. (I had ('16C, 16C, 16C, 16C... 16C'), I should have had...
Well I've got this massive select statement... well not beating the 8,192 character limit I wager, but still...
I'm having a problem with the lc_where macro substitution. This SELECT SQL statement works fine until the lc_where variable exceeds 255 characters, then I get an "unrecognizable...
I'm attempting to be able to print a TIFF file with the Kodak ActiveX Control. (the PrintImage method) I'm successful, save one problem: it uses the default printer, and the default settings.
My superiors would like to have the ability to print in landscape mode. I'd like to have this...
I know it's possible to use VFP for GroupWise use... but I'm writing this program for one of my co-workers, and this person was wondering if he could tack on his signature to his e-mail.
Is this possible? Better yet, is there a place where all of this is documented? (even Novell's site isn't...
Ramani:
I solved my own problem - I had to use UNC because... that's how Netware Servers work; I don't assume drive letters... but I guess the particular UNC I was using was too long or something? I tried a shorter UNC and it worked fine.
I guess it had to be one of those limitations I keep...
In the load event of this form: PUBLIC oWord
When I unload: RELEASE oWord
When I want to edit a proposal or two, I use this block:
TRY
oWord.Documents.Open(***)
CATCH && In case there's no Word open or Word was closed
oWord = CREATEOBJECT("Word.Application")...
Hi Ramani - unfortunatly, this didn't work all too well, you see I have to *really* squeeze in all of this information into one page. (and it's been done before, but it hasn't been done with VFP8SP1 yet) Apparently if any line is greater than 255 characters, the report quits altogether.
Any...
I'm trying to print one memo field on a report. (stretching w/ overflow is on) When I use a Courier New font, the whole thing prints, but when I use any other font, the report will print two lines just fine; I think they're less than 255 characters, but then the report quits printing after 255...
The weirdest thing is going on here, but I'm going to try to be as detailed as possible. I'll list the exact error below a starred (*****) line.
I have two tables in this database that are linked to two grids. I'll call them TblA and TblB for security reasons.
TblA has, in order: C(9)...
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.