Answer Questions

• darthghandi seek char+date

  dear all, i seek stockist code+invoice date but failed to seek. why what i had done... use invoice shared index on code+dtoc(inv_date) to invoice.idx set index to invoice.idx seek code+dtoc(thisform.txtInvdate.value) but failed to seek. thanks. Either you are not getting a match which could be OK or it has to do with date formatting as Cetin suggested. In my case, I prefer to use DTOS(Date) as a better choice ...Show All

• mimi77 Info Combining on Page 2 in Page Frames

  How can I get my info on Page 1 to stay on Page 1 when I select Page 2   When I select Page 1 just the info I placed on Page 1 appears.  When I select Page 2 however, the info I placed on Page 1 also appears on Page 2 along with Page 2's info.  Thanks! Sounds like your "Page 1 info" (controls) were placed at the form level, not the Page1 level.  Sounds like you successfully added contro ...Show All

• Peter V Class Related Query

  hi all, I m new to programming. Can i add methods or property to a object (e.g. Combo box) which is placed in a container class. Thank you yes.  you can add methods and properties with code to any event in any control.  If there is already class code in the event make sure you type in DODEFAULT() as the first line of code, then put your own code after that. See help on addobject, addpr ...Show All

• Demian Schnaidman Call a store procedure in MS SQL

  Does any body have experiences to call a store procedure in MS. SQL Server with Foxpro V8 command How about :- lnHandle = SQLStringConnect("Driver={SQL Server};Server=(local);Database=master;Trusted_Connection=yes;") SQLExec(lnHandle, "sp_who", "temp") BROWSE SQLDisconnect(lnHandle) HTH, Robbo. Thanks guys for all of your replies. The answer is quite clear for calling a store proce ...Show All

• arcon5 Primary key + delete....

  General Design Question…. Suppose I have a table (Table1) with a primary key (PKId), if a user deletes a record then wants to add a record with the same PKId value there is a Primary key violation because the table has not yet Been packed. What is the best solution to this I have Considers the Following… 1) Indexing on PKId+!deleted() , but this would only solve the problem if he delete the record once, what happens if h ...Show All

• BubbaHasty Unexpected disconnecting of remote connections under VFP 9 SP1

  I have problem with unexpected disconnecting of remote connections under VFP 9 SP1 runtimes (only under SP1 runtimes). For example, using _VFP object to access forms will cause this and I am analysing other situations. Using _SCREEN object does not cause this. Does anyone found this too and in what situations   Using SP1 was however enforced by huge list of serious bugs in production version of VFP 9... Sorry. This is ...Show All

• Pi in the Sky Foxisapi permissions issue (I think)

  Windows Server 2003 IIS 6 VFP6.0 SP5 Latest copy of foxisapi.dll http://localhost/common/foxisapi.dll/STATUS displays correctly I have a testServer method that just returns a string and it doesn't work, and the COM server does not load. http://localhost/common/foxisapi.dll/myServer.class.testServer returns "The page cannot be displayed" Web site is running ok. Everyone, IUSR_ & IWAM_ are set for default launch & access per ...Show All

• Will5 older scatter gather, and VFP.

  Hi; I have a form which the user fills. The info the user enters need to be added as a record in a table. In the Foxpro2.6 world I used to do this by letting the user edit empty memory vars, and then append blank / gather from memvar. I am wondering if there is a better way to do this in VFP9 I know I can use buffering then tableupdate(), but that requires that I would append blank FIRST before I let the user edit the fields. ...Show All

• BlueScreen Hi

  Hi, I'm new to this forum. Looks great. Rutu. Welcome:) ...Show All

• Centuri0n FoxPro won't run. Fatal Error - C0000005

  Hi I've been working away in FoxPro for the past few days and then this morning, after using it for a couple of very productive hours, I suddenly got this error when I tried to start it up. Fatal error: Exception code=C0000005 @ 05/25/06 03:28:35 PM . It gets as far as showing the menu and the various things like the command window and then gives the MSoft error message. It shows as error 1000 in the Windows error log. I'm using VFP9, S ...Show All

• Maine All the sudden a batch of records (that were already in the table) are appended again?!?

  I have a multi user VFP 9.0 application that runs from a network share.  Every now and then one of the tables gets a bunch of duplcated records added to it.  A group of records that are already in the table just get added again!  I'm using optimistic buffering and I've set multilocks on.  If one of the users is having network connectivity problems, could it somehow be  re-adding records that are buffered by other users & ...Show All

• Aarthi_MSFT Memory acces error

  I need some help... When closing our application we are getting the error message "The instruction at "0x02245e30" referenced memory at "0x02245e30". The memory could not be "read"". We don't know what is wrong... any suggestions on how to fix this Any input would be really appreciated. As Don said, this is typical of an ActiveX control that has not been c ...Show All

• ngocbich Timer Control not kicking in

  Hi All, We have a small VFP 8.0 synchonization utility that picks data from a VFP 8.0 database , converts it into XML  and sends it over the net to an Oracle database . It has a timer control on it which makes sure that this utility sends the data from VFP 8.0 to Oracle every 45 mins. It has always worked on all the setups till now, except one. We have not been able to figure why it does not work on that one. Any hints or directions to thi ...Show All

• Aleks Spacca Help

  I have developed a FOX PRO 2.6 Version application which has developed the following error message when updating the cashbook receipting module.The message is " TOO MANY FILES OPEN".The application is on WINDOWS XP PROFESSIONAL it is running well on WIN 98 with the modification of config.sys " FILES = 100".I have done the same to XP but in config.nt and it still gives the error message what could be the problem . The total ...Show All

• Eric Landes How do I create a random table or cursor name?

  Hi all, I know that should be simple. How do i create a random table or cursor name and then use it I remember there is a function for this but i cannot find it! Could you please give me an example as well Thanks!!! Athan You should have no problem with SYS(2015). To be sure you could also append something to it to make it moreunique. Maybe cUserInitials + SYS(2015) or something like that. When you have a multi ...Show All