Answer Questions

• gvraovc Guidance Required...

  Hi all,         I've developed a VFP application in vers. 6.0. Now that the client wants the same with MS SQL / Oracle. Please someone tell me the list of atricles and other notes i've to go through..... I'm ok with SQL querries.... Please suggest me regarding the -Remote views, SPT's...... The application as a whole has about 2 GB of data in VFP..... It's a multi-user application....running on VFP 6.0 ./ WIn2000 Platform.  Thanks in advance... -Markish Andy Kramek has developed some excellent data access classes. You can get them at http://www.tightlinecomputers.com/Downloads.htm Thanks a lot... I'll take it forward... and let you know when I'm struck Markish, ...Show All

• ti_m "Flush Force"

  The question is: When is it wiser to "flush force" (data to disk) vs. =Tableupdate(.T.), =Tableupdate(1), etc. What is the usual paradigm Can I forget flush Is flush slow in the LAN setting(s) Does flush hog resources Does frequent-flush help prevent corrupting tables during intense LAN data-manipulation, crashes, and/or power outs Is is dangerous to rely too much on Tableupdate() alone when tables stay open all day As always, thanks in advance for any thoughts Budoi and Andy, While issuing FDATE() to display "Last Modified", I *discovered* open tables don't write to disk after commanding "tableupdate(.T.)" An updated open data-file remains unsaved and not "Modified" (acc ...Show All

• Oleg Kalenbet visual foxpro query

  Hai, i have a table with the following records. month,dealercode,branch,netqty can anybody kindly give me SQL Command which will sum netqty group by dlrcod and month but for each dealer monthqty should appear vertically. select dlrcod,branch,sum(netqty) from <table name> group by dlrcod,month with this query i get month totals horizontally but i want months to appear vertically. if any body can kindly give me a query, i would be greatful eg. mnth delaer code branch netqty january a0001 blr 1000 april a0001 blr 500 feb a0001 blr 300 may b0001 blr 400 june b0001 blr 300 january a0001 b ...Show All

• Donald E. King query and fecth in parallel

  I'm working with Visual FoxPro 6.0 trying to work on two statements in parallel. The connection string is : "DSN=Visual FoxPro DataBase; SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes; Deleted=Yes;" In the code below I'm processing one query, after it is done I'm opening a new Thread that process some other query on the same table, my problem is that despite the fact I'm working in two Threads it doesn’t work in parallel the function SQLFetch() ends only after the " SelectThread" if over. The output of this program is: [6556] Select Enter [6556] Select Leave [6556] SelectThread Enter [6556] Before SQLFetch [6556] SelectThread Leave [6556] After SQLFetch I'm want to fix this problem so that t ...Show All

• IGiberson Create menu or command

  Hi there, How to create a command button or menu to acess 3 different form. Pls advice. Thanks. I assume "exord001" is the name of your form. In VFP, when you create (and save) a form it actually saves two files on disk: exord001.scx exord001.sct What the error is saying is that it cannot find the form (when running an APP from the IDE) or when the compiler tries to compile the form into and EXE . To create a form in the IDE (Integrated Development Environment) you can either do it through thte menus with FILE|NEW|FORM or from the command box typing CREATE FORM exord001 (or MODIFY FORM exord001). Is that what you did to create it Create a ...Show All

• DongL Vp9 can use OLEDB at ORACLE ?

  Dear all ; is that posible vp9 can access trough the oracle db thanks guys rgds OleDb is a driver and is used to connect different data sources. In other words, yes. ...Show All

• Wellnow System time - synchronizing, displaying

  Hi experts. Does anybody know how to get the real time from internet. I want to have the real updated time in my application. Second task is to changing the system time. How can I do that Third task is how to display time in form for example in textbox. I know the way with timer but if there is any other way I will be glad to know it. But the consequence is in the order I have written. Mainly the getting real time from internet. Thanks Sorry still don't know how to do that... I have tried the both sites with no success... I don't know nothing about XML. According to wikipedia, Pacific Time observes daylight saving in the same way as Central European Time ...Show All

• GGardiner Excel to cursor SPT problems

  I am using a SPT solution to take information from a .xls file and importing it to a cursor with this solution: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=509710&SiteID=1 However, I am now receiving problems where before I had not. Now I am getting Error 1466: Connection handle is invalid. Any ideas guys I can't see what the problem is but it occurs at the sqlstringconnect( ) line. Thanks! Here is one sample that I posted to UT earlier today: use customer Export to xxCustomer. xls type xl5 use lcXLS = Sys ( 5 )+ Curdir ()+ 'xxCustomer.xls' lcConn = "Driver={Microsoft Excel Driver (*.xls)};" +; "DriverId=790;Dbq=" +m.lcXLS+; ";DefaultDir=" + JustPath (m.lcXLS)+ ";&qu ...Show All

