giving word document the print command from within foxpro
Hi,
from within my foxpro program i open a word doc, i put my data in it, and
then i want to print it, but without the print dialog. Because the word app
stays invisible all the time. I don't want the user to have to choose the
printer etc... because there are about 300 documents that need to be
printed, so they won't be happy if they have to click that OK button 300
times
allso, how can i make that every doc is printed more than one time?
Regards & thx in advance,
Thomas Tag: www.turkusokagi.com Tag: 178650
adding row to a table in word from within foxpro
Hi,
i'm automating a word-document, so i'm filling up the values from within a
foxpro-program. I have a table in the Word-document, and i want to add a row
at the bottom to that table. (How) Is that possible?
Regards,
Thomas Tag: www.turkusokagi.com Tag: 178649
Hooray IDE Changes!
They say it's the little things that matter most...
I can't imagine how many dozens of times I've been beeped at or had my
browse window close for trying to Ctrl+Home/End-ing to the top/bottom of the
table. These finally (VFP8) navigate the browse as they do in most other
apps, yeah! Tag: www.turkusokagi.com Tag: 178646
Launching a PDF from a VFP7.0 form
I am trying to launch a scanned reference document from a
Foxpro form button....? can that be done? Tag: www.turkusokagi.com Tag: 178642
Data Corruption
Hi There,
I hope someone can shed some light on this for me or at least point me in
thr right direction.
Out of about 100 clients, 10 of them are regurlary having problems with
their tables getting corrupted. They are all using our system over a
network and in most cases the server machine is being used as a workstation.
The strange thing about the corruption is that the dbf is still ok to be
opened through fox and can be browsed, but it is as though a section of
memory has been slotted into the middle of the table. No data is actually
being lost, just this bad data being added in; usually somewhere near the
middle. Sometimes we can read what the bad data is; one time it looked like
registry entries, the other it actually looked like some of our code!
Would incorrect shutdowns cause this, or scandisk.
If anyone has seen similar or has any ideas, please let me know.
Thanks in advance.
David Gouge Tag: www.turkusokagi.com Tag: 178627
Moving from VFP 5 to 6
Any things to watch out for if we take a project written in VFP 5.0 and
build and compile it in 6 instead? We've standardized on 6 for most
things but have a few projects that were never rolled out that were
written in 5.
Thanks in advance.
-S- Tag: www.turkusokagi.com Tag: 178618
Open dbf in Excel
Hi,
I sometimes open VFP6 files in Excel. However I've run into a problem.
I have one particular dbf that won't open. The message is that the file is
not in the format expected (that's not the exact wording).
I see nothing wrong with this dbf when I open and browse in VFP.
To further confuse the issue, I tried opening files using three copies of
Excel on three different computers. In all cases, it was Excel 2002.
One the second computer, I could not open ANY dbf files. On the third, I
had no problem opening any dbf's (but I did not have the one problem dbf to
try because I was at another location.)
All three pc's were running Win XP and, as previously mentioned, Excel
2002.
1. What could cause the problem with that one file and how can I fix it?
2. Is there some "addin" needed so that PC number two can open dbf's?
Thanks, Frank Tag: www.turkusokagi.com Tag: 178617
Windows 2003 issues
Is anyone aware of any compatibility issues between VFP6 and Windows 2003?
Does anyone know if they fixed the:
http://support.microsoft.com/default.aspx?scid=kb;en-us;299603
problem they said was "too big to fix" before they edited their "Q"
--
Thank you,
Louis Sorbera Tag: www.turkusokagi.com Tag: 178615
R.I., but only for values > 0?
Hi everyone,
We'd like to restrict record inserts/updates in a child table when the
foreign key field value is greater than zero, but only if the FK value
doesn't exist in the corresponding "parent" table.
In other words, this particular field value can be blank (or zero) in the
child table, but if it isn't it needs to be a value that exists in the
"parent" table. We don't want to have to ship the parent table with a zero
PK record to satisfy the R.I.
We have other R.I rules for this table and we're trying to make this type of
logic work. So far we haven't come up with anything that doesn't create
holes in the other defined R.I. rules.
Any suggestions?
Thanks.
--
William Fields
MCSD - Microsoft Visual FoxPro
MCP - Win2k Pro
US Bankruptcy Court
Phoenix, AZ
The secret to creativity is knowing how to hide your sources.
- Albert Einstein Tag: www.turkusokagi.com Tag: 178606
printing from web service
Hi,
I'm trying to print a report from my web service
I can't do it !?! why ??
do you know another way to print something from web service ??
thanks in advance
Pat Tag: www.turkusokagi.com Tag: 178603
VFP 8 Grid Q.
Is there a way in VFP 8 to tile an image as the background of a grid?
Thanks,
Jonathan Morningstar
----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Tag: www.turkusokagi.com Tag: 178601
Problems with code page
I have problems with the creates an SDF file. Fields
aren't delimited and have a lot of quotation marks in,
when creating SDF files with COPY TO. Tag: www.turkusokagi.com Tag: 178594
Fonts
Hello
I use VFP 5.0 and when I click Format, Font -> I have next scripts:
Western, Hebrew ... Vietnames.
What should I do , if I need to read Korean data ?
Thanks Tag: www.turkusokagi.com Tag: 178590
foxpro free tables
Is there a way to connect and join data from multiple
foxpro free tables with the same connection/command
object in ado.net Tag: www.turkusokagi.com Tag: 178586
popup menus
Is there a way to pass parameters to a menu in VFP 7?
--
Kendall R. Dixon
Information Systems
Tusculum College
Phone: 423/636-7300 ext.5750 Tag: www.turkusokagi.com Tag: 178579
Foxuser.dbf file cause application crash
I have this this problem on Win2000 only systems:
my application crashes very early at startup, I found it
doesn't crash if I:
- flag foxuser.* files as read-only
- delete foxuser.* files (but in this way it crashes next startup)
This never happened in the past and I can't find a reason.
At startup I SET RESOURCE OFF.
I changed nothing in my startup procedure.
--
Andrea Mariottini Tag: www.turkusokagi.com Tag: 178578
modify contents within a memo field
I have to change some contents within a memo field programmatically.
For example , the contents of a memo field are
Name = "lblV_partybuzlist_cAbbr"
Caption = "Abbr"
Left = 9
Top = 14
cfield = V_PARTYBUZLIST.CABBR
lgetcaption = .T.
Name = "lblV_partybuzlist_cAbbr"
I want to change the lgetcaption = .T. to .F. I have written some codes to
do it but I feel it is a bit clumsy.
Does everyone has any better ideas ?
the code I have written is as follows:
REPLACE apresent.properties WITH ;
SUBSTR(apresent.properties, 1, ATCC("lgetcaption = "),
apresent.properties) + 13) ;
+ ".F." + ;
SUBSTR(apresent.properties, ATCC("lgetcaption = "), apresent.properties)
+ 17)
Any comments are welcome.
Matthew Tag: www.turkusokagi.com Tag: 178572
Why VFP not popular in academic?
Is there any of you have heard VFP is uses for academic
purpose?
Recently I plan to continue my studies but as far as I
seen all the academic test don’t use VFP as their test or
even worse I never heard VFP is one of common language
uses in academic purpose.
Frankly I try to apply at academic with the student get
their financial aid, but it don't use VFP as their
evaluation process test, I am very disappointed.
Does any of you know where VFP is uses for academic
evaluation process test, I would very happy to heard that.
no VFP in evaluation process test, ie:
http://www.mum.edu/compro/index.html Tag: www.turkusokagi.com Tag: 178570
MSDN download of Visual Foxpro 6.0
Sorry if I missed this one in the faqs.
I just received my MSDN subscription and it includes VFP
8.0. Most of my development is in 6.0 How can I
download the install CD-ROM's for 6.0?
...JS Tag: www.turkusokagi.com Tag: 178553
Index corruption
Hello Group,
I wonder if there is a way to detect index corruption at run time. I want to
detect corruption when my app is lunched so I can fix it and avoid
subsequent troubles and error messages presented to the user.
I appreciate any help in the subject.
TIA
Carlos Jones Tag: www.turkusokagi.com Tag: 178544
GETFILE() position
I use getfile() in a small app. When running directly in VFP8, it works
fine. I compile the EXE and the open dialog box from getfile() is shown
off screen. I have to right-click the task icon and select move to get it
to show. I have SCEEN=OFF in my config.fpw. Does that matter? Tag: www.turkusokagi.com Tag: 178542
ODBC REPORD LOCKING EXAMPLE
*!* This program is example of using ODBC to update tables and uses
timestamp to take care of record lock when updating and
*!* inserting. It uses set prop to make sure tables can be reverted
in case of error. It is very important to have .001 time
*!* delay in inserting and updating records because FoxPro does not
give time in thousand of a second. In putting .001 it
*!* makes sure that you get all unique records.
*****************************************************************************************************************************
*!* Make table with four fields Date --- date() *
*!* Sec --- 10,5 numeric use SECOUND() function *
*!* Name --- Character 10 *
*!* Lname--- Character 10 *
*********************************************************************************************
clear
ERROR1 =.f.
UPDATELOCK = 0
set safety off
sqldis(0)
connection = sqlconnect('VfpTables'," "," ")
?connection
nprop= SqlSetpro(connection,"transactions",2)
if nprop = 1
for i= 1 to 100
wait window('wait..') timeout .001 && important delay for time stamp
wait window("Updating Tabel " + str(i)) nowait
Query1 ="Select * from datetime "
NRESULT = SQLEXEC(connection,Query1,'temp')
if NRESULT !=1
=aerror(x)
=messagebox(x(2)+ chr(13)+Query1)
=SQLDISCONNECT(connection)
ERROR1 = .t.
endif
select * from temp into table counter
use in counter
do while UPDATELOCK = 0 && to make sure record is not changed
Query1 = "Select *,"+str(second(),10,4)+" AS NEW_TIME,"+; && update
current time to timestamp in temp table
str(i)+" AS CREATSTAMP"+; && this line is not needed
" From counter "+;
" WHERE counter.lastname = 'KHAN'"
NRESULT = SQLEXEC(connection,Query1,'temp')
if NRESULT !=1
=aerror(x)
=messagebox(x(2)+ chr(13)+Query1)
=SQLDISCONNECT(connection)
ERROR1 = .t.
endif
Query1= "update datetime set name ='AAA',Sec
="+str(temp.New_Time,10,4)+" where LastName ='KHAN'"&& update real
table with temp timestamp
NRESULT= SQLEXEC(connection,Query1)
if NRESULT != 1
=aerror(x)
ERROR1 = .t.
=messagebox(x(2)+ chr(13)+Query1)
wait window " Insert failed."
ERROR1= .t.
endif
Query1 = " select * from datetime "+;
" WHERE Lastname= '"+alltrim(temp.Lastname)+"' AND Sec
="+str(temp.New_Time,10,4)&& if time in real table =time in temp table
you can update
NRESULT = SQLEXEC(connection,Query1,'Temp1')
if NRESULT != 1
=aerror(x)
ERROR1 = .t.
=messagebox(x(2)+ chr(13)+Query1)
wait window " Query failed."
ERROR1= .t.
else
if reccount()> 0 && as long as record is zero you keep trying to
update.
UPDATELOCK =1&& as soon as u get record which means you have
unique timestamp and u get out of the loop
endif
endif
enddo
if ERROR1 = .t.
=sqlrollback(connection)
ERROR1 = .f.
messagebox ('Some Error Happened Nothing Saved',32,'Error')
exit
else
=sqlcommit(connection)
endif
endfor
wait clear
else
messagebox('Set ProP Error ',32,'Error')
endif Tag: www.turkusokagi.com Tag: 178528
Problems with MP3 file played by MCI object
Hi,
I have a sound problem using MCI object to play a MP3 file... The problem is
the sound is not clean... I hear some "plock" in the background of the
sound. Anyone know this problem ?
Thank for ur help !!!
Mike Tag: www.turkusokagi.com Tag: 178521
Changing the class of an object
If I want to change the class of objects in a .vcx, do I
open the .vcx as a table and just replace the class type
as long as the base classes match and recomplie the code?
What other steps are needed, if any? Thanks. Tag: www.turkusokagi.com Tag: 178504
RUN Function misbehavior in VFP8
DIR Function behaves differently in VFoxPro 8: instead of
simply returning a list of the files in a directory (each
on a line) it returns the names of the files disposed in
a two-column format, except for those files with long
names, which occupy a whole line.
Since each line may contain the name of more than one
file, the function became useless as a way to verify
contents of a directory.
I have not found a way to make DIR behave as it used to
behave (a single file name on each line), is there a way? Tag: www.turkusokagi.com Tag: 178492
SQL server developers' edition
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01C35907.40E61710
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Looks like the price of the SQL server developer edition has been =
slashed to $49 from $499
Does anyone know this version has got any limit on the evaluation period =
? EULA does not say anything about it.
sp
------=_NextPart_000_0016_01C35907.40E61710
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 6.00.2800.1170" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Looks like the price of the SQL server =
developer=20
edition has been slashed to $49 from $499</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Does anyone know this version has got =
any limit on=20
the evaluation period ? EULA does not say anything about =
it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML>
------=_NextPart_000_0016_01C35907.40E61710-- Tag: www.turkusokagi.com Tag: 178487
VFP 8 ( SETALL AND BindEvents)
Hi all,
I would like bind all the events keypress() of several textbox of a page
(pageframe) to thisform.mymethode.
How can i do it ?
Thanks in advance
bernhart Tag: www.turkusokagi.com Tag: 178483
Scrollbars don't show on my Form.
Why doesn't my scrollbars show on my form (VFP 8)?
Below is an example of code where I have a grid larger than the width
and height of my form, but the scrollbars do not show on my form!
What am I missing here? THX - Mike Farnesi
MYFORM=CREATEOBJECT('FORM')
WITH MYFORM
.SCROLLBARS=2
.ADDOBJECT('MYGRID','GRID')
WITH .MYGRID
.TOP=0
.LEFT=0
.WIDTH=2000
.HEIGHT=2000
.VISIBLE=.T.
ENDWITH
.SHOW
ENDWITH Tag: www.turkusokagi.com Tag: 178467
indexseek() and buffering
does buffering mode (buffering mode 5, optimistic table
buffering) affect indexseek()? I am adding many records
to a table and then at end do a tableupdate() to update
all the added records. During the process I am using
indexseek to make sure I am not adding duplicate records?
Another programmer keeps saying that indexseek() will not
be able to find the newly added records with buffering
on. I did a small test and it seems to work for me.
Anybody with experience with this? Tag: www.turkusokagi.com Tag: 178466
How to detect that window has changed
I use FPW2.6a, and I have a screen with 2 browse windows A and B. Then I
issue a READ CYCLE with A,B DEACTIVATE .T. VALID .F.
I would like to trap when the user clicks with the mouse from one browse
window to the other. I have tried to put code into the deactivate routine,
but no result. Any good idea what to do? Tag: www.turkusokagi.com Tag: 178465
browse window with different fonts
I still use FPW 2.6a, and I would like to create a browse window that
contains different fonts or styles in certain columns or rows. Is that
possible? Tag: www.turkusokagi.com Tag: 178445
still get fatal errors
any news about this problem ?
--
George Malekkos
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/7/2003
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =----- Tag: www.turkusokagi.com Tag: 178444
memory leak in vfp6.0?
Chect the following source code - is this a memory leak?
*****************************************************************
close tables all
For i = 1 to 10
Begin transaction
use items
sele items
use
End trans
Messagebox(sys(1011) + ' ' + sys(1016))
Next i
***************************
items is a table belonging to a database - you can use any table
the values of sys(1011) and sys(1016) (number of memory handles in use and
amount of memory being used by objects) both increase throughout the loop.
The same behavior is observed if End Transactions is replaced with a
Rollback. Note that the rate of increase is proportional to the number of
index tags the table has in its corresponding cdx file. The number of fields
and the number of records of the table are irrelevant.
Issuing comands like close all, clear all, clear memory, etc does NOT reduce
the values returned by the two system functions mentioned above.
If the begin / end transactions are removed from the source this behavior
dissappears.
I am using VFP6 / SP5. This behavior appears in both Win 2000 and Win 98
--
George Malekkos
http://www.powersoft.com.cy
eXPerience the POWER of real SOFTware
-------------------------------------------------------------------
Powersoft Computer Solutions Ltd
PO Box 27075
1641 Nicosia
Cyprus
Tel 357-22.67.00.67 Fax 357-22.67.77.22
-------------------------------------------------------------------
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 24/7/2003
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =----- Tag: www.turkusokagi.com Tag: 178443
Prompt for code page = NO programmatically
In my development environment (VFP 6), I can
Tools
Options
Prompt for code page && and uncheck it
How to do I do this under program control?
TIA.
-S- Tag: www.turkusokagi.com Tag: 178441
To add a column in the grid window!
Hi All,
I've been trying to add a column in the grid window. I
right click the grid window and choose "Help Design
Tools", then an error message jumped out:
"Error #1742 at Resetcolumns(0): The source of
object must be a reference of variable."
What does it mean? Or any different ways to do that? Many
thanks.
Sam. Tag: www.turkusokagi.com Tag: 178434
Error in accessing VFP webservice
I have created a webservice in VFP 7 (DLL Created in VFP 7 and WSDL
generated using SOAP Tool kit 3). When I try to access it from a VB client
using SOAP 3, some times I get the following error.
-2147221504 - WSDLOperation:Instantiating the dispatch object for method
<MyMethodName> failed
As this error does not occur always I do not have a clue on how to fix it.
Any ideas?
Best Regards,
Y. SIvaram Tag: www.turkusokagi.com Tag: 178426
date question
Hi all,
I need a date string containing the 1st day of the current
month.
IE:
? lcDate
07/01/03
or the a date string containing the last day of the
previous month.
? lcDate
06/30/03
Your input is appreciated. Thanks. Tag: www.turkusokagi.com Tag: 178413
Listbox Not displaying Util it is Clicked
Hope this is something simple. In VFP 8 I have two identical
listboxes on a form. Both using their own seperate view data, both
bound the same way to different views:
BoundTo = T
BoundColumn = 2
ColumnCount = 1
Row Source = v_view.field1, field2
Row Source Type = Alias
Both views has data in them. One of the list boxes diplays the value
and one does not until you click on it at run time - then it refreshes
with the correct data. I have tried refreshing no no avail. What
would cause such an odd behavior.
Rick Tag: www.turkusokagi.com Tag: 178405
DBC Connection to SQL data??
I have already created an connection object with my DBC that I use with
remote views into SQL. If I want to query a table in the SQL server, can I
use the connection object I have already created?
I tried:
sqlconnect('mydsn','myusername','mydbcconnectionobject') but it doesn't
work.
I'm trying to limit the number of times I have to put the username and
password in code.
TIA
-Bruce Tag: www.turkusokagi.com Tag: 178404
Creating web-based apps with VFP8 vs Starting with .NET solution
Hi all,
I talked to a prospect yesterday. He has a plastic bag manufacturer and he
wanted to create apps to maintain the data in his manufacturing company. He
said that there were already three software companies that gave a proposal
to him. I will be the forth. All three companies are offering a web-based
applications, thus he insist that mine should be web-based also. Problem is,
although I've been using VFP for almost four years by now, I have never
touched a web-based application. For more information: two companies (out of
three) offered a Linux based solution (I think they'll use php), and the
other offered a .net based solution (vb.net for sure!).
Question:
1. Anybody got any idea what my selling point should be when I meet him on
next the Tuesday?
2. How steep is the learning curve to create a web-based applications with
VFP? I'm willing to invest in 3rd party product like WWC if I have to. Any
other alternatives?
3. I was planning to buy VS.NET --- not in a near future actually, but if I
can get this project, I might decide to buy it sooner. Will it do any help
if I develop the apps with VFP ( I have VFP8 )?
4. Considering that I am used to code in VFP, I assumed that it would be
much easier for me to create the apps in VFP rather than starting from
scratch with VS.NET. What makes me doubt is I read several pages of VB.NET
book in our local bookstore this afternoon, and it looks like that VB.NET is
designed to create a web-based application from the beginning. The book
started with creating a hello world web-based apps. Anybody here ever learn
VB.NET with VFP background? Do you have any suggestion?
TIA,
Willianto Tag: www.turkusokagi.com Tag: 178390
New msdn.microsoft.com/vfoxpro website layout
Surf on over to http://msdn.microsoft.com/vfoxpro/ and have a look at the
new Visual FoxPro website.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org, www.cindywinegarden.com Tag: www.turkusokagi.com Tag: 178387
Mixed colors in grid
Hi!
I have a grid with 24 columns. The value in each column can be ether -1, 0
or a number greater then 0.
In any given row I want the background color to be white for -1, green for 0
and red for the everthing greater than 0.
Everthing I've tried so far will ether make the entire row or the entire
column one of the colors depending on which row I'm in.
I need to have mixed colors in the same row and they need to be retained in
that row when I go to the next row.
Can anyone help me with this?
Thanks Terry Tag: www.turkusokagi.com Tag: 178382
Refreshing tables in the DE
vfp 6.0
Form with private data session and tables in the DE
Hello
After user click save button the files are updated and
fields in window are cleared. How do I refresh the tables
in the data environment so that they are up to date? The
only way I can think of ensuring the tables are current is
by closing the form and opening it again.
How do I refresh all the tables in the data environment of
a form with the current disk values? Do I have close and
reload all the tables? I hope not.
Thanks for your advice
Al Tag: www.turkusokagi.com Tag: 178380
Old menus
I think I've just discovered that VFP 8 has real trouble when dealing with "old" menus, to the point of C0000005'ing. After I went through and opened all the old menus, allowing VFP to "Convert to new menu format," things were ok. Likely a causal relationship. Anybody else notice this?
Eric Tag: www.turkusokagi.com Tag: 178375
Grid columns
I have a grid with 8 columns created in the Visual Class
Designer.
I'm reassigning the ColumnOrder and nothing is happening.
I put a message in the 'Init' of the grid to make sure
that I'm editing the correct item in the class. The
message came up but the column order stayed the same.
What am I missing as the possible problem?
Thanks,
Chip Tag: www.turkusokagi.com Tag: 178369
Report remembers printer
I developed an application with reports. The problem is,
that some of the reports come out of the printer (network
printer)I used at development time. It should be printed
by the Standard printer of the User. Other reports of the
application work as expected. What did I wrong.
TIA
Michal Tag: www.turkusokagi.com Tag: 178365
call refresh method on page frame??
Is there a way to programmtically call the refresh method
of each page of a page frame?
What I don't want to do:
this.page1.refresh
this.page2.refresh
this.page3.refresh
...
Besides, I might want to add pages and I don't want to
have to worry about the code.
TIA
-Bruce Tag: www.turkusokagi.com Tag: 178339