-
- Programatically set report to print in landscape
by Aleniko29139
- 6 Replies
- Last post
by Aleniko
- I have a report which has a dynamic number of columns. I need to print
it in landscape or portrait depending on the number of columns. Anyone
can suggest how I would programatically set the report to print in
landscape
Thanks.
-
- Setting XP or Vista file Tags within a VFP9 Application
by Rob Mitchell
- 2 Replies
- Last post
by Naomi Nosonovsky
- I need to attach some custom file tags to office files from within a VFP9 application, but am not having much luck. Any clues
-
- Grid modification within the Form Designer
by rpp
- 3 Replies
- Last post
by surinder singh
- Is there a way within the Form Designer to remove the column.textbox control from a GRID and replace it with an image control
I am trying to show an image in each record within in a grid can this be done
Thanks in advance to any help.
-
- Help with code for updating table on website
by Jim Holloway
- 10 Replies
- Last post
by Stuart Dunkeld
- This is the code I am attempting to usw to add/edit date in a free table on my website. It opens the table fine and will display what is already in the table, but any changes I try to make do not arent being saved. I dont get any errors. Any help
USE \\www.infotizer.com\lotterydata\NewData.dbf
SET SAFETY OFF SELECT NewData INDEX ON state TO IdxState SET SAFETY ON
SELECT StateLinks SET ORD
-
- Uploading the Parent table
by honey1016
- 3 Replies
- Last post
by honey1016
- -My append program please help me
SET EXCLUSIVE off
CLOSE ALL tabname =thisform.combo1.value set safety off sele 4 use &tabname alias &tabname append from getfile() - this is my sample uploading button. I have combobox to select the table for uploading. But how about in parent table I want to upload all data but the id no is the primary key. What if the table have 25 records and the
-
- A problem overwritting a temporary cursor
by Jim Holloway
- 2 Replies
- Last post
by Jim Holloway
- I have the following code in a procedure that is called from a combo box. The first time trhough everything works great. when I call it a second time I get "Alias name already in use." I need to redo the temporary cursor baised on the selection of the combo box. Any ideas Thanks in advance.
ThisField = ALLTRIM(CGames.DataField) SELECT date,&ThisField,ball1num,ball2num FROM btldata
-
- Report to HTML output problems.
by Aleniko
- 7 Replies
- Last post
by Aleniko
- Hi; I'm wondering if some of you experienced problems with how HTML reports are generated in VFP... I was experiencing small problems like information in the title band not showing etc, but yesterday I got this problem: An html output is generated perfectly on my XP pro machine. But when I deploy the program on a win2003 server, the result of a generated html are all messy and ugly. This happens w
-
- any free resources avail to learn Navision ??????
by My Vizai
- 3 Replies
- Last post
by My Vizai
- Hi Experts,
I'm trying to learn Navison , but i didn't get any resources on the internet.
I'm working in .NET from last 3 years...
Can anybody help me to learn Navision .please..
Any free resources on the web..
Thanks in advance
-
- RLOCK on a DBF file on a Windows Vista Shaded Folder
by Stefano Alderotti
- 13 Replies
- Last post
by dni
- Hi,
I have problems on some functions [at first RLOCK()] when i try to access on a DBF file on a Vista Shared Folder from another Vista PC.
If I try to access or execute Rlock() function, from XP on Vista or from Vista to XP, i have no problems.
When i try to execute Rlock() on this file from Vista i have an "Error Reading File" only when another used already use this file.
-
- SEEK() not seeking
by JCrum
- 6 Replies
- Last post
by JCrum
- The help topic for the SEEK() function only states that it will search for "eExpression". Does anyone know specifically what types of "eExpressions" can be used with SEEK() I'm using SEEK() to find a record but the problem is the indexed field is bigint and the eExpression I'm passing it is a string equivalent. SEEK() cannot seem to make this comparison and the results are mis
-
- Farewell
by AndyKr
- 10 Replies
- Last post
by Joe Morel - MSFT
- Recent events, and postings, in this and other forums have convinced me that I am no longer able to act as a moderator in this forum and have asked that my moderator's privileges be withdrawn.
I shall no longer participate in this forum and hope that whoever takes on the task will do a better job than I.
Later:
I have been asked to say where I can be found outside this fourm so yo
-
- View general field store PDF file problem
by Ooi Kim Hong
- 2 Replies
- Last post
by Ooi Kim Hong
- One of my table store pdf file in general field. Some computers are having problem to access the pdf file when double click on the control link to the general field. There is no error displayed but the pdf file's details won't display on screen. Please advise what are the possible error. Thank you.
-
- Comparing cdx, idx, ndx
by Bit
- 5 Replies
- Last post
by CetinBasoz
- Hi,
I found that there are serveral type of index format for a foxpro table ama.dbf
Does it mean that if I use
i> If I use cdx index, then the syntax would be
index on height tag height.
use ama order height.
or
use ama
set order to height
ii> If I use idx, then the syntax should be
index on height to height
use ama index height
or use
-
- VFP6 to VFP9 broke Dataenvironment.OpenTables
by GeofS
- 12 Replies
- Last post
by Tamar E. Granor
- The <form>.Load() code below, which used to work fine with VFP6, now generates a syntax error (Error #10) after compiling with VFP9. The error occurs on the OpenTables() line. It occurs with multiple forms, all of which have their AutoOpen and AutoClose properties set to FALSE. What has changed to break this simple code local lReturn with this if type('.dataenvironment') = 'O' * m
-
- Expecting Advise on A Graphics Problem
by Lord Arokh
- 3 Replies
- Last post
by Lord Arokh
- Hi Everybody,
I've project, that I have to use a custom worldmap and show some other drawing according their coordinates.Now I managed to draw the worldmap with FORM.LINE method.
To zoom in/out I have to scale the worldmap. When I scaled 10x or much more times I can see the part that is on the form. And the other parts of the worldmap which is extended out of the form is lost. Because the LI
-
- Accessing Data from a Query
by Dohko
- 10 Replies
- Last post
by Naomi Nosonovsky
- Hi
How can I access the Freq variable
In this code
SELECT State, COUNT(*) as Freq; FROM sample; GROUP BY State; INTO CURSOR Counter
If i write
Freq it prints all 1's.
I would like to have access and be able to do Math with that column
Thanks
-
- ERROR in VFPOLEDB.1 (Moved thread)
by ITMike_M.
- 5 Replies
- Last post
by CetinBasoz
- Hi, I am trying to get records from our legacy application w/c is visual foxpro apps. Since it doesn't have any *.dbc I tried accessing it thru free tables using this connection string: " Driver = {Microsoft Visual FoxPro Driver} ; SourceType = DBF ; SourceDB = c:\myvfpdbfolder ; Exclusive = No ; Collate = Machine ; NULL = NO ; DELETED = NO ; BACKGROUNDFETCH = NO ;" but to no avail. I tr
-
- Data not getting written to SQL.
by Pauly C
- 4 Replies
- Last post
by Pauly C
- We recently upgraded client to latest version of app that was also upgraded to VFP 9. Our client runs app in Citrix environment and we are seeing strange behaviors that at times data doesnĄ¯t get stored to the SQL Server 2000 backend, IĄ¯ve been able to prove this by creating and setting up auditing on SQL Server. At times itĄ¯s a segment of data at other times an entire row of data is lost. All o
-
- REPLACE command help wanted
by AlexBB
- 14 Replies
- Last post
by AlexBB
- If not mastering counter intuitive VFP object manipulation was not hard enough in the past until I finally got a handle of it, now trying to do it from OleDb .NET code is like moving through heavy water--it is 10 times more difficult.
I thought I reached the promised land when I finally made PACK work but my joy was premature. Now INSERT gives me the same trouble.
I really prefer to
-
- Command Window in Vista
by AlexBB
- 14 Replies
- Last post
by Tamar E. Granor
- I hope Tamar Granor will read it. It seems she may be familiar with Vista.
I have touched on this problem in my previous post. In VFP 9 Management Studio under Vista, the Command WIndow behaves like the mouse cursor/pointer when you set it up in slow motion and with traces. In addition it frequently bounces back to the place it started. It is unbelievably weird. It is very very, and I mean
-
- Ideas for accessing a remote table
by Aleniko
- 6 Replies
- Last post
by navcool
- Hi all; I am going to distribute an application to a few dozen customers. I would like to have a way for these sites to read/post info to a mysql table on the internet. Is there a way I can connect to a remote table but in such a way that the username and password for the connection would be hidden and secure I would also like to have the means of changing the password to the Mysql database and ha
-
- Rotation vfp helpfiles not working
by Fox Me Up
- 5 Replies
- Last post
by AndyKr
- this code is copied straight from vfp 9.0 help files. i just added the two paramateres
this code works in vfp and when i run just the application on the computer that has vfp installed. however it is not working on non vfp computers. on a non vfp computer all i see is a wait window that says rendering and its tallying up the pages.
PARAMETERS REPNAME,ANGLE_OF_TILT LOCAL oListener o
-
- check for filetype
by ScottCamp
- 10 Replies
- Last post
by ScottCamp
- Ok...I'm Back...LOL
I'm trying to modify and old custom program someone made for us years ago. Simply to move files from one place to another.
Everything works great. I'm trying to check if a file type exists in a directory (since the names will always be changing but the file type will always be a .jpg). If it does, then copy everything in that folder over. if a .jpg doesn't, then give a me
-
- Passing multiple variables from forms w/ VFP7SP1
by KDKephart
- 14 Replies
- Last post
by Naomi Nosonovsky
- I'm an old Clipper (S' 87) programmer that needs to figure out forms with VFP. The attached code generates a form containing a set of four optiongroups that set basic comm port parameters on the local host for serial communication with an instrument (usually an electronic balance). I'm trying to use the form to replace a series of cascading menus in the original program. My intent is for the form
-
- Employee ID No.
by honey1016
- 13 Replies
- Last post
by Naomi Nosonovsky
- Generate New Employee ID. The Format is 99-9999. The first 2 digit came from year date of Entry and the last four digit is ascending order. For example.
Date of Entry = 01/01/2005 employee id no will be 05-0001 until month of december the last four digit is continous. But how for the year 2006 for example date of entry is = 01/01/2006 and it will be 06-0001. The Last four digit back to 0001