TXT file
Hi,
When I need to build a ASCII file from a table I use :
COPY TO mytxt SDF
But now I need to create a TXT file in which records have a diferent lenght.
How can I do?
Thank.
Catherine Tag: Blat Tag: 184356
webserver help
is it posible to manage databases to read, write, and delete placeing it on
a webserver. am new to this concept. in case if we want to access a database
whihc in a webserver, in what way we have to locate the path. either by
\\webserver\dirname\emp.dbf or some thing diff??. replies andhelp will be
useful.
thanks
periyur Tag: Blat Tag: 184349
Basic question
I have a form that gathers data to be emailed. The
gathering process works fine. On the form is a button
captioned email. The click event contains the following
code:
PUBLIC lANS
lANS = .T.
Do While lANS = .T.
* (Gather data here)
.
.
* Now that emailstu.dbf contains the class roster, we gen
* some html and open the mail program so we can navigate
* to the test.htm file in the Visual FoxPro folder and
* attach it to our message.
DO (_genhtml) WITH "test.htm", "emailstu.dbf"
DECLARE INTEGER ShellExecute IN shell32.dll ;
INTEGER hndWin, STRING cAction, STRING cFileName, ;
STRING cParams, STRING cDir, INTEGER nShowWin
cFileName = "mailto:sagrm@yahoo.com"
ShellExecute(0,"open",cFileName,"","",1)
SELECT emailstu && prepare for re-execution
USE
SELECT emailsac
USE
DELETE FILE emailstu.dbf
DELETE FILE emailsac.dbf
DELETE FILE test.htm
DO FORM ask && get yes or no
IF lANS = .F. && if no, get out
EXIT
ENDIF
ENDDO && do again
thisform.Release
If I stop the program after the delete file test.htm all
is well. When I add the DO FORM ask, the ask form comes
up and then the OE email screen and I never get to reply
yes or no on the ask form which would set the proper
logical value for lANS. Of course it then goes into a
loop.
Is it possible to serialize the call to the email client
and the DO FORM ASK?
TIA Tag: Blat Tag: 184320
lost custom control - can't open
I made a custom control and placed it on a form. I have
since lost the custom control and now I can't get into my
project file with that form. Anyone know a way around
this? I don't really need the custom control anymore
anyway, so I don't mind if it's not working. Tag: Blat Tag: 184316
Investor ease Programme
I use investor ease financial programme to download share
prices, but ever since I changed to a new computer with
XP Home on it, I continually get a fatal error message
regarding Visual Foxpro and the programme shuts.
I have tried the compatibility programme but that does
not help.
Any one out there know of a solution to the problem? Tag: Blat Tag: 184314
Syntax Error
I am attempting to save an open Excel spreadsheet that
was created with FoxPro and I get a Syntax Error.
Everything I checked looks good. Can someone see
something.
Here is the command:
oExcel.ActiveWorkbook.SaveAs FileName:="s:\srs\central
error correction\foxpro\book3.xls", _
FileFormat:=xlNormal, _
ReadOnlyRecommended:=False, CreateBackup:=False Tag: Blat Tag: 184300
Virus's Crazy
Well i was a moron and left my real E-Mail address on news reader. I have
been getting bombarded with e-mails claiming to be from microsoft which
contain a attachement which is a virus. If you were not aware of this keep
an eye out.
Later,
Keht Tag: Blat Tag: 184296
POS Pole Display Code & Display Question
Can anyone recommend a good pole display for a point of
sale application that I developed? Also, what would I
need to run the display?
Thanks Tag: Blat Tag: 184277
portability of DOS based FOXPRO 2.6 programs
Is it possible to modify or interpret a DOS based FOXPRO
2.6 program to visual FOXPRO? I have a custom program
built in FOXPRO 2.6 that I would like to update and
continue using but unfortunately it is DOS based.
Do I have any options?
I am willing to pay someone to help with this.
Thank you for your help.
Eric Dilg Tag: Blat Tag: 184271
.tps data files
I use a poorly written software that uses .tps data files.
Anybody know of a or have a utility that reads .tps data files
and converts them to .dbf?
-----------------------------------------------------------------
Paul Lee ......... Abri Technologies ....... http://www.abri.com/
'Recover' - top rated FoxPro file repair utility.
----------------------------------------------------------------- Tag: Blat Tag: 184270
Outlook 2002 and FoxPro
When sending e-mail from a Fox Pro program I wrote I get this annoying
prompt from outlook telling me that a program is trying to send an e-mail,
you have to click twice to get by it. How do i disable this security
option? Tag: Blat Tag: 184263
running VFP 8.0 applicatons on LInux servers
NIhad
Bosnia and Herzegowina
pukuzen@bih.net.ba
What is your opinion on running VFP 8.0 on Linux servers with WINE?
Will it ever be better than Windows environment?
Best regards. Tag: Blat Tag: 184260
Multi Language support for VFP7 application
Hi all,
I have been trying to figure out from the help files how to be able to view
and enter data in Chinese into a vfp7 environment.
I have installed Traditional Chinese on my W2K machine
I put CODEPAGE=936 in my config.fpw
I've set the font to some various Chinese ones in the FoxPro editor and all
I get is a ? whenever I try to enter a Chinese character (which are all
doublebyte)
I've even set my default windows language to Chinese and that doesn't help!
How the hell do I get this to work????
I'm just trying this in a VFP7 environment to start with, before I try and
include it in any apps!
Any pointers would be great. Also can someone poke the VFP team at microsoft
in the eye for not detailing this in the help files. They go on for ages
about supporting it but not actually how to do it.
A million thanks in advance for any help you may be able to give.
Rob
PLEASE REMOVE NOBLEEDINGSPAM FROM MY ADDRESS IF YOU WANT TO MAIL ME. Tag: Blat Tag: 184259
Where is VFP8?
I just received my MSDN Professional subscription and I cannot find VFP8 on
any of the disks. That is the only reason I bought the subscription. Does
anyone know the trick to install VFP8?
TIA,
jrg Tag: Blat Tag: 184255
Menu Bar
Hi guys,
Got another question, I have got the function which
restrict the user from viewing certain report or
function. Therefore there is a menu bar number that
control that, s sample of my code;
DEFINE PAD _13512dh6k OF _MSYSMENU
PROMPT "House\<keeping" COLOR SCHEME 3 ;
KEY ALT+K, ""
DEFINE PAD _13512dh6l OF _MSYSMENU PROMPT "\<Help" COLOR
SCHEME 3 ;
KEY ALT+H, ""
DEFINE PAD _13512dh6m OF _MSYSMENU PROMPT "\<Edit" COLOR
SCHEME 3 ;
KEY ALT+E, ""
ON PAD _13510zclf OF _MSYSMENU ACTIVATE POPUP files
ON PAD _13510zclg OF _MSYSMENU ACTIVATE POPUP maintenanc
ON PAD _13510zclh OF _MSYSMENU ACTIVATE POPUP jobcontrol
And as a result of these number (_13510zclf) changes, my
menu could not work. Does anyone know what are the method
to set it to work?
Sigh.... really at a loss now...
Edwin Tag: Blat Tag: 184250
VFP8 and RS232
Does anyone has experiance according a connection between
VFP8 and RS-232 com port.
What I would like to do is to create a logical input and
output and implementing it into the code.
Example:
input; with a pushbutton is to print a document.
output; is to say with a LED the printer has printed or is
ready. Tag: Blat Tag: 184242
Function loss
Hi Guys,
I had installed vfp 8.0 and must say that the graphical
interface looks great!
I now face a problem. I have an application that allow
user to select the company and upon double clicking or
click on the "select" button. It would bring the user to
the login screen where they need to key in the password
before they can login.
Now, I'm trying to bring back to the select company
screen. However, I discover that I could not double click
on the company.
Does anyone know what happen? I'm clueless!
Edwin Tag: Blat Tag: 184241
cursor shape in vfp 6.0
Hi! I am using vfp6.0 in windows 2000 os. Whenever I
starts vfp6.0, I finds my cursor shape to be vertically
thin. Sometimes, I even can't identify its position on
screen. I want to change cursor shape. i.e. It should be
solid shaped, and in different color like red,green
etc.Would you like to give any help regarding the above
problem. N.B.-I am talking about the cursor that appears
in edit/text boxes, not the mouse pointer shape.
Thanks
Pushpak. Tag: Blat Tag: 184236
Adding a method to a form that's in a formset
Hello,
I would like to add a method to a form that is in a formset, but it
seems that when I use the Form->Add Method menu item it adds it to the
formset instead of the form.
How do I add a method to a form instead of the formset?
-Caleb Tag: Blat Tag: 184230
Exporting to Excel
Just checking to see if there is an easy way to do this.
I want to export a table to excel and have it break up
the table by Item Number and place all matching items on
a worksheet and make a new worksheet with the next Item
Number.
I know I can export the entire table, but I am checking
to see if I can group it by Item Number on separate
worksheets.
Thanks in advance.
Doug Tag: Blat Tag: 184221
Netware VFP Libraries
Anyone used a Netware-specific library lately? We want to, inside a custom
VFP app, grant users Netware rights to files/folders they don't normally
have, and we will remove those rights upon exit from the program.
TIA.
-S- Tag: Blat Tag: 184219
Roaming Profiles
Hello All,
I have a customer experiencing a problem running an application created in
VFP8. They use Roaming Profiles. A user can login to a Win2000 machine on
the network and run the APP no problem. However, once that same user logs
into the network on an XP machine they can no longer run the application on
any of the W2000 machines. Seems that XP is changing the Roaming Profile on
the server in such a way as to screw up W2000's ability to run the same APP.
Does anyone have any experience with this issue and/or know how to fix it?
Here is an email from my customer which helps explain it:
*********************************************************
Regarding the Windows 2000/XP Roaming Profiles Problem:
Removing the file NTUSER.DAT in the individuals profile directory on the
server and from their profile directory on the Windows 2000 Workstation,
VFP8 (and Crimestar) will function again. Removing this file forces the
workstation to load the Default user registry entries on login, rather than
the stored settings.
Since this works, I have to conclude that a registry setting in HKEY_USERS
is getting changed by Windows XP and causing problems for Windows 2000. I
can't find it. If you can find out what registry settings are used by VFP,
I should be able to come up with a workaround.
TIA
Alec Tag: Blat Tag: 184211
FTP from VFP
Hello all,
I need to connect to a Server and send some files. The computer I must use
has a modem but does not count with acces to internet, is it possible to do
what I need with these elements?
Thank You in Advance Tag: Blat Tag: 184206
Append Memo from FileName or FILETOSTR()
Hi all,
I want to save a couple of .PDF files in memo fields to avoid these file
being deleted or messed by the users, using VFP8 I have two options:
FILETOSTR() or APPEND MEMO FROM FileName...
Can anybody point out which method should be best since they accomplish the
same goal and the size of the memo file are also the same using either
command.
Thanks.
--
Edhy Rijo
Programming System Solutions www.progytech.com
Bronx NY Tag: Blat Tag: 184203
MSGraph and VFP8.0
Question:
I've got an application that about ready to go into
production but I've got one concern. Does the MSGraph
component thats available in VFP8.0 work on computer
without a MSOffice? Tag: Blat Tag: 184198
Regarding Exe File running in VFox 6.0
I have created a Top level form, and coverted into a Exe
file. I put that Exe file along with VFP6r.DLL,
VFP6renu.DLL, FoxTools.FLL, files in the same folder. But
still that Exe file didn't runs Why?
Waiting for your reply. Tag: Blat Tag: 184196
VFP bug with #define and comments
I beleve I have run across a VFP bug - or at least an "issue" or "feature by
design". Do this: Create a project. Create a class library. Add it to the
project. Create two custom methods in the classlib. In one of them put this:
#define MY_CONSTANT 123
In the other method put:
#define MY_CONSTANT 123 && comment
Now compile. You will get "Constant is already created with #define" error.
Now change the first entry above so that it too has a comment. Compile. No
errors. Note - this compiles fine in VFP5, but will generate the error in
VFP6, 7 and 8.
It appears that you cannot define the same constant in more then one method
AND have an inline comment in one AND not have an inline comment in the
other. They must both have comments, or no comments. You can't mix them. Tag: Blat Tag: 184190
What's about VFP and .NET
I don't know if somebody could answer me here, but I would
like to know what happen with VFP actually in the market?
I was a VFP programmer since the beginnig, but for a
couple of years, I have worked with JAVA in web
development and I didn't used VFP since about 4 years.
Why VFP is not a part of Visual Studio .NET? (Visual
Foxpro .NET for example)
Is VFP will continue to be supported by Microsoft? I saw
that VFP is now on version 8, what is the future for VFP?
Is Microsoft will integrated VFP into the Visual
Studio .NET tool in the future?
Thanks to answer me
An old VFP developer, who wants take the road again!
Serge Tag: Blat Tag: 184187
Record locking
The program that our campany sells has been a single user app since the day
it began. It is now becoming a multi-user app. I am still new to FoxPro
and I have to start adding some record locking. I had a few questions I was
hoping someone could help with.
Does the table or record I want to lock have to be in the data session?
Is there a time limit I can set on a record/table lock?
What if I forget some code to unlock the record, will it unlock when the
program closes? or if the program errors while I have a lock will that lock
be released?
TIA
Altman Tag: Blat Tag: 184186
Help me .. windows trouble
Hi
Let me thank those who helped me before.
I have developed an application using VFP7
When I open 2 or 3 programmes (like words,excel etc..)
alongwith my application, my application is always on top.
When i click the minimised icon of other programmes in the
status bar, they do not show up. I have to minimise my
application to see the other windows including the help
window of my application.
Even sometimes, when I open some files through my
application, the "Open Dialogue" window is behind my
application. Unless I minimise my application, I can't
access that window.
Can any one help me please?
Thanks and regards
Bala Tag: Blat Tag: 184182
size of application form
If you set the _SCREEN = OFF in config.fpw how can I tell the size of the
user's screen resolution. I have a form that is set to "Always on top" and I
want it to resize according to the size of the users desktop. What I would
normally do is check the height and width of _screen but that does not seem
to be working (maybe because I am using skins). Is there any api calls that
will give back the screen resolution?
Thanks Tag: Blat Tag: 184177
VFP8 SP1 Problem
The following code snippet runs fine in VFP7 and VFP8
Just put on VFP8 SP1 and the code fails (although it runs fine in the
compiled executible).
Any ideas?
Cheers
David
SET TALK OFF
SET RESOURCE OFF
SET STATUS BAR OFF
SET EXCLUSIVE OFF
IF TYPE("_Screen.Screenhook") # "O"
_SCREEN.ADDOBJECT('screenhook','screenhook') && Reset screen resize
ENDIF
DEFINE CLASS screenhook AS CUSTOM OF testlib.VCX && My Custom Class Library
oScreenRef = _SCREEN
oListbarref = .NULL.
PROCEDURE INIT
PARAMETERS ListbarRef
THIS.oListbarref = ListbarRef
ENDPROC
PROCEDURE oScreenRef.RESIZE
IF LEFT(UPPER(WONTOP()),15) = "REPORT DESIGNER" OR
LEFT(UPPER(WOUTPUT()),6) = "PPRINT"
RETURN
ENDIF
IF TYPE("this.screenhook.oLostBarref") = "O"
THIS.screenhook.oListbarref._resize(105,_SCREEN.HEIGHT-6-SYSMETRIC(20)+(SYSM
ETRIC(4)+1)*2)
ENDIF
ENDPROC
ENDDEFINE Tag: Blat Tag: 184170