Answer Questions

• Ron L how can i get a array from function/procedure as return parameter?

  i wrote one function ,i put the values in a array for return,but  i can't get it . for instance. function a() return arrayname endfu b= a() thank you craig   jet su wrote: i wrote one function ,i put the values in a array for return,but  i can't get it . for instance. function a() return arrayname endfu b= a() Hi One way to do this is to pass the array to the function by refer ...Show All

• Erlink pulling data from one field and making a new column out of it

  Hi all!!! I have two fields, work_id and sp_id. All sp_id's are related to the work_id's ie. work_id sp_id 1 000 3 000 3 111 5 111 9 000 9 111 i need the data to be listed by the work_id, then in another colum have it state whether it is one sp_id, the other sp_id or both sp_id work_id sp_id 1 000 3 both 5 111 9 both any insight life is short ...Show All

• coderjedi VFP 6.0 Coding help

  I have made a module used for deleting a member from a database. It is shown below (btw,am using this type of coding instead of forms,etc... because the module is meant for newbies in programming).When it is run, I get the first screen asking for the ID but the problem is that it does not show the record and the module is cancelled by itself. Can anyone help btw, the ID I am inputting exists in the database. ** Module: Delmem.prg ** ** ...Show All

• Jacaranda Foxpro problem I think

  Hi, I have made an program in foxpro wich will archieve mail. what I do is I first export the mail body, sender, etc to text files with vba and than get them back with foxpro, but sometimes the layout changes when I put it back. Has this something to do with that I exprot them to text files or is it something different please help Remember that most email objects used to get email have two Body ...Show All

• cmyster End datasession users?

  I sharing data in LAN network, what to end datasession users Thank you! Mean, I want closedatabase and close program when an other PC asscessing (disconect users) To Dave M, thank you, but I want close shared files in VFP. What do you mean Releasing all forms using a private datasession, all session objects and close databases all would ...Show All

• bryanandrews Can i do any control when i click the close button in the control bar of the form ?

  thank every one   jet su wrote: i means i want to pop one messagebox to make sure whether colse the form,but i don't want to use the command button to do this. so if i use unload or queryunload event,the form will be closed even u clicked the cancel button. You could use something like this in the queryunload event: it's a good idea to check the form's release type to make sure the form isn't being unloaded because Foxpro ...Show All

• rileyjim ensuring data integrity using cursoradapters

  What is the best way 2 ensure that no partial updates occur when using cursoradapters on VFP8 Currently am issuing different TABLEUPDATES for all the cursors open. I am using an Access databases. Is there something like BEGIN TRANSACTION...END TRANSACTION when using CursorAdapaters Please give me the best approach to ensure data integrity and consistency. Thanks. You'll have to use the transaction abilities in ...Show All

• cdoloriert Using a Lan Connection on Visual FoxPro 9

  hi guys...im just new here on this forum...i am about to work on my thesis and i chose visual foxpro 9 as my software development tool..im planning to create an enrollment system for a certain school..im just wondering that if im going to create this type of system, i need to make LAN connections because enrollement system includes sectioning,assessment and payment. actually, i dont have any idea of how LAN works on visual foxpro and the things ...Show All

• Mohammed Ghouse Barq use the reccount

  hello all  I use "set filter to" and want to know how much record is match the filter condition. I use the "reccount()"  but it return the result is not I want. it is all the record count Well, I expect it to display some information, for instance that it is in object or a cursor or whatever. This is what you get when in VdBase you say object. Alex hi, It seems to me I understand ...Show All

• Chuck Turner cannot generate an exec file

  I just finished a large project and tried to generate an .exe file from it. I encountered the following problems. BUILD EXE FROM ..... issued from the Command Window gives me a series of errors. The first one is entirely unexpected. It claims that a file "inpARR" could not be found. When I click on "locate' it offers me a file dialog box to find it. I definitely do not have any reference to a file by this name anywhere in my pr ...Show All

• parthsaha Combine records into 1 text box using ALLTRIM

  I have a table that has City, State, & Zip in separate fields in a table. I want to combine those fields to fit in a single text box on a form. So far I have learned that I need to add this ALLTRIM(City) + ", " + ALLTRIM(State) + " " + ALLTRIM(Zip_Code) .  I thought I could put this in the expression builder but I get an error saying "The data source for this object must be a variable reference."  What am I doing wrong Thanks ...Show All

• SupermanAlchemist pulling data from one field and making a new column out of it

  Hi all!!! I have two fields, work_id and sp_id. All sp_id's are related to the work_id's ie. work_id sp_id 1 000 3 000 3 111 5 111 9 000 9 111 i need the data to be listed by the work_id, then in another colum have it state whether it is one sp_id, the other sp_id or both sp_id work_id sp_id 1 000 3 both 5 111 9 both any insight life is short ...Show All

• Bardur 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

• Weixiao Fan Docking PrintPreview toolbar and Making PreviewContainer Modal Window

  Hi, I am facing problems in the reportlistener class, my requirement is 1) i have to preview a report with the preview toolbar docked and should be moved from the position. 2) The PreviewContainer should be Modal and no other window should be accessed. 3) no resizing of the container and should occupy the application fully. I used the ReportListener Extension Handler Classes and Set the PROCEDURE Show ( iStyle ) THIS ...Show All

• liujun Deleted records still getting fetched

  ok so I have deleted records in a VFP 6.0 table, and when I query anything the deleted rows still get pulled up, what am I doing wrong yes that worked, thanks very much! >> O k so I have deleted records in a VFP 6.0 table, and when I query anything the deleted rows still get pulled up, what am I doing wrong You must have either SET DELETED = ON or include NOT DELE ...Show All