Answer Questions

• JFoushee SQL Server Express & Foxpro-populating SS from Foxpro

  I've placed more of the code at the bottom of this message. The problem is with the Insert command with SQLEXEC. If I use: lcStr = ["INSERT INTO SAUTHORS(firstname,lastname) values ('] + m.firstname + [','] + m.lastname + [')"] lnResult=SQLEXEC(m.lnConn, m.lcStr) The error I get says: Connectivity error:...Could not find stored procedure 'INSERT INTO SAUTHORS(firstname,lastname) values ("Kareen","Abdul-Jabar")'. If I use: lcStr = ['INSERT INTO SAUTHORS (firstname,lastname) values ("] + m.firstname + [","] + m.lastname + [")'] lnResult= SQLEXEC (m.lnConn, m.lcStr) I get an error that says Invalid Syntax. Can someone steer me in the right direction I want ...Show All

• shmulik_segal Out of control when printing out the report designer

  Hi I put the PO No.: || df_indent___ || on the report designer. In 'Print When' properties, I click on the 'Remove line if blank' checkbox and write the following cod e as below. (.not. empty(df_indent) and (_pageno>1)) or (.not. empty(df_indent) and (_pageno=1)) Example of the output result when printing. On 1st page of the report designer PO No.: Testing ABC On 2nd page of the report designer Testing ABC I want to make the PO No.: appear on the 2nd page too. Is there anything mistake on my code Sometimes, there is no input on the form that is linked to the report designer when printing out. For e.g, I do not type out the 'Testing ABC' beside PO N ...Show All

• grhomm application and webdata interacting.

  ok first off here is some info about my webserver: i dont no if you needed the information but maybe you do General server information: Operating system Linux Kernel version 2.6.17.11-grsechg Machine Type i686 Apache version 1.3.37 (Unix) PERL version 5.8.7 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail PHP version 4.4.4 MySQL version 4.1.21-standard cPanel Build 10.9.0-CURRENT 117 Theme cPanel X v2.6 ...Show All

• cgatti Detect hard diskk serial number.

  Dear Expert, Can I know how to detect the hard disk serial number or code using foxpro Thanks a lots. Hi You can do this using WMI (an internal database of objects maintained by Windows) This code returns the serial # of my local hard disk(s) oWMI = getobject("winmgmts:") oDisks = oWMI.InstancesOf("Win32_PhysicalMedia") for each oDisk in oDisks     "serial # " + oDisk.SerialNumber next The syntax will be slightly different for VFP6 or earlier, and this could be run remotely: see here for more info. --stuartd If you mean the one that format creates: Declare SHORT GetVolumeInformation In Win32API;   STRING @lpRootPathName, String @lpVolumeNam ...Show All

• MariaF SCREEN RESOLUTION

  HELLO EVERYBODY, CAN WE SET RESOLUTION PROGRAMATICALLY IF YES, PLEASE TELL ME HOW Thanks but do any webiste teach how to create OOP framework Hm my design resolution is 800x600 but when i install my program to my customer . his screen resolution is 1024x768 . Its makes my program screen so .... How do i fit my program to my customer screen Thanks in advance. Do a search for VFP Resizer classes on Google or other search. You can drop one of these classes on a form, set a few lines of code and it does all the work for you. It is not as elegant as Anchors but it works. If you want to increase the size of your forms to fit a bigger screen (i.e. more resolution), ...Show All

• Rush hour VFPOLEDB - Repeating 512 characters in Memo field

  I am working with developers who are trying to populate a VFP DBF memo field with text held in an SQL VARCHAR(4000) field. When run, the code populates the DBF memo field with the correct number of characters but when you check the content of the memo field it contains nothing but the first 512 characters of the VARCHAR field repeated over and over again. We've upgraded to the most recent version of OLE driver but the issue still occurs. The strange thing is that on the development machine the issue does not exist, even with fields using the full 4000 characters in the SQL DB, but we can not identify where the difference in configuration is! Could it be a buffer setting I need to define in the registry Can anyone help ...Show All

• Andrea Pagliano Picture position in command button

  In VFP9, I have just put my first picture on a command button. For "Picture position", I have "13 - Above caption, centered with caption along bottom (Default)". For caption "Alignment", I have "9 - Bottom Center." However, the caption does not align center, it aligns left,, the same as "7 - Bottom left". Is this a know glitch in VFP9 Hans L Is the button tall and wide enough for the graphic Are you using an icon file or a BMP I will check later today and get back with the info. I have used both an ico and a bmp, and in the bmp case, the text went under the icon correctly when I used Alignment 2 (default). More details later. Don, I am leaving this forum ...Show All

• knave build version #

  in the project manager when you click build and then click version i have mine set to auto incretment. My question is how do i reference this # so i can use it on my login screen Use agetfileversion() with application.servername. ...Show All

• brajeshkumar69 SCATTER/GATHER

  Hou can I "scatter" in a method (valid) and "gather" in other method(click).My vf.7 is forgetting all "m." variables between methods. Thanks, Daniel You are missing something VERY basic about memory variable scoping. Unless it's declared PUBLIC (a bad idea), a variable is scoped to the procedure (method) that declares it and possibly called procedures (if PRIVATE). When a method that creates a variable ends, the variable goes out of scope and is released. A far better mechanism for making values available across all form methods is to create a property of the form. (From the Form menu, choose New Property.) I tried but gather is not working... ...Show All

• ahmedilyas Connect to Outlook Express and Microsoft Outlook

  Dear Expert, Can I know how to connect to the Outlook Express and Microsoft Outlook using FoxPro Like the data in a memo feild how I connect or send out using the Outlook Express and Microsoft Outlook Or Can I generete email using FoxPro Thank you.     bankim wrote: Sir,Please find the code as under & i am getting the error on send() command line Are you connected to the internet when executing this code I have configured the Outlook Express perfactly. & able to send/receive the mail from outlook express. But does not know how to auto use the outlook express from VFP code.Also how to use the CDO as i am totally new to ...Show All

• SONAL N. SATPUTE Error loading file

  Hello, I can't open same forms and report, I getting error "Error loading file - record number n. "object" <or one of its members>. : Memo file c:\mypath...\my database.dct is missing or is infalid Is there a way to open these file I will deeply appreciate advices or ideas.. Thanks. pleace write to me if same one have other solution for this problem, validate database doesn't help me I alredy done it, but I dosen't see anything suspicious in the table. when the form isn't conect with database it is open ok Look at validate database recover command. Aleniko I had 2 times this problem : 1.All my files from my current working folde ...Show All

• naiad Wait Window "" timeout 0.01 and Sleep(10) in VFP-9

  At times my VFP processing requires *rest(s)* it seems. (report processing/printing, various functions, .BeforeRowColChange events, etc.) I've *discovered*: Wait Window "" timeout 0.01 && ... helps at times while the preferred: Windows API Sleep() routines && ...I've had NO success with API Sleep() declarations Any general or specific feedback concerning *rest(s)* in VFP-9 is appreciated. >> Interesting, I erroneously concluded this was somewhat of a norm. There certainly are cases where VFP processing is interrupted by the necessity to process windows events (you can control this to some extent with the DOEVENTS command) and of course, if you are reading a large amount of data into memory the ...Show All

• usefulacct COntroling objects

  I have 2 forms, Form1 and Form2. In Form1 I have a grid and a button, when I click the button I call Form2. What I want to do is to control the properties and methods of the grid inside Form1 from Form2. How can I do this One way is to pass to form2 a reference to the calling form. Like this: do form2 with thisform this way you can control anything you want in the calling form from form2 because now you have an object in form 2 which is the calling form. Aleniko So, if I wanted to change the RecordSource property in the grid inside Form1 from Form2 what should I do Ok, first, call Form2 from Form1 with the following line Do form2 with ...Show All

• ChristopherC Azeri(Latin) Locale in

  How do I get the characters , , , (those with unicode > 255) in Azeri(Latin) in Visual Foxpro 7 or 9. Our software (developed in VFP7 & VFP9) cannot print or capture these characters well. We have a client who needs to use this locale but cannot because of this limitation. In fact even in the development environment the text editor does not translate them. Is there anything else I have got to do. Thanks. William, Crystal Clear Software ltd (Uganda) You may find something here: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/ab8fbdad-875f-4c41-883c-bb5afcf8c54d.asp I have my both code page 1254 and 1251 set on my machine. Please if you may, ...Show All

• Tonito01 vfpencryption.fll

  hi all, i came across a library file to encrypt and decrypt from tis website.http://www.sweetpotatosoftware.com/SPSBlog/PermaLink,guid,23a74c5d-5173-420e-af23-22494d95a54c.aspx after i download the fll files i try encrypt but vfp prompt me invalid library file. set library to c:\windows\desktop\vfpencryption.fll. where is my error Thanks in advance. Hm after i tried so many ways. i can encryptfile but when i decrypt even not same filepath it will prompt API causing illegal expressions. "API caused an exception" May i know what is the problem Thanks in advance. I don't use it so I do not have a ready answer for you. I suspect it may have something to do with lack of proper ...Show All