Data access in VFP 8.0 views

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Exchange Fox
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - kalle kalle? Tag: Data access in VFP 8.0 views Tag: 201721
  - 2
    - foxpro 2.6 Fields - disabled fields makes software to abort Hi I have a problem in foxpro 2.6. I have 2 Fields in a screen. The first field is alphanumeric and the second is a date field. In field1-Valid() I check that field1 is empty and if so field2 will be disabled. When the program runs and field1 is empty it works to use the tabulator to leave field1. What happens is that field 2 is disabled and the control is forwarded to the next object in the screen. My problem is if I use the mousepointer to click in field2. Then, field2 is disabled but the program aborts without any messages. I have tried different solutions for example to add code in the When() clause for field2 that determines that field1 is empty and gives control to another object in the screen. But it won't work. If anyone knows how to get around please send a response. Best regards /G Tag: Data access in VFP 8.0 views Tag: 201720
  - 3
    - VFP appliaction very slow Dear I have a problems. When I put the Visual Foxpro database file to LAN Server share to lan Workstation access. I load the record very slow. Can you advice which solution can define this problems. Thanks Jackie Wong Tag: Data access in VFP 8.0 views Tag: 201718
  - 4
    - Status Bar display My status bar has suddenly decided not to shew the active record number and the total of records. The Status Bar is Set on, if I Set Status on I just get the narrow blue band shewing <c> and 'num. I'm missing something here, what have I done wrong and how do I return to the display of record no/total records? Tag: Data access in VFP 8.0 views Tag: 201713
  - 5
    - Task Pane Could the Task pane be included as part of an exe as the main starting or is it only available in the development environment. Thanks Shahriar Tag: Data access in VFP 8.0 views Tag: 201698
  - 6
    - Collating sequence in VFP8 I want to use the HUNGARY collating sequence. When I issued SET COLLATE TO "HUNGARY" no any error messages. If I want to create a new idx file I receive the error "Collating sequence "HUNGARY" is not found." What mistake did I make? -- Sandor Tag: Data access in VFP 8.0 views Tag: 201697
  - 7
    - MSComm error handling Dear All, I wrote an application which use MSComm to send message to serial comm port. And the application is running round the clock (24 * 7). The following is the logic flow of the application: 1. Set timer interval = 1000 2. Read data 3. Send data to comm port 4. Write log message to txt file When testing the application over night, it generated the following error message: Microsoft Visual FoxPro --------------------------- Error number: 1429 Error message: OLE IDispatch exception code 0 from MSComm: Internal error retrieving device control block for the port.. Line of code with error: VtForm.Comm1.Output = lp_Outputstr Line number of error: 3 Program with error: VT.COM_PORT_OUTPUT Questions: 1. Why come out this error? I start running the application at 6:00 p.m. and the error occured at 10:22 p.m. 2. Can I resume the process when receiving this error (with error handler procedure)? Since I require to run the application 24 * 7. Thanks for your attention. Tommy Law Tag: Data access in VFP 8.0 views Tag: 201693
  - 8
    - VFP8 : GOTO negative recnos in buffered mode Hello all, I am coming accross a big pain in my app that has moved from VFP6 to VFP8. Basically, I have a common function that is refreshing a grid and going to a newly added record. The problem case comes in when the view is buffered, which means calling RECNO() will return a negative number (-1 for one record added, -2 for two records added, etc...). Issuing the command GOTO( RECNO() ) gives an error in VFP8 of "Record out of Range", but if VFP6 everything works out merrily. Any ideas? Please let me know if I should post more information. Thanks! Tag: Data access in VFP 8.0 views Tag: 201690
  - 9
    - Hierarical control in VFP Does anyone know of a good hierarical control that can be used in VFP 8? I am using the flexgrid from component one in my VB programs and was interested in a control similar in VFP. Many thanks Shahriar Tag: Data access in VFP 8.0 views Tag: 201689
  - 10
    - wait window Hi All how do I let a user control when to close a wait window while doing other things ? I have an application where it would be convienent to put up a wait window and leave it there while the user continues to do other thinks that may be related to info in wait window I know I can do this other ways, but I thought someone might know a simple answer. eg. can you tell if the user clicked on area of wait window ? al Tag: Data access in VFP 8.0 views Tag: 201681
  - 11
    - Execscript... I want to run a specific function in a program file, using execscript. Is that possible? Zeke Tag: Data access in VFP 8.0 views Tag: 201677
  - 12
    - Delphi? Hi, Can anybody share there experience with Delphi from a VFP developer view? How complicated could it be to start learning Delphi when all you have done is VFP programming? Thanks! -- Edhy Tag: Data access in VFP 8.0 views Tag: 201676
  - 13
    - FoxPro upgrade I have a system written in version 5 and I need to upgrade to version 8. Unfortunately I don't know much about FoxPro. Can someone tell me where I can get some more info on what to do. The manual says you can run the old system without any changes. Won't I have to create a new .exe file to run under version 8. If so how do I do that? Thanks, Jim. Tag: Data access in VFP 8.0 views Tag: 201670
  - 14
    - What's the use of using resource file in my_apps if all it does is saving C5 error? Hi all, One of my client just called earlier this morning saying that he had a C5 error since yesterday and he couldn't run some parts of my_apps. Anyway, I searched this ng and found a suggestion to delete foxuser.* (from Craig Berntson if I'm not mistaken). I convey this solution to my client just now, and it fixes the problem. This whole story makes me think; Why not put SET RESOURCE OFF in my main.prg and only use resource file for certain-specific-read-only purpose only (I have res_noprint.dbf and res_rdesigner.dbf that I use to prevent printing from preview window and to show designer toolbar while opening report designer at runtime)? What do you think guys? Anybody here have a real use of default resource files (foxuser.*) ? Or maybe, Am I the only one here who don't have SET RESOURCE OFF in the main program and I should've known this behavior from the day-one I use VFP? I'm looking forward to hearing from all of you! TIA, Willianto Tag: Data access in VFP 8.0 views Tag: 201664
  - 15
    - Procedures I keep several functions in a non visual class which I call up when I need them on a form by using, for example, thisform.txtarrears.value=oPropApp.rentarrears(). This works well, and avoids having a separate procedure file. My problem is that I want to use this in a report and SQL does not seem to recognise functions called from a class. Is there any way around this ? I use VFP6. An example of such a function is below. ** Totals rents due for a tenant mdbf=ALIAS() mref=tenants.tenantref SELECT tenacc SUM(rentrec) TO mtot1 FOR tenacc.tenant=mref SUM(rentdue) TO mtot2 FOR tenacc.tenant=mref SUM(vatrec) TO mtot3 FOR tenacc.tenant=mref SUM(vatdue) TO mtot4 FOR tenacc.tenant=mref SUM(servicerec) TO mtot5 FOR tenacc.tenant=mref SUM(servicedue) TO mtot6 FOR tenacc.tenant=mref SUM (writeoff) TO mtot7 for tenacc.tenant=mref SUM (vatwriteoff) TO mtot8 for tenacc.tenant=mref mtot=mtot2+mtot4+mtot6-mtot1-mtot3-mtot5+mtot7+mtot8 SELECT (mdbf) LOCATE FOR tenants.tenantref=mref RETURN mtot * EOF rentarrears ******************************************************** -- Tim Hobson Tag: Data access in VFP 8.0 views Tag: 201660
  - 16
    - Printing RTF from memo We have table with memo field. In this memo field we have rich text format file. How can we print this field on report. We can extract field into file on disk and then use append general like in following code: = StrToFile(Table.mField,'\temp\rtf\aaa.rtf',0) Select rtf_file If Reccount() <= 0 Append Blank EndIf Append General gField from '\temp\rtf\aaa.rtf'class "richtext.richtextctrl.1" Is there any better and faster way to do this? Thanks, Tag: Data access in VFP 8.0 views Tag: 201656
  - 17
    - set path We have developed an application using a data set in \\machine1\data. The forms in this application have the tables in their data environments. The app works fine until we want to use a different set of data. Setting path to \\machine2\data works fine as long as \\machine1\data is not accessible. If \\machine1\data is available it will always use that data regardless of the set pathh setting. Is there a way to stop this behaviour. Thanks in advance Dave Tag: Data access in VFP 8.0 views Tag: 201653
  - 18
    - Files in Folder How would i use fox to loop and get a list of all files within a directory? Tag: Data access in VFP 8.0 views Tag: 201648
  - 19
    - BROWSE menu Table in Win95 Hello, BROWSE is automatically generating a menu "Table" with many useful functions. Unfortunately this does not work with FoxPro8 under Windows95. In this case you see just 1 submenu and some separator lines. What could be the reason for this behaviour? Thanks for suggestions. Tag: Data access in VFP 8.0 views Tag: 201640
  - 20
    - procedure in separate files = slow execution? I had an application with a large procedure file. The application uses SET PROCEDURE TO <this file> I'm writing another application which uses a few of the procedures in the file. I don't want to include the large procedure file in my new application so I took the common procedures out of the large file and created a separate .PRG for each one. These procedures are used in small loops and when I build the original application, the code runs at least twice as slowly now these procedures are in separate files. Is this a known effect? (having written that post and thought a bit,) I'm thinking I should #INCLUDE the files in the procedure file. But I find it odd that performance has been affected; the whole thing is built into a single exe, why should code location in the source have such a negative impact? -- TIA Andrew Howell Tag: Data access in VFP 8.0 views Tag: 201630
  - 21
    - Alter table Dear sirs I`m making a program so the user can choose a table and to update its fields in a form I`ve created, when the user chooses a table a number of textBoxes is created the same number of the table fields, I`ve a command Button in that form with caption Update, so the user can change the fields names and click on update to update the table I use the following code to get the table fields names, it works very good, IF !USED(upd_table) USE (upd_table) ENDIF gnFieldcount = AFIELDS(laFields) FOR i = 1 TO gnFieldcount THISFORM.oTextName[i] = CREATEOBJECT('textBox') THISFORM.ADDOBJECT('thisform.oTextName[i]','textBox') THISFORM.oTextName[i].NAME = 'txtN'+ALLTRIM(STR(i)) THISFORM.oTextName[i].VALUE = laFields[i,1] NEXT i The code in the Update command Button FOR i = 1 TO gnFieldcount txtCtrl = "ThisForm.txtN" + LTRIM(STR(i)) f_name = ALLTRIM(&txtCtrl..VALUE) IF ALLTRIM(laFields[i,1]) # ALLTRIM(f_name) ALTER TABLE &z_table RENAME COLUMN &laFields[i,1] TO &f_name ENDIF NEXT i the problem is when I try to delete characters to the field name ex:field name is fieldxy and I made it fieldx and press update, it gives me an error says the variable fieldx is not found I don`t know why???? thanks Mohammed Tag: Data access in VFP 8.0 views Tag: 201628
  - 22
    - how do key in chinese word in foxrpo application Dear All, I using WinXP Prof & Visual Foxpro 6.0 to create my application, my application need to key in chinese name. I try to use thiry party chinese software like cstar2003, but some word can not show on screen, why ? please help TQ Tag: Data access in VFP 8.0 views Tag: 201619
  - 23
    - Top level form I have a .prg file that opens few files and calls a top level form. This all works well in the foxpro development environment. When I create an .exe file and try to execute the program. I get a quick flicker and the form doesnt get displayed. I tried setting the screen=off in config.fpw also. What else should be set? Thanks in advance Shahriar Tag: Data access in VFP 8.0 views Tag: 201617
  - 24
    - How to create task/Schedule in Microsoft Outlook I am using VFP 6.0. I want to create a task / Schedule in the Microsoft Outlook ( The Outlook is connected to the Exchange Server ) How to make it ? Tag: Data access in VFP 8.0 views Tag: 201616
  - 25
    - OLE error with control (BarCodeWiz) I'm using an ActiveX control to print barcodes. When I preview the report, it runs fine. But when I try to print to a printer, it generates: "OLE error code 0x80020009: Exception occurred." I've asked the vendor about this but have not gotten an answer as of yet. This happens in VFP6 and 8. And with an HP LJ printer and a Dymo label printer. I'm also using a similar control from IDEAutomation that doesn't generate the error. The programs that use these two controls are virtually identical. The error doesn't seem to be in my program b/c simply clicking on the Print icon in the report preview produces the error. None of my code is involved in this. Any idea what would cause this error? Thanks, Frank Tag: Data access in VFP 8.0 views Tag: 201614
- Next
  - 1
    - GetObject(,"AcrobarReader.Application") Does anyone know the correct syntax for prorammatically opening the Acrobat Reader? If it cannot be done with GetObject, is there a work-a-round? Tag: Data access in VFP 8.0 views Tag: 201611
  - 2
    - how to join tables from 2 diferent databases Hi... I have an Oracle table with more than 700,000 records and a VFP table with 4,200 records I need to select all records from Oracle table that has a corresponding record in the VFP table is it possible to do it from VFP8 without transferring all oracle table records to a temporary cursor? how? thanks in advance Oscar Taboada Tag: Data access in VFP 8.0 views Tag: 201605
  - 3
    - button.default won't stick I have a form in which, depending on certain conditions, the "default" property should apply to different buttons. But when I set a button's defaut property to .T. at run time (which according to the doc, sets all others to .F.), the change doesn't take. Even if I pause execution and manually set the property to .T., the "default" button switches back to the original as focus passes from one control to another. None of the buttons get disabled, but their picture and/or captions change. If I set other buttons' default property to .F. before setting another's to .T., that does not help the situation. Is it me? Is there a workaround? Tag: Data access in VFP 8.0 views Tag: 201603
  - 4
    - max records in freetable included in project ? Hi, Could it be that a freetable that is included in a project is limited on the reccount ? My exe has difficulties on start up, when +-8000 records are reached. The exe just quit without any warning and the problem goes away when I zap the file and rebuild it. For the purpose of this problem it's not relevant but maybe for future release, it's good to know. regards christophe Tag: Data access in VFP 8.0 views Tag: 201597
  - 5
    - Com server location I have found _vfp.servername to identify the location of a VFP com server. Is this the way to do it - or is there a better way? Curdir() or sys(16,1) don't work... Zeke Tag: Data access in VFP 8.0 views Tag: 201590
  - 6
    - Windows filenames Is there a generic way to handle windows file and foldernames which includes spaces in VFP? In some cases (like use <table>) you have to pad with quotes, and in other cases it is not needed. Tag: Data access in VFP 8.0 views Tag: 201588
  - 7
    - MonthView and GetDayBold I'm getting OLE error code 0x80020005 from GetDayBold in the MonthView control. Any tips on how to avoid this? Rolf Tag: Data access in VFP 8.0 views Tag: 201587
  - 8
    - Can COM objects be called from both foxisapi and ASP? I have an application that is calling my com object from ASP pages as well as via foxisapi. After accessing the com object from foxisapi any attempt to access the com object from ASP results in "HTTP 500 - Internal server error". This continues even if I /RESET foxisapi. The only way to fix it is to iisReset. FoxIsapi does not have a problem with it though and I can continue accessing the object through it. I can also access the com object through createobject(..) within fox. I may have to convert everything over to FoxIsapi but this was planned to be a gradual upgrade as it is a very big site. Any ideas would be appreciated. Tag: Data access in VFP 8.0 views Tag: 201580
  - 9
    - how to put pics in database hi sir, how can i use the pictures from general fields in tables and can use in forms picture? or there are any way else. i.e. i insert pictures in table in general field and i want to use this pics from table in forms picture Tag: Data access in VFP 8.0 views Tag: 201577
  - 10
    - Binding _ASSIGN methods I am unable to bind the properties of two objects. Say, objects X1 and X2, both have property "D", how can I bind them in a manner that when I change the property for X1, it also changes for X2? Thanks in advance Abhay Tag: Data access in VFP 8.0 views Tag: 201576
  - 11
    - certification for VFP (6,7, or 8) i'm looking for a way to get certified in Visual Fox Pro (6,7 or 8). How can i go about doing this??? Would appreciate some info, links, or the like. Tag: Data access in VFP 8.0 views Tag: 201575
  - 12
    - Progress bar with a SQL Select statement I often use a progress bar within a scan/endscan to give the user visual feedback and reassure them that the system hasn't hung. I pass it two parameters: current record number, and max number of records and it does the business, returning .T.. Is there a way of using such a progress bar or similar with a SELECT statement. It is an outer join sql using all the records from the one table so I know the max number of records. However I have no idea how to pass it the first parameter. I was thinking along the lines of: SELECT ... INTO CURSOR <filename> WHERE PROGRESS(param1,param2) The particular sql could take 20-30 secs and a simple WAIT WINDOW NOWAIT seems inadequate. If this function is not possible is there any other way of displaying a progress bar while a SELECT is running? Many thanks Stephen Tag: Data access in VFP 8.0 views Tag: 201567
  - 13
    - How to Add a New Paper Size? Anyone know how to add a new paper size to the list of available paper sizes for a printer? I know Adobe Acrobat lets you do this. Is there an API to get a list of available paper sizes or an API to add a new paper size? Thanks Charlie Parker cparker@fowlersoftware.com Tag: Data access in VFP 8.0 views Tag: 201558
  - 14
    - App does not detect newly added record Hi, Just fishing for ideas here. I have two apps which 'talk to' each other. Idea is that app1 is the UI, and allows users to submit a job request to a table. App2 is server based and looks at the table via a timer - if it finds a new job request, it processes it, then looks out for the next one. Problem I have is that app2 won't pick up a new job request if the job queue table has a job added after it's been empty. If you restart it, it picks up no problem, if it adds its own occasional job it works fine, and if there's say 4 jobs in the queue after a restart it will process them all. This is a VFP8 app running on Win 2003 Server. I'm guessing this is some multi-user issue. I'm not using the DE - table is opened each time within the timer code, it's definitely the right table, and a COUNT gives zero records. Any help much appreciated. Cheers, Neil Tag: Data access in VFP 8.0 views Tag: 201554
  - 15
    - QuickBooks Converting foxpro database/table to a "csv/text" format it's not a problem. Anyone has an idiot proof ideea of importing this text data into QuickBooks? (except manually importing from QuickBooks) Thanks Tag: Data access in VFP 8.0 views Tag: 201552
  - 16
    - New VFP System I was handed a vfp system and am not familiar with vfp. I have attended some general classes on it. However, the system I have was not redesigned for vfp or done in a relational database. It is just tables. with information copied over and duplicated in several areas. I know the system needs to be fixed, I have been told with what I want it would basically require it to be re written. Do you think it would be best to be written in VFP, Access or some other database format. In the future we will be looking at web based things as well. I am familiar with Access, and can find help on that easily. It is very hard to get any help for Foxpro. Thanks Tag: Data access in VFP 8.0 views Tag: 201545
  - 17
    - updated help file VFP9 Beta ... was recently added to the VFP downloads page... This download contains a refresh of the help file delivered with Visual FoxPro 9.0 beta and includes updated documentation for the enhanced report system features and more. Note: The contents in this new updated Help file for the Visual FoxPro 9.0 public beta reflect a newer build of the beta and not necessarily what is in the public beta, and does not contain what will be complete in the final version of Visual FoxPro 9.0. http://www.microsoft.com/downloads/details.aspx?familyid=40b7de2a-754b-4f89-bf30-8a1d20f08e8b&displaylang=en -- Eric den Doop www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8 Tag: Data access in VFP 8.0 views Tag: 201538
  - 18
    - VFP via OutlookXP send message Dear. When I use internal dev system send out message via outlook XP, the screen are prompted that "An application is trying to access the address book. Do you want to do this". A progress bar follows and after it times out the "ok" button is enabled. A combo box prompts users to "allow access for" 1-10 minutes. I am in a large corp and have many users. This causes much confusion. Is their any way to disable the prompting. Please advice. Thanks Jackie Wong Tag: Data access in VFP 8.0 views Tag: 201528
  - 19
    - Using VFP to process long lins of data & to create mailing labels I need to process some very long lines of data, 1200 characters or more, that contains company, address, city, state, and zip code data. My goal is to extract these items and create mailing labels. With shorter lines of data, 250 or less, I knew how to process this. Using FP2.6 terminology, I would create a file with one field the length of data, append the data as text, process this file record by record, and generate fields for a second file. I have done the same in VFP. I know how to process the data on a line once I can get Foxpro to read the line, for example processing character by character. My problem right now is I don't know how to get the long lines of data to the point I can use VFP to read the data character by character. Can anyone offer suggestions as to how to do this? Thanks, Tag: Data access in VFP 8.0 views Tag: 201517
  - 20
    - Corruption in remote-views-only DBC. Possible? Hi all, I used to include remote-views-only dbc in my exe, but now, I decided to exclude it. Question: Is the corruption possibility is the same as dbc with data? TIA, Willianto Tag: Data access in VFP 8.0 views Tag: 201511
  - 21
    - software test program what is the best software test program for visual foxpro 6.0 ? George Malekkos Managing Director __________________________________ www.powersoft.com.cy ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= East/West-Coast Server Farms - Total Privacy via Encryption =--- Tag: Data access in VFP 8.0 views Tag: 201508
  - 22
    - printer esc codes Hi, I am converting the following code from dbman to foxpro I thought i was doing this right by using chr(27) for ESC but all it does is prints a box and the codes and the printer does not use them :( The dbman program used a command ESC() for this but is is not in foxpro. old dbman code: SET PRINT ON ****RESET ?? ESC("<27>E") ****MARGIN ?? ESC("<27>&a2L") ***LINE SPACING ?? ESC("<27>&l8D") **SYMBOL SET ASCII ?? ESC("<27>(0U") **SPACING FIXED ?? ESC("<27>(s0P") **PITCH ?? ESC("<27>(s16.65H") **Height ?? ESC("<27>(s14.25V") **STYLE ?? ESC("<27>(s0S") **Strke Weight ?? ESC("<27>(s0B") new try at foxpro code: SET PRINT ON ****RESET ?? CHR(27)+"E" ****MARGIN ?? CHR(27)+"&a2L" ***LINE SPACING ?? CHR(27)+ "&l8D" **SYMBOL SET ASCII ?? CHR(27)+ "(0U" **SPACING FIXED ?? CHR(27)+ "(s0P" **PITCH ?? CHR(27)+ "(s16.65H" **Height ?? CHR(27)+ "(s14.25V" **STYLE ?? CHR(27)+ "(s0S" **Strke Weight ?? CHR(27)+ "(s0B" Tag: Data access in VFP 8.0 views Tag: 201504
  - 23
    - Drag and Drop I have a container on the form and need to be able to drag it around to show whats' underneath. I can't seem to get it to drop. Dragmode is set to 'automatic' but I can't seem to figure out how to get the position to change. What method fires? Thanks Tag: Data access in VFP 8.0 views Tag: 201501
  - 24
    - Eventhandler( ) - bind COM events to VFP object Trying to use SQL Server sqldmo.dll object for some SQL Server management functions. However, cannot figure how to bind the sqldmo.dll events (specifically the BackupSink interface). I've created the VFP class that implements this interface, but when using eventhandler() to bind the COM object to the VFP object, it always fails. Any ideas? Tag: Data access in VFP 8.0 views Tag: 201488
  - 25
    - Creating ADO connection views in Foxpro I am trying to create a foxpro remote view to another database called K (www.kx.com). I have the ODBC driver, works fine in Excel, ADO ect. But in fox, I create view, connection works, it shows the tables, yet when I type SQL i get "no results returned by server". SO either:A how do I correct this or B: How/where do I create a raw ADO connection as a remote view? Tag: Data access in VFP 8.0 views Tag: 201486

I was thinking of changing over to OLEDB data access instead of current ODBC
connection. My application uses lot of VFP views to do select, update, insert
etc. I am worried that when changing over to OLEDB, I cannot use Views any
more. It will require more programming to change over from view to SQL pass
through query using OLEDB. Has any body done this kind of work? Any help
will be appreciated.

Thanks
Ajay

Top