Search results for query: *

Has anyone had any luck with Merant's drivers and Visual Foxpro? (I'm running VFP 8 on Win2k) When I try to create a remote view to a table containing a hyphen in the name it gives me this error: Table/View/Synonym not found (7519) I can do a SQLExec command and get data from tables...

I tried searching with no luck. I would like to sort a table based on 3 numeric fields with values like: Col1 | Col2 | Col3 ------------------- .75 | 103 | 299.5 To create an index on these three fields so that they are sorted ascending, do I have to convert them all to strings and...

(VFP 8.0) I use menus (via the DO Main.MPR method called within my main.prg) in a program and would like a menu item listing all the open forms. Some forms can open more than once (multiple instances/copies). Is there a good way to accomplish this? I assume you could use the system menu...

Using VFP 8 on Windows 2000, I have been unable to programmatically connect to an AS/400 without manually typing in a password. I am using IBM's Client Access Express. I'll be using SQLExec() commands over this connection. I have tried creating a connection in the DBC using both the Data Source...

In Fox 6, I am doing a SQL passthru command to get a table's structure from SQL Server 7, making the resulting cursor modifiable, and then setting several textboxes' ControlSource to the various fields. The date field in the cursor has the long date format that includes time. I would like the...

Assumptions: VFP 6 hitting SQL SERVER 7 If you have a remote view in your DBC in a multi-user environment (multiple users modifying different records in same table) is it possible to have some textboxes bound to that view with save and cancel buttons? That is, the user can choose to edit a...

I have VFP6 SP5 and would like to install VB6. When trying to install it, I get a warning that VFP may not run correctly after installing. I'm running Win2000 Professional. Has anyone had any experience with both on one system?

In VFP6, I have a report that is grouped by a numeric field called Cnum. This Cnum field is showing in the header and footer of each page. It starts a new page for each Cnum grouping. In the group footing for Cnum I have to show some fields which stretches that footer to about 2 inches...

I am interested in having VFP 6 to "type" data into a client access terminal session. To do this, it would have to be able to read certain lines to verify the correct screen is being displayed and whether the terminal is locked due to an inappropriate key being pressed. Any suggestions?

I have a report that is created via multiple tables (with relationship links) in a data environment and a few variables. I would like to save this report to a file so I could reprint it again, just the way it looked originally. I tried using the REPORT FORM .. TO FILE command, but it gets...

I have some users who complain that some fields auto-adds a zero in certain numeric fields. What happens is, they enter in 80 and end up with 800. Other users have no problem with this (odd, i know). They put in one field's value, hit enter, enter the next field value, hit enter.. so that's the...

I am attempting to use a runtime-created form to accept input. I'm finding the labels on the form don't show the correct text, but rather the text from the previous runtime-created form. Any suggestions? frm = CreateObject ("Tform") frm.Show(1) DEFINE CLASS Tform As Form...

I have a compiled (.EXE) program that utilizes a .DBC and I would like users to be able to create a new instance (copy) of the program with blank tables. The program's files are in folders as such: Program/Data Program/EXE Program/Menus Program/Forms etc. I have made a small program which...

I have an .MPR (menu program) which runs within a compiled program (.EXE w/ VFP 6.0). A "Read Events" is called after starting the .MPR. I have a .prg file that creates an 'ad hoc input form' (using CreateObject) to ask the user for input. A menu drop-down calls the .prg for the ad hoc...

I have a table which has a Job_No field. The table has an index on Date as well as on Job_No both in ascending order. I want to get a list of distinct Job_Nos in reverse order of their occurrence in the table. This is a fairly large (70k records) table so I'm looking for a simpler method without...

I have a report in Fox 3 that's used by several users and is supposed to show their signature (a .bmp file) at the bottom. Currently, I am using one report with several .bmps on top of each other, displaying only the correct one. However, this is very difficult to maintain. Is it possible to...

In VFP6, I have a report with a fairly large summary band. Occasionally, the footer prints on a new sheet without the header at the top (because there's no detail records to display, I presume). The footer is comprised of text fields containing variables, not table data. I suppose one solution...

On a win98 machine running VFP6, I am getting results on a date field in this sql out of order: sele date from timehist grou by date (Date = a date field) settings: set cent on set stri to 0 (I even made the time/date format MM/dd/yyyy in the control panel) The table has index, but isn't...

* - This code works CLOS ALL USE TableA IN 0 && Currently selected table USE TableB IN 0 REPL ALL Misc WITH 99 IN TableB * - This code only changes the first record in TableB CLOS ALL USE TableA IN 0 && Currently selected table USE TableB IN 0 REPL ALL TableB.Misc WITH 99 This is rediculous...

Is there an SQL equivalent for the following query? SELE DIST(EmpNo); FROM TimeHist; WHER EmpNo NOT IN (SELE EmpNo FROM EmpMstr) Would a Join statement be more efficient?