To all,
I am trying to use the locate command
I have the following code below
but it is not finding the information everything is coming back false.
I don't understand it because ...
Now here's a challenge. I'm using print2pdf to print directly to a pdf file. I'm trying to print schedules for various workers. i've got the print2pdf working. Now i need it to print a separat...
I RDP into a standalone computer to run an old version of FoxPro 6.0. The information used to be stored on our K drive. It is now on our M drive. When I click on Program Do and click my exe...
I need a simple SQL query to provide the total at the beginning of a record set.
I'm transferring data between systems and the receiving system needs the total of detail records in the firs...
Hi, I must create a Procedure to Export a Cursor from Visual FoxPro into a File (With MEMO FIELDS) and Import it in another remote Clients.
I try to use COPY TO (myFileName) CSV but the memo ...
Is there a way to use the debuger on code used in events. For example the code in a click event. It would make things easier in testing.
I am using the calender control 12.0 included with VFP9 to create a popup calendar to select a date then return to my main form. The Calendar control 12.0 is returing the correct date but is a...
Table Name: z_mrm_turns. Table exists and has write priviledges and has SEQ_KEY as PK. The debug in Oracle SQL Developer tells me I have unrunnable source. I have a syntax issue. Any help...
Hi Foxpro Experts,
I'm modifying some code and would like to get a list of the open aliases in the current session. There are a lot of tables open and it would be cool to be able to print a...
Hi
If i use date() it give me mm/dd/yy can i change it to mm-dd-yy?
In an environment of multiple users of a large VFP app there is one user reporting that when he tries to save a date in one object of the app in may get this message: CTOD and CTOT can produce...
In a VFP application -
in the Form Init method - I am setting the rowsource and the rowtype of a combo box to an array. The array is also defined at the top in the form Init method. In the ...
Hello Gurus,
I have an application vpf9 that creates a customer statement using vf9 built-in report.
I have 2 pb.
1-I need the report to always open in full screen..
2-I need the report t...
I have set up some Text Boxes which make use of the Autocomple Alpahbetical option-1. They work great. Only problem I am having is when I pick an item form the list which is already stored. Th...
I have a sqlexec() to cursor and I see all my records (20 rows)
sqlexec() errros when I try to use SUM(add 12 fields)
so I select the cursor and do it in the vfp select but now it is sum o...
I can grab the orders with the oline='FREGHT' but now I want to get only the ones that have oline='FREIGHT' > 1
Hi,
I'm writing a Foxpro application and I need to know how to Stop/Start/Check the Status of a Windows Service. I can do the stopping and starting by running DOS commands, but I'm not sur...
Last evening I was adding a form to my program that would allow me to select from a list of reports and then obviously print the report. Everything worked great on my programming computer, but...
Guys, we have a situation where our DATABASEs in a project have a number of stored procedures. They work great. But, we have ONE situation where we do not want the Stored Procedures to "fire...
I need a better way to accomplish a search. From a main form, I open a small form that allows me to select a customer name from a drop down list. Once I select the name from the list, it appe...
i have VFP 5.0 Professional an dhave a problem when i try to set up a print command to a file:
REPO FORM LIH3 FOR PROP="13" TO F:\DCA\XXX\YYYY\FILE-NAME .TXT ASCII. (DOS)
the report cre...
I need to add field in foxpro 2.6 database using ODBC driver which is character field and being
2.6 does not support null. However I want to add value where first three characters are empty...
vfp 9 sp1 application
distibuted with mscal.ocx dated 02/10/05
user gets error message ( Do not know what version of Windows. )
Error Number: 1426
Error Message: OLE error code 0x80020...
so I select * from myTable alias myAlias
select top 20
replace all counted with .t.
*-- now I need to update myTable with the matching records while the rest stay.
1. get data from...
Hi,
If I have a message as beloow;
"T1000[BBBBBB|kkkkkk|0123456|20050131123632] ~ 1|"
And I need to get the sum of all the data what command would be best to get the numeric value of ...
