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...
Thanks everyone who replied. The last 3 responses are exactly what I need. I couldn't just use a cursor because I need the user to modify this data and wanted to keep the records in order and not read-only.
I've gotten burnt in the past by trying to auto-sort tables rather than simply using...
Hi Mike,
I didn't make it clear, but I'd like to sort by the first column, then second, then third. Summing them wouldn't necessarily sort them due to their variance.
.25, 100, 300
.50, 11, 80
If going by their sum, the .50 record would be sorted above .25 .. which isn't what I'd want...
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...
I suspect the computer's asleep in some way. Yeah, that would sound more plausible if it happened every day but that's my theory. I would recommend doing a few queries about 30 seconds before running the reports to help wake it up. Also, look into the MOUSE command to click on a safe part of the...
This is what I'm doing. The only problem is when the query contains more than one record that is field-for-field exactly the same, whatever changes made are made to both records. That is, you delete one both are deleted :( ..
SQLExec(gnHandle, cSQL, lcCursor)
IF !USED(lcCursor)...
(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...
I did a search and looked for a FAQ with no luck.
I would like to have a "Windows" menu item that shows all the currently-opened forms. Some of my forms can have multiple copies open. I use the following code to populate the list of open forms and to bring the selected form into...
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...
I have a very large =sqlconnectstring command to run, but haven't figured out how to do this. I put the whole command into a textfile and tried doing =execscript(fileto('a.txt')) with no luck.
I've also tried populating it with variables like:
=execscript(lcText1+lcText2) -but it still...
I have spent 3 hours trying to figure this out. I can get my SQL command to run while in VFP 6 and VFP8, but when I run it as a compiled .EXE, it fails to populate the cursor.
I have a long SQL statement (longer than 255 characters) that must be broken up. I have it set to VFP7 compatibility...
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...
Perhaps if someone could give a conceptual overview of how (using SQL passthru) to make textboxes first load a single record and a secondary button that would save any changes, that would be helpful.
Thanks in advance
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...
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.