Answer Questions
JairoScz table buffering mode
On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All
Phil Mac minimize and maximize buttons on Report Designer
Can you remove maximize buttons on Report Designer in Visual Foxpro 6.0 Please help. Thanks in advance, Sanj. Hi Sanj, I believe what you want to do is use the WINDOW clause on the REPORT FORM command. Something like this would probably achieve your goal. DEFINE WINDOW reportpreview FROM 1,1 TO 50,100 IN SCREEN NOMINIMIZE TITLE "Test Window" SYSTEM Float REPORT FORM foo PREVIEW WINDOW reportpreview nowait RELEASE ...Show All
Ed Hill Philadelphia VFP User Group--Wednesday, April 5
Philadelphia VFP User Group Wednesday, April 5, 2006 7 PM (Optional: Meet for dinner at 6 PM in the food court) Topic: Introduction to .NET (from a VFP perspective) This discussion will include: an overview of the VS2005 environment, and general project structure; C# or VB ; Windows Forms; Creating classes/subclassing Winform controls; Data binding and data binding interfaces; Building a data access layer; Typed datasets; Distribut ...Show All
Shaun Wilson Cannot retrieve records from FOX DBF through OLEDB
Hi, I just want to retrieve some records from a DBF file to a recordset throgh VB6 and I get 0 records when I should get a set of them. This is the code: Set cnn1 = New ADODB.Connection strCnn = "Provider=VFPOLEDB.1;Data Source=C:\Lince\DBF\mer.dbf;Mode=ReadWrite|Share Deny None;Password='';Collating Sequence=MACHINE" cnn1.Open strCnn ' Open table Set rst1 = New ADODB.Recordset datFecha = "2004/12/30" datFecha1 = FormatDateTime(datFecha, vb ...Show All
delly_jm Dot Net Examples with VFP
I am seriously thinking about starting to use some of the dot net features within VFP. Where would be a good place to start with some maybe code examples of how to call dot net functions... or how this can be worked.. (beyond data access and web services) I am more interested in desktop applications at this point. But any pointers would be helpful.. Thanks so much . Bob Lee ...Show All
Oren Novotny Win32 API function
Hi, Can any one tell me what should be the shift and control key values in the below stated code. #DEFINE VK_lSHIFT 0x10 #DEFINE VK_lCONTROL 0x11 DECLARE INTEGER GetKeyState IN WIN32API INTEGER What should be the value of GetKeyState(VK_lSHIFT) and GetKeyState(VK_lCONTROL) I am getting different values(both +ve, -ve & 0) every time I press shift or control keys down. I want to use this in a controls click event to check for i ...Show All
Scheinka Records Disappear
I'm using a program called Auto Shop Controller from http://autoshopcontroller.com/ . This program uses Visual FoxPro. For some reason, some records mysteriously disappear. This has been going on for as long as I've been using the program, which is three years. I can't get any help from the program's vendor without paying an exorberant price for an minor update and then even more money for a support agreement. Even with that, they don't guarante ...Show All
rthiney [URGENT] help extracting FoxPro DBF Encrypted fields
Hi everyone. I'm working with a Foxpro DBF database, but I'm not using Visual Foxpro to read the data. I'm doing this from C#.Net. In fact .. I've never really used Foxpro before. My problem is as follows: In C# and Crystal Reports .. a lot of the string fields simply return blank strings (i.e. "") When I view the table in FoxPro, they are fixed-width character fields, and browsing the table shows that they contain a bunch of special A ...Show All
BeOne delete record
this question seems to be ... but I tried many times to do it but I couldn't . I'm using VFP 6.0 . I created a form and take data from mytable . After that I created Del button and wrote a small code in Click event . This is my code : if messagebox("Do you want to del this record ",36,"Notice")=6 delete thisform.refresh and the result is 0 record deleted . I don't know why . Is this related to "primary key" from mytable . If someboby ...Show All
Gooddaddy upgrading old foxpro apps
we currently have foxpro version 5, and a handfull of apps which were developed on it. the person who developed them has since left us and it has become my job to find a way to upgrade these apps. the problem is that i don't know the first thing about foxpro - i am a coldfusion guy. so the biggest thing we want to do is to get the data from the foxpro databases into a sql server database. if we do this can we still run t ...Show All
KyleT Cursor Adapter
Good afternoon gentlemen. First, it forgives me the weak inlges. I speak of Brazil. It would like to know, if it goes to exist updates in the one in the Adapter Cursor. A SP(n) for example. I felt lack of the possibility of being able to make relationships between the cursors to adapter. Thanks, Itamar Itamar, please repost your question in Portuguese. We have people from over 100 countries in th ...Show All
VenomWolf MSGraph.Chart.8 control
I need to make charts. I started with MSChart Control and so far I've accomplished almost all I wanted except for one thing which totally eludes me. I need a simple line chart, not columns or a pie. I need to display a row of data like DJIA or similar indices with no additional vertical bars or other embelishments. The curve comes out nice but a lot of space on the chart is wasted because the curve is being plotted too high on the chart in ve ...Show All
Masroor ul Hassan Urgent! How to change the value of a range in an Excel worksheet in VFP?
Dear Experts, I've formatted a range from Text to Date in an Excel worksheet using codes in VFP, however when I open the worksheet to view the format is changed but the values still showing as text. Also found that the values will only change when i double-click on each indiviual cell on the worksheet, how can i do it using codes in VFP Your help appreciated. Andrew You can check the type of the fi ...Show All
MayankMudgal GRID REFRESH
Im having problems refreshing a grid.i have placed a table in data enviroment.then i drag and dropped all of his items creating a grid.then in a button i have a select...where..into this table.this way i put new values in the table,basically i overwrite the entire table.at that time grid becomes white,no values i tried grid.refresh nothing i tried to grid.recordsource="" select where into... grin.recordsource=mytable still nothing is there ...Show All
Nitramsen Form clattered at design time. How to change pages?
With many controls added to a form I am beginning to sense a problem. During runtime many controls will be invisible on the first page but when subsequent pages are chosen they will appear. It is determined programmatically. I do not see an option to choose pages at design time. It would allow me to see some controls much better. In Visual dBASE Plus such convenience if taken for granted and much appreciated. How can I do it here Thanks. ...Show All