Answer Questions

• Jym How to pass a variant value to CFRONT object (Navision) ?

  Hi, I need to pass a string value to a COM Object the method styax as follow S/W Name : NAVISION COM Object : CFRONT.OCX Method AssignField( hTable as Long, hRec as Long, FieldData as Variant) as Void My program source code is ************************************************************ loCF = Createobject("cfront.cfrontctrl.1") lc_Data = "Testing" loCF.AssignField( 1, 2, lc_Data) ****************** ...Show All

• Babak Zallaghi How to perform group by and order by AFTER union?

  Hi, I have a SQL statement like this: SELECT * FROM (    SELECT * FROM A     UNION     SELECT * FROM B) GROUP BY 1, 2 ORDER BY 1, 2 Is there any way to translate it to FoxPro 2.5 compatible Thanks. I think you can use this : SELECT * from A ; UNION ; SELECT * from B ; group by 1, 2 ; order by 1, 2   ...Show All

• Mike Hatch BLINK

  Looking at the result of DISPLAY STATUS command I found that my "BLINK" was ON. I cannot find anywhere in the help any mentioning of it. I am very much interested in exploiting this property, I assume it is a property somehwere My hunch is that if blink is on for let say a textbox then the color of this textbox will change rythmically or something. There was a comparable property in Visual dBase though I've never used it ...Show All

• Ali Enteshari 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

• Psinha371 Container 'when' method?

  Hi; I don't see a when event for a container. I am using 'gotfocus' but if there is a command button in the container, and I want to prevent the user to click it (in some cases), gotfocus is too late bacause the button's click method already fires. Any ideas how would I conditionally prevent a user access to everything contained in a container Thanks, Aleniko thisform.container1.Enabled= .F. ...Show All

• Jason Strate132015 VFP6-Did anyone experience this problem (with ActiveX Ctrl)?

  hello guys, I post here my problem and hope that there will be certain VFP expert to help. The problem was that when i call the MouseDown event from an OleListView control (this ole is inserted in FORM1). This MouseDown event will show a shortcut menu (1st shortcut). A Command in the 1st shortcut will open a modal form named FORM2 and on form2 is also placed another activeX listview control. The MouseDown event of this olelistview will show a ...Show All

• Daniel Moth can i just use sql to get this?

  date           transfer 20050101    200.00 20050103   -100.00 20050530     95.30 ... SQL to get： date         transfer          balance 20050101   200.00         200.00 20050103   -100.00 &nbs ...Show All

• smar using vars in a thisform. statment

  Hello again, I have a problem using a variable in a thisform. statment. I tried it using the following code: IF v_sichtbar < 10 then         DO WHILE v_sichtbar < 11             v_button = "button0"+ALLTRIM(STR(v_sichtbar))             v_label = "label"+ALLTRIM(STR(v_sichtbar))         &nb ...Show All

• Andres Orozco Report Window

  I have designed a form which includes a preview button, when I click the preview button, the report preview is working, but it was showed behind of the form, how would I do to show the report window front of the form can anyone help Thanks a lot. What is the setting of the form's AlwaysOnTop property Yes, the right suggestion for my question, because i have set the form is always on top. now I have solved the problem al ...Show All

• Randy Brown The ability of network multi-sharing for VFP6.0

  Do any expert know the multi-sharing ability of VFP6.0 .exe file Is there a limit for this Any other VFP upgrade versions produce better performance on this issue  Any comment is appreciate. There are no specific limits, and I certainly know of VFP applications with hundreds, if not thousands, of users. I don't know of any specific problems with performance in VFP 6 or any other version. The usual ...Show All

• Branch COPY TO Command

  In Visual Foxpro, I am trying to create a CSV file using the COPY TO command with TYPE CSV, but do not want header fields on top of the output file. Furthermore, I am also trying to attach a COMMA after every row. Current Output f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17 "0","49162","0","0","0","0","0","0","0","0", ...Show All

• Sr Rob 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

• Rakin HOW TO DEFINITLY REMOVE A TABLE'S RECORD FROM A FORM

  Hi! I have a problem! I have done a form, that slide me a table when I press a botton! But, when I press the DELETE botton for definetly remove the selected record from the table, VFP, give me an error: "alias 'NAME_TABLE' is not found"!!! This is my source-code:     OPEN DATABASE +'\WINDOWS\Desktop\Visual fox\ database_name.dbc '     delete in table_name     skip in table_name   & ...Show All

• DIFSMGULD2005 Using Browse command in VFP9

  I used FPW2.6 untill a month ago , since then I convert most of my old programs to VFP9 , all is working fine except one major problem I have , the Browse command is not working in an stand alone EXE program , I know I can use the grid option but still the browse command was an easy way to display records in a file, is there a way to use the browse command in an EXE file Thank's for help Browse works with top ...Show All

• Zorb How to show images(pictures) in RTF control??? (like chat...)

  I am not able to insert a picture in RTF control. I am using following code: thisform.rtfcontrol.oleobjects.add(,,"mypicture.gif","paint.picture") When I execute this command a picture viewer appears. When I close it a object with a title "mypicture.gif" appears in the RTF control. I want to see a picture not a name of the file without loading a picture viewer window. Thanks a lot. To help get you sta ...Show All