Can COM objects be called from both foxisapi and ASP?
I have an application that is calling my com object from ASP pages as well
as via foxisapi. After accessing the com object from foxisapi any attempt to
access the com object from ASP results in "HTTP 500 - Internal server
error". This continues even if I /RESET foxisapi. The only way to fix it is
to iisReset. FoxIsapi does not have a problem with it though and I can
continue accessing the object through it. I can also access the com object
through createobject(..) within fox.
I may have to convert everything over to FoxIsapi but this was planned to be
a gradual upgrade as it is a very big site.
Any ideas would be appreciated. Tag: MonthView and GetDayBold Tag: 201580
how to put pics in database
hi sir,
how can i use the pictures from general fields in tables and can use in
forms picture?
or there are any way else.
i.e. i insert pictures in table in general field and i want to use this pics
from table in forms picture Tag: MonthView and GetDayBold Tag: 201577
Binding _ASSIGN methods
I am unable to bind the properties of two objects.
Say, objects X1 and X2, both have property "D", how can I bind them in a
manner that when I change the property for X1, it also changes for X2?
Thanks in advance
Abhay Tag: MonthView and GetDayBold Tag: 201576
certification for VFP (6,7, or 8)
i'm looking for a way to get certified in Visual Fox Pro (6,7 or 8).
How can i go about doing this???
Would appreciate some info, links, or the like. Tag: MonthView and GetDayBold Tag: 201575
Progress bar with a SQL Select statement
I often use a progress bar within a scan/endscan to give the user visual
feedback and reassure them that the system hasn't hung. I pass it two
parameters: current record number, and max number of records and it does the
business, returning .T..
Is there a way of using such a progress bar or similar with a SELECT
statement. It is an outer join sql using all the records from the one table
so I know the max number of records. However I have no idea how to pass it
the first parameter. I was thinking along the lines of:
SELECT ... INTO CURSOR <filename> WHERE PROGRESS(param1,param2)
The particular sql could take 20-30 secs and a simple WAIT WINDOW NOWAIT
seems inadequate. If this function is not possible is there any other way of
displaying a progress bar while a SELECT is running?
Many thanks
Stephen Tag: MonthView and GetDayBold Tag: 201567
How to Add a New Paper Size?
Anyone know how to add a new paper size to the list of available paper sizes
for a printer?
I know Adobe Acrobat lets you do this.
Is there an API to get a list of available paper sizes or an API to add a
new paper size?
Thanks
Charlie Parker
cparker@fowlersoftware.com Tag: MonthView and GetDayBold Tag: 201558
App does not detect newly added record
Hi,
Just fishing for ideas here. I have two apps which 'talk to' each other.
Idea is that app1 is the UI, and allows users to submit a job request to a
table. App2 is server based and looks at the table via a timer - if it finds
a new job request, it processes it, then looks out for the next one. Problem
I have is that app2 won't pick up a new job request if the job queue table
has a job added after it's been empty. If you restart it, it picks up no
problem, if it adds its own occasional job it works fine, and if there's say
4 jobs in the queue after a restart it will process them all.
This is a VFP8 app running on Win 2003 Server. I'm guessing this is some
multi-user issue. I'm not using the DE - table is opened each time within
the timer code, it's definitely the right table, and a COUNT gives zero
records.
Any help much appreciated.
Cheers,
Neil Tag: MonthView and GetDayBold Tag: 201554
QuickBooks
Converting foxpro database/table to a "csv/text" format it's not a problem.
Anyone has an idiot proof ideea of importing this text data
into QuickBooks? (except manually importing from QuickBooks)
Thanks Tag: MonthView and GetDayBold Tag: 201552
New VFP System
I was handed a vfp system and am not familiar with vfp. I have attended some
general classes on it.
However, the system I have was not redesigned for vfp or done in a
relational database.
It is just tables. with information copied over and duplicated in several
areas.
I know the system needs to be fixed, I have been told with what I want it
would basically require it to be re written.
Do you think it would be best to be written in VFP, Access or some other
database format.
In the future we will be looking at web based things as well.
I am familiar with Access, and can find help on that easily. It is very hard
to get any help for Foxpro.
Thanks Tag: MonthView and GetDayBold Tag: 201545
updated help file VFP9 Beta
... was recently added to the VFP downloads page...
This download contains a refresh of the help file delivered with Visual
FoxPro 9.0 beta and includes updated documentation for the enhanced report
system features and more. Note: The contents in this new updated Help file
for the Visual FoxPro 9.0 public beta reflect a newer build of the beta and
not necessarily what is in the public beta, and does not contain what will
be complete in the final version of Visual FoxPro 9.0.
http://www.microsoft.com/downloads/details.aspx?familyid=40b7de2a-754b-4f89-bf30-8a1d20f08e8b&displaylang=en
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8 Tag: MonthView and GetDayBold Tag: 201538
VFP via OutlookXP send message
Dear. When I use internal dev system send out message via outlook XP, the
screen are prompted that "An application is trying to access the address
book. Do you want to do this". A progress bar follows and after it times out
the "ok" button is enabled. A combo box prompts users to "allow access for"
1-10 minutes. I am in a large corp and have many users. This causes much
confusion. Is their any way to disable the prompting. Please advice.
Thanks
Jackie Wong Tag: MonthView and GetDayBold Tag: 201528
Using VFP to process long lins of data & to create mailing labels
I need to process some very long lines of data, 1200 characters or
more, that contains company, address, city, state, and zip code data.
My goal is to extract these items and create mailing labels.
With shorter lines of data, 250 or less, I knew how to process this.
Using FP2.6 terminology, I would create a file with one field the
length of data, append the data as text, process this file record by
record, and generate fields for a second file.
I have done the same in VFP.
I know how to process the data on a line once I can get Foxpro to read
the line, for example processing character by character. My problem
right now is I don't know how to get the long lines of data to the
point I can use VFP to read the data character by character.
Can anyone offer suggestions as to how to do this?
Thanks, Tag: MonthView and GetDayBold Tag: 201517
Corruption in remote-views-only DBC. Possible?
Hi all,
I used to include remote-views-only dbc in my exe, but now, I decided to
exclude it.
Question: Is the corruption possibility is the same as dbc with data?
TIA,
Willianto Tag: MonthView and GetDayBold Tag: 201511
software test program
what is the best software test program for visual foxpro 6.0 ?
George Malekkos
Managing Director
__________________________________
www.powersoft.com.cy
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =--- Tag: MonthView and GetDayBold Tag: 201508
printer esc codes
Hi,
I am converting the following code from dbman to foxpro I thought i was
doing this right by using chr(27) for ESC but all it does is prints a box and
the codes and the printer does not use them :( The dbman program used a
command ESC() for this but is is not in foxpro.
old dbman code:
SET PRINT ON
****RESET
?? ESC("<27>E")
****MARGIN
?? ESC("<27>&a2L")
***LINE SPACING
?? ESC("<27>&l8D")
**SYMBOL SET ASCII
?? ESC("<27>(0U")
**SPACING FIXED
?? ESC("<27>(s0P")
**PITCH
?? ESC("<27>(s16.65H")
**Height
?? ESC("<27>(s14.25V")
**STYLE
?? ESC("<27>(s0S")
**Strke Weight
?? ESC("<27>(s0B")
new try at foxpro code:
SET PRINT ON
****RESET
?? CHR(27)+"E"
****MARGIN
?? CHR(27)+"&a2L"
***LINE SPACING
?? CHR(27)+ "&l8D"
**SYMBOL SET ASCII
?? CHR(27)+ "(0U"
**SPACING FIXED
?? CHR(27)+ "(s0P"
**PITCH
?? CHR(27)+ "(s16.65H"
**Height
?? CHR(27)+ "(s14.25V"
**STYLE
?? CHR(27)+ "(s0S"
**Strke Weight
?? CHR(27)+ "(s0B" Tag: MonthView and GetDayBold Tag: 201504
Drag and Drop
I have a container on the form and need to be able to drag it around to show
whats' underneath. I can't seem to get it to drop.
Dragmode is set to 'automatic' but I can't seem to figure out how to get the
position to change. What method fires?
Thanks Tag: MonthView and GetDayBold Tag: 201501
Eventhandler( ) - bind COM events to VFP object
Trying to use SQL Server sqldmo.dll object for some SQL Server management
functions.
However, cannot figure how to bind the sqldmo.dll events (specifically the
BackupSink interface). I've created the VFP class that implements this
interface, but when using eventhandler() to bind the COM object to the VFP
object, it always fails.
Any ideas? Tag: MonthView and GetDayBold Tag: 201488
Creating ADO connection views in Foxpro
I am trying to create a foxpro remote view to another database called K
(www.kx.com). I have the ODBC driver, works fine in Excel, ADO ect. But in
fox, I create view, connection works, it shows the tables, yet when I type
SQL i get "no results returned by server".
SO either:A how do I correct this
or
B: How/where do I create a raw ADO connection as a remote view? Tag: MonthView and GetDayBold Tag: 201486
frequent CDX corruption.
We have a new VFP8 application recently for a customer with a number
of (FP2X) tables in relations. One table used more often has its indexes
go bad frequently. We can fix it of course, but need to elimiate
the causes.
* Are there known VFP8 glitches that might be causing this?
* With VFP8 is there need to declare memory usage / percentage, etc.
in config.fpw like with old foxpro?.
-----------------------------------------------------------------
Paul Lee ........... Abri Technologies ......... http://abri.com/
'Recover' - top rated FoxPro file repair utility.
----------------------------------------------------------------- Tag: MonthView and GetDayBold Tag: 201477
BLANK APPEND REPLACE NOT WORKING
this is weid if i do this manually in the command window it works fine but
in a program it does not and does not error ugh
the code is
USE WATCH INDEX WATCH1,WATCH2 ALIAS FJ
SELECT FJ
APPEND BLANK
REPLACE FJ.TYPE_WATCH WITH YTYPE_WATCH, FJ.MAKE WITH YMAKE, FJ.INTRINSITY
WITH YINTRINSITY, FJ.VINTAGE WITH YVINTAGE, FJ.DESCRIPTIO WITH YDESCRIPTIO,
FJ.COST WITH YCOST, FJ.DPRICE WITH YDPRICE, FJ.RPRICE WITH YRPRICE,
FJ.DATE_INV WITH XDATE, FJ.STOCKNO_ WITH YSTOCKNO_
how do I figure what is wrong if i get no errors :( Tag: MonthView and GetDayBold Tag: 201476
File size problem
Symptoms: The .fpt size of the target dbf file gets larger and larger =
and finally exceeds the file size limit.
One dbf file is used as source. The data in one of its memo field is =
treated line by line and copied into the only memo field in the target =
dbf file. The copying method is "replace ... with ... additive".
The actual data size in the target dbf file is no more than 2Mb when =
"pack memo" is run. But while my prg file is treating data from the =
source file, the target dbf file gradually gets beyond 2Gb.
What is causing this problem?
Thank you.
Chuncan Feng
China Tag: MonthView and GetDayBold Tag: 201475
Diagnosing error 1104
We have a mix of W2K and XP workstations running FoxPro 2.5 DOS and several
VFP 7 SP1 apps. The data is on a NT4 SP6 server and the network is 100Base.
We have been getting error 1104 Error reading file. Today we had the error
on all 6 WS in the front office that are all connected to one switch and 4
out of 5 WS in the back office that are connected to another switch, the 5th
WS did not have a problem and was running one of the VFP apps.
How can we try and track this down?
The two network guys think it is an application issue and not a
network/connection issue. They also do not know how to diagnose the
network.
Thanks
Tom Tag: MonthView and GetDayBold Tag: 201474
Faxing
I've seen some posts regarding Faxing. I think it'd be a nice feature that
alot of people would use in our program. I have some questions on it
though. Do you have to go through the phone line, or can it go from the
internet to the fax? Do they have to have a Fax Modem? What is the easiest
way to implement this in FoxPro? Is there an activeX control, or can it be
done use API? Tag: MonthView and GetDayBold Tag: 201459
Problems with VFP8 application at runtime and ActiveX controls
Hi,
I have some strange problems with a VFP8 application who uses several
ActiveX controls (Graph, RTF, Treview)
While it works OK when started from VFP, when I start it from Explorer on
other PC's (which don't have VFP installed but only the runtime), when I try
to open a form who contains an activeX control mentioned above, I get the
following error "menu manager internal consistency error" and application
exits
Can anyone give any suggestions for the cause of this problem?
Thank you for all opinions and advices.
Best regards,
Bogdan Zamfir Tag: MonthView and GetDayBold Tag: 201458
2003 server
We have just installed our program on to a 2003 server.
When we try to run the program we get an error which reads
'resource file version mismatch'
The executable will not run following this message.
The foxuser.dbf is missing from the installed folder.
Has anyone come accross this before I have searched microsoft for the error
but did not find anything.
Thanks in advance
Dave Tag: MonthView and GetDayBold Tag: 201454
sys(1272,object) object hierarchy ?
Hi,
lobject = this
sys_=SYS(1272,lobject)
sys_=SUBSTR(sys_,1,AT(".",sys_,1)-1)
sys_.addobject("onderlijn","image")
Can somebody tell me why I get an error "sys_" is not an object
on the last line ?
I tried this &sys_..addobject("onderlijn","image")
but then I get "object is not found"
This code is used in a form.grid.column.textbox.mymethod.
All I want to do is add an imageobject under a certain
word in a textbox, that textbox can be everywhere (grid,container, form)
thanks in advance
regards
christophe Tag: MonthView and GetDayBold Tag: 201440
How to prevent automatic LostFocus of a textbox with InputMask?
Hi all,
This should be easy; I have a textbox with InputMask = "999,999.99".
Problem is my client doesn't like the behavior that automatically move
the focus to next control after he enters any number with two digits
decimal.
How can I fix this?
TIA,
Willianto Tag: MonthView and GetDayBold Tag: 201437
Text rotation in VFP report
Anyone know how to rotate a text in VFP report to 90 degree ?
or can it be done in VFP anyway.
can crystal report able to do that as well ?
I'm using VFP 6 SP5.
Thanks! Tag: MonthView and GetDayBold Tag: 201434
Database keys
Hello,
I am used to working with autonumber in access and sql server. However I
now have to deal with converting some older dbman code ot foxpro and I ran
acrossed this piece of code:
**********DENYRW %DATE/RECNO(%DATE)
STORE FJ.JEWELRY2 TO XK
REPLACE FJ.JEWELRY2 WITH XK+1
**********UNDENY %DATE/RECNO(%DATE)
Now he used this table called JEWELRY2 to get the current and store a number
+ 1
This program would be single user but I want to work on a multi user setup
what should I do for assigning autonumber keys in foxpro?
How do i handle the multi user enviroment with this?
Yes my future if going to SQL but one step at a time.
I Hope this is understandable i have been up for a long time now :) Tag: MonthView and GetDayBold Tag: 201429
formatted text
Hi
How would you handle this requirement?
1) Copywriters have hundreds of Word documents, one per product - that are
book abstracts with numerous pieces of information enclosed in pseudo markup
tags, such as <nticon>, <toc>, etc. Let's say for now they prefer to leave
these in Word, and that their odd tagging scheme is at least consistent.
2) They want each piece of data to be placed into discrete fields in a
Foxpro table so they can be output in an ad hoc order. They may take the
results and merge them into a custom Word doc, view them in a Crystal or R&R
report, etc.
3) There is already a program written to do this extraction, but it is not
currently pulling the formatting, i.e. bold, italic, etc.
4) The formatting needs are not sophisitcated. Only the basic formatting is
needed, no multiple fonts etc., mostly bold, italic, and bullets. In other
words, simple HTML is sufficient and while RTF works, it is overkill
Since my program in 3) already does everything except pull the formatting,
my thought is to find an HTML edit control like the RTF control that comes
with VFP, i.e. that could be bound to a memo field in a DBF and store the
formatted text.
I have had some success doing this with the RTF control, to the point of
auto-pasting the selections into the RTF control then sending the results to
memo fields. But there is a need to also output the formatted text to HTML,
and that control has no conversion method that I know of. I am aware that
Word can be automated to save a DOC as HTML, but the result is overly
complex and hard to parse.
What are some of the different ways you might habdle this in VFP?
thanks
wayne Tag: MonthView and GetDayBold Tag: 201411
Emailing formatted documents from VFP
For one of our custom apps, a lot of things are currently printed out
then faxed. We're planning on a fax server and email at everyone's
desk, so those documents will soon either get faxed via the fax server
or emailed.
If we want to preserve formatting for a VFP 6 report, how would y'all
recommend we handle that? I've printed to a PDF print driver and that
works great but I don't think there's a way to pass the print driver a
file name.
Thanks in advance for suggestions.
-S- Tag: MonthView and GetDayBold Tag: 201410
finding variables
Hi friends
Is there any way to find out where a particular variable is declared ?
we've no of public variables declared in our app and sometimes i find
difficult where it was declared .
Thanks
cheers
--
cheers Tag: MonthView and GetDayBold Tag: 201404
Any good article on Client/server programming?
I am moving my application to Client server environment (SQL 2000/VFP8.0).
Can anybody suggest any informative article on the web?
Thanks. Tag: MonthView and GetDayBold Tag: 201403
Image Control for VFP5
Im looking for an Image Control that will show GIF images in VFP 5. I cannot
upgrade to 6+
Thanks Tag: MonthView and GetDayBold Tag: 201402
Run VFP6.0 under WINE/Linux
When I search the license issues of VFP run under WINE, I find this
link : http://www.chetgardiner.com/consult/html/news.html
It states that :
...My recomendation to developers at this point would be to explore
the use of VFP6.0 with WINE/Linux since the EULA for VFP6.0 clearly
does NOT preclude the use of the VFP6.0 run-time files on non-Windows
systems and VFP6.0 is a stable, full-featured release...
Can anyone tell me that developing VFP6.0 application under Windows
and deploying to WINE/Linux using the VFP6.0 runtimes is 100% legal ?
Thanks Tag: MonthView and GetDayBold Tag: 201399
Timer hang clicking in Text/Edit box ! Please help !
Hi all,
I'm getting a strange error in VFP when using a timer control.
Every time I click and hold the button mouse in a text or edit box the timer
doesn't fire the timer event. This also occurs in an ActiveX that I made
with Delphi to use in VFP.
To the ActiveX to fire events I set the AutoYield to .f. but even change it
to .t. the Timer event isn't fired.
I've tried to call DOEVENTS command but doesn't work.
Is there a way to resolve this situation ?
TIA,
--
Andre Tag: MonthView and GetDayBold Tag: 201398
Getting data out of General fields
I have some data in General field which I need to feed to an ActiveX
component. Unfortunately, I have not been able to figure out how to get data
out of a general field -and into a variable (or something) that I can pass
into this component.
Anyone have any ideas?
--Thanks
Mike C. Tag: MonthView and GetDayBold Tag: 201391
serial number of hard disk
dear sir,
is there any command can i get the serial number of hard disk or processor
or motherboard or any hard ware
thanks
mohamed Tag: MonthView and GetDayBold Tag: 201389
enter or tab exit textbox
dear sir,
is there any property can i set to text box
that only enter or tab to exit the cursor from textbox and not able by
arrows keys
i use ' set confirm on ' but the cursor can exit from textbox by arrows keys
thanks
mohamed Tag: MonthView and GetDayBold Tag: 201388
Free MS online ASP.NET training and Free VB.NET
http://www.aspnetwebcasts.com/
--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
Quantum Mechanics: The dreams stuff are made of. Tag: MonthView and GetDayBold Tag: 201387
Development Environment
Is there a way that I can tell if I am running the program within FoxPro, or
if the program is developed into an EXE file and is on a customers computer?
I would like to set some things in code while I am developing it, but I
don't want it to run once it is built. I have so far just commented it out
before I build it but it has happened a couple of times where I forget to do
that. Tag: MonthView and GetDayBold Tag: 201384
putfile and getfile
Dear sirs
I`ve used the putfile and getfile functions to save and get tables in my
program
the problem is that it returns the full path of the file
I need only to use the file name only, not also its full path
how can I do that???
thanks
Mohammed Tag: MonthView and GetDayBold Tag: 201377
FPW2.6 Windows 2000 print preview font size
I'm having a problem with the font size in the print preview of FPW2.6 when
the machine uses Windows 2000: It's not detailed enough to read.
The machine in question has a desktop resolution of 800x600 and my report
uses Arial, 8pt. When I click to zoom in the print preview, there is not
enough detail to read the text clearly. If I change the resolution to
1024x768 the preview page appears with the same physical size (if I put a
tape measure to the screen) but the higher resolution allows the text to be
readable.
A win9x machine handles this "the other way around" - ie the rendered page
seems to be at a fixed bitmap size and the text is always readable, changing
the resolution just changes the physical size on screen.
I've made sure Foxfont and Foxprint are installed. No difference. I changed
the font DPI in the display control panel. No difference.
Any ideas?
I'd like to keep 800x600 res on this screen if possible.
--
TIA
Andrew Howell Tag: MonthView and GetDayBold Tag: 201371
datasession id's
Hi,
I'am developping an application for the LAN. All the datasessions are
private and the tables are used with exclusive OFF.
But, I fell into a situation where I needed a table exclusively to do some
replacing. Is/Are there (a) command(s) or function(s) that tells me if
another user has opend this table or if this table is opened in another
datasession?
TIA
Mark Tag: MonthView and GetDayBold Tag: 201363
VFP 6: Singlestepping
I am finding the weird stuff lately. Today's thrilling episode:
I am debugging a processing program. A couople of records are
giving odd results. I inserted
if inlist(recno(this.thiscode+"_cwkt"),6937,13622)
clear typeahead
=messagebox("setting step on")
set step on
endif
to start singlestepping at this point. In the details of the
processing, I decided that I need to browse a temporary table before
processing continues. For this, I added:
if set("step")="ON"
browse
endif
Imagine my surprise as singlestepping bypassed the if body.
Hacker's 6 explains that set("step") always returns "OFF". Insert
nasty thoughts here. I want to detect whether the program is being
debugged in singlestepping mode. I could set a variable just before I
turn singlestepping on, but now, I have to explicitly turn it off or I
will be seeing a browse for every record between 6937 and 13622. This
is, uh, less than optimal. Am I overlooking something simple?
Sincerely,
Gene Wirchenko
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices. Tag: MonthView and GetDayBold Tag: 201342
Using vfoledb with webservices?
Hi,
I'm a former vf programmer, nowadays a .net vb programmer.
I wonder whether I can use vf tables with the vfoledb provider to program
webservises in .net?
I've been reading this article
http://msdn.microsoft.com/library/?url=/library/en-us/dnfoxgen7/html/usingaspnetwithvfp7.asp
TIA
/Kenneth Tag: MonthView and GetDayBold Tag: 201340
VFP 8 runtime files
Hi,
what are all the files I have to copy with the application I am
distributing?
VFP6 used to have a wizzard to distribute all required files but it seems
VFP8 has nit such feature... is that right?
thanks
Oscar Taboada Tag: MonthView and GetDayBold Tag: 201338
weird table corrupt error on terminal server installs
Hi friends
I wonder if any one had faced this before.we have product developed in vfp8.
whats happening is in terminal server installation when user run our app
they are getting "Table corrupt" error and our app menu would not load and
user cant use our program.
whats weird is it does not happen everytime and happens randomly on
different terminal server machines.
we checked for table corruption ,checked indexes ,table headers etc., but
found no problem.
finally what we did was we just copied all files in app folder to a new
folder and when we ran app from new folder its working beautifully !!!
any ideas what could be happening here
(by the way when loading our app we lock a record in a table for each logged
in user. )
--
cheers Tag: MonthView and GetDayBold Tag: 201337
Internet application
VFP 80.
I am not new to VFP, but I know nothing about the internet. Can I adapt my
POS application for use on the internet? My customers would like to have
"real time" by using the internet to confirm product purchases at the store,
etc. Where do I learn about doing this?
--
TIA
Cowboy Tag: MonthView and GetDayBold Tag: 201329
I'm getting OLE error code 0x80020005 from GetDayBold in the MonthView
control.
Any tips on how to avoid this?