Answer Questions

• SLMOFLZ Customising RI messages

  Hello I'm after a bit of advice. I'm currently revisiting Foxpro after a period of 10 years. I am in the process of designing a database for a customer that will include Referential Integrity. I have RI working - no problems. What I would like to find out is how you customise the RI error messages. I would like the user to see an error message they could understand rather than something like "Table insert fail:trigger failed". I have looked t ...Show All

• Erik_VB! Calendar control?

  Does any one know of a Free or cheap shareware (So I can try it before I buy it) calendar control I want one with big boxes so I can put custom text on specific days. I need an on onclick() method for the date boxes as well. Thanks; Sammy Don't know about free ones. As customers pay for it anyway, I use stuff from DBI-Tech. A great company and works well with Visual FoxPro. http://www.d ...Show All

• Lakshmi1341 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.     Aleniko wrote: Can one use CDO if the SMTP server is an ISP You mean that the SMTP server ...Show All

• stax0711 Index on Deleted() VS .NOT. Deleted()

  Which is best for performance index on deleted() tag del or index on not deleted() tag notdel Thanks Probably neither of them. Check fox.wikis.com. Right wOOdy. I neglected to mention BINARY. It is always a good thing (tm) when we have a better solution in VFP! :)   As I understand it, even with binary, it's not always a good ide ...Show All

• iamajloppy Design menu and manager users from DBF table.

  Hi all; I want create table DBF to design menu and manager users: EX: menu.dbf (items C(150), command C(100), skip L, picture C(100),...) How when run app will active menu Thank! DEFINE POPUP popGrid RELATIVE FROM MROW (), MCOL () SHORTCUT FONT "Arial",9 i = 0 cPrompt = "" SELECT menudata SCAN i = i +1 DEFINE BAR i OF popGrid PROMPT ...Show All

• jony_cool Use ADIR to get specific files from a folder

  Chdir (SOURCE_FILE_DIR) numfiles= Adir (filearry) I know you get files that have a specific extension like this: Adir( filearry , '*.TXT') BUT can you use a negative condition with Adir Example: get files from a folder where the extension is not .txt or .dat Or, since you are most likely going to be using your filearray in a looping structure to process the files in some fashion, why not forego it altog ...Show All

• Sinisa Day Time Picker little trouble.

  Back in Visual dBase days we used regular spinners for dates but here in Fox the spinners do not seem to like dealing with anything but numeric values. I placed three day/time picker controls on two different containers that are supposed to become visible or invisible depending on some buttons being pressed. I am certain the pickers' parents are the containers however when I make the containers invisible (setting .visible to .F.) the pickers sta ...Show All

• Adrian Browne Converting VFP reports to PDF 6 or Higher version

  How can i convert visual foxpro reports to PDF 6 or higher version from visual foxpro appication and opend automatically. I was having a tool which works fine for Acrobat 4.0 version which uses Acrobat PDF Writer and Acrobat Distiller. Now in the latest version of PDF its creates the printer as Adobe PDF AND now the Windows 2003 server only the higher versions are getting installed. Plese help me in this regard Raman Check out the excellen ...Show All

• Rick0124 VFP 9.0 SQL worthless under a non client server network?

  Hello everyone; I have posted this problem here and also on UT and no solution yet. I have a small network with a 2003 server, and XP pros. I am running vfp 9 select * from products where status = "S0000" takes apx 10 seconds when run over the network. When running this locally, it takes only a fraction of a second. The product table contains 100,000 records, and the result of the SQL command is just a few hundred rec ...Show All

• AlanBlythe table buffering mode

  On a statement like this: IF NOT initTableEmpty TABLEUPDATE () ENDIF I get an error: This operation requires table to be opened in buffering mode . SQLBUFFERING is set to ON before the table is opened. It does not help. Actually the error happens once in a while for no reason. I cannot understand what triggers it. Most of the time the statement works. The USE command does seem to have no option for buffering either. Is any h ...Show All

• Christoff Working Folder

  With VFP 3.0 I always checked whether the EXE folder sys(16,0) existed in the same folder as the current working folder set("default") + curdir() . If they did not match then I knew that CONFIG.FPW would not be read. So I would exit and display a message telling the user to modify their shortcut. Is there any way in VFP 6.0 and newer to make sure CONFIG.FPW is read regardless of the current folder or method used to start the program ======= ...Show All

• Teknologik help~!

  Hi everyine i want to learn about cursoradapter class. for instance ,how do i can browse, modify, add, deleted, restore data into table by using CA.then could you tell where i can find the materials of CA.;=) thank you Jet ok，i got ， thank you jet To add to Mark's reply: we've got a couple of articles on CA's on our website: http://www.foxite.com/articles/049.htm http://www.foxite.com/articles/053.htm http://www.foxite. ...Show All

• Devast8or is this a bug in vfp9?

  Hi, i am using VFP9 on win98,XP & W2k. i use following code to obtained new prn_no. i.e. if all prn_no are in sqeuence, code will return last prn_no + 1, and if any record is missed, then that missed no. will be returened. select prn_no from sm_student_master where section_id = 1 order by prn_no into cursor cursor_temp locate for prn_no <> recno() if found() ln_prn_no = recno() else ln_prn_no = _tally + 1 endi ...Show All

• Mick Beeby HOW TO GO TO SECOND PAGE OF RTF OLEBOX

  I am experimenting a form with OLE box containing RTF Text. The content of this is from a memo field. I copied this screen from the Samples\Solutions\Ole TEXT.SCX My question is : When I open the screen, HOW DO I GO DIRECTLY LET'S SAY TO THE MIDDLE OF THE MEMO FIELD WHICH IS THE SECOND PAGE OF THE BOX. INITIALLY IT GOES TO THE FIRST CHARACTER OF THE MEMO FIELD THAT IS DISPLAYED. Kindly help and thank you for your previous help extended. ...Show All

• Chien-hao Wen data grouping report form

  dear all, i have a table field22 as Y / N value. I use data grouping to print receipt by printing Y then N. i wan my output similiar like this : - item qty u/price u/amt - Y details item qty u/price u/amt - N details But the problem now its print item qty u/price u/amt - Y let a gap that is reserved for group header details then print group header then ... My questions can i move out the spaces for ...Show All