This is probably a simple answer. I have a grid that is read only, except for one column when the program starts. At one point to edit all the items in the grid I have :
thisform.Grid1.ReadOn...
I have a Firebird database. How can i implement a chart with the data from a datagrid in VFP9, and then create a report wich includes the data from the grid and the graph?
I need to encrypt a data value in a visual foxpro 9 appliaction and later decrypt it on a cold fusion web page. The encrypted value is passed to the cold fusion page via a URL argument. The ...
I need to convert some Visual Fox Pro tables to MS SQL. I have a copy of VFP 9.0 and can see data in the tables. Unfortunately some of these tables contain invalid SQL column names and I need ...
I am trying to re-write some code intended for VB to Visual foxpro, to call a DLL and return some data from it. The fox code is running without error, but not returning data from the DLL. I ...
Experts:
I have a VFP 8 application that is Orders Maintenance and is driven by a VFP table named Orders with the key field Ordnum C(10) (of course!)
I have a SQL Server 2000 table named Sup...
HI:
An unusual question; I have a text file exported from visual foxpro. It includes the column headers but the requirement of the import file is that the headers be quote delimited and prope...
Hi Expert
I would like to run a small programme every hour on the hour automatically.
I have a menu and it is called from a prg as below.
public security
security=9
Do aMENU.mpr
Store ...
I am new to the Visual oops environment found in fox 9 and am leaning to build forms. I have spent all day trying to add a drop down combo box to a form. Using the "Add method" I am told to po...
Hi Experts
I have working folders in my c:\temp folder and I like to delete all unknown folders when I quit VFP9 sp2.
I have tried using Delete Files *.* command which deletes all files in...
I have an older 2000 server that has a FoxPro 5.0 app running on it. I want to upgrade server to SBS 2003 or SBS 2008. But I can't seem to determine if FoxPro 5.0 is compatible. Anybody know f...
Hello experts :)
I'm looking for the right syntax to fire a stored proc in Oracle from vfp9.
i've tried the CALLsyntax producing the folowing error:
Connectivity error: [Oracle][ODBC][...
I have variable that has this stored ( ICP123.LP ), I WOULD LIKE TO SUBTRACT left character befoe '.' i.e ICP123 '
'.' postion moves all the time . next time it may have stored (ICP12.LP)
P...
I'm trying to learn how to use @ r.c CLASS since I don't want to completely rewrite my foxpro app. The following code in the next block work fine except where I've placed the question 'How do ...
Hi
This works when QC != 'XXX' but does not work when EMPTY(QC) not sure why.
oGrid.SetAll("DynamicBackColor", "IIF((QC != 'XXX' or EMPTY(QC)), RGB(255,255,200), RGB(255,255,255))", "Col...
HI EXPERT
is there a command that give you the last day of the given month.
for example gomonth(date(),-3) will give me 10/08/2009
but i need last date in that month i.e ...
Hello all,
I'm going to lose my mind if someone can't figure this out for me.
I'm using VFP9 SP2 on Win7 Ultimate x64.
In my code I select records from a DBF into a cursor. I then sca...
While trying to trace the cause for one issue I inadvertently caused another. When I try to build an executable from the pjx I get the error message Cannot build without a main program. Any ...
I am an ancient Access user - can make Access reports turn flipflops. But I am new to FoxPro.
We have purchased a system that was developed in FoxPro and it allows us to create custom repor...
With fox 9 if you create a form using the form wizard you get a button set .
They Are Top/Prev/Next/Bottom/Find/Print/Add...etc. I am curious to see the code the runs behind them so that I...
connectionstring for connecting foxpro 3.0 (.dbf) file with VB.Net 2008
I have 100 customers (order by custnum) and each one can have one order or multiple orders that day. So today I end up with 235 lines for the 100 customers.
I query my order lines and group...
I want to email reports to employees. I am trying to create a click event using a button that will find a pdf file in a specific folder, then send it by email. I already have the email part so...
Hi Experts
In memo field as below
12/09/2009In(0).INC.=-1.TO(MB1)PR.=35.28..B.l
12/09/2009In(0).FAUL.=-1.TO(MB1)PR.=35.28..B.l
12/09/2009In(0).Cred.=-1.TO(MB1)PR.=35.28..B.l
12/09/2009In(...
when using the following command:-
select * from docket where invoice='602'
it gets all the records where invoice = 602 and invoice is blank, due to invoice being a varchar field. if i...