• .net sukbir program starting problem, grid problem

  Hi I have several beginner questions for VFP 8.0 1) Where should I put the READ EVENTS method so the main form will show itself instead of showing the fox pro main window 2) When executing SQL simple select statement for filling a grid, it fills the grid inside the form, but firstly it shows the result in a grid outside the main form. How to show result only in the grid placed on the form Denis, First where you go wrong: You're doing a "replace" after a select and go top. Replace have a default scope of "next 1". So you're only telling it to replace a single record. It should look like: select myCursor scan if seek(keyfield, 'tasks', 'keyfieldtag') replace ...Show All

• SimonGUK Web page scrapping form Visual FoxPro

  I am not sure if this is even possible so i will just say what i am hoping to accomplish and let you all tell me how crazy it is. i want to have a foxpro application on my computer that opens a set of webpages i want to knoe if it is possable to look for a set of numbers on the page once it is opened. the numbers will probly never be the same. is this possible in FoxPro 8.0 VFP can manipulate text rather well, once it's in its environment. Maybe this is a good start to getting your web page in the VFP environment: How to use Visual FoxPro to download a Web page from the Internet http://support.microsoft.com/default.aspx scid=kb;en-us;311306 Thanks Carl that do ...Show All

• Jitusj File is in use by another.

  When getting an error "File is in use by another" - Is there a way to trap what file is this I am using the sys(2018) but I don't get any info in there. Thx. Obviously when I try to use a file. But I am not sure what file is the one causing the problem cause Sys(2018) won't supply that in the error trapping routine. thx. here is my code for pos program when do close sales day. latables is an array i declare at main.prg... && check any files locked FOR i = 1 TO ALEN(laTables,1)  mFileUsed = .F.  ON ERROR mFileUsed = .T.  USE &mDatapath\&laTables(i,1) EXCLUSIVE  ON ERROR    IF mFileUsed  & ...Show All

• Will George Grid class

  I have made my own grid base class with 9 columns. When I create a grid based on this class, and I try to reduce the number of columns, I get an error message saying "Member COLUMN# is a class member" (# being the umber just above the one to which I want to change; if I want to go from 9 to 7, # = 8). What am I missing, believing this would work Hans L PS. I wanted to make every column heading centered vertically/horizontally and bold. With column # = -1, this cannot be done, as far as I understand (no columns in Propoerties). >> Now, if you want to direct me to more of a beginners forum, I will receive that very positively, and get back here only when I have more experience.  I kno ...Show All

• Emy_P MS SQL Server or VFP Database???

  Hi every one, hi MVFPs, I am working with SQL Server database, but I wonder that I've got some big problem with SQL table that has more than 500,000 records. If there are about 50 connections access to that table with select, update,,, task, the SQL will become very slowly and return error message as: ....query out of time,,, or dead lock.... If I work with VFP database, there are about more 100 connections with command "use" the table, and so often tasks to seek, select, update.... but It still work well even if not too fast. And I have a VFP table with more than 1,5 billion records working hard like that. So now I don't know if I will working with VFP database or getting SQL instead because of the more security of usin ...Show All

• Ccm1st Listbox causing error

  Hi I have a listbox in which I fill with values from a SQL based on a selection chosen by the user. The listbox allows the user to select the value they want from the list and enter payments for that person. However my problem occurs in instances where the list box contains more records that are shown in the main listbox window and the user has to scroll down the list. This is usually 500 or more records. When the user selects any of the records nearing the end of the list, the entire application closes with an error saying "Syntax error" and it is going straight to the read events. It however does not tell me where the syntax error is. For any of the records closer to the beginning, everything works fine. Help please. ...Show All

• Kevin O Donovan How to add my own objects to a grid programatically

  Hi all; I'm using this method to construct the columns within the grid. I need however to construct the grid so the cells are my own class objects. WITH thisform.kgrdledger1 .columnCount = -1 .RecordSource = "CurRpt" .addcolumn(1) .columns(thisform.kgrdledger1.ColumnCount).name = "colAmount" .colAmount.controlsource = "curRpt.Amount" .colAmount.header1.caption = "$ Amount" *****===>>> Here I would like to add object class 'mytxt1' instead of text1 endwith Thank you all. Here I would like to add object class 'mytxt1' instead of text1 In addition to the information that Andy gave you, do not for ...Show All