Copying Files
Hi Everyone!
I am trying to copy a shortcut file from a directory on
my network to the desktop of a users computer. The problem
I am having is that under Windows 2000 a users desktop
directory is under the directory Documents and Settings.
When I try to get FoxPro to copy to c:\documents and
settings\kevin\desktop\ I keep getting invalid directory
or path errors. Anyone have any ideas on how to copy to
this directory? Also I can't string a path name together.
Example :
k = kevin
path = 'c:\documents and settings\'+'k'+'\desktop\
copy file k:\test\sbtest.lnk to path - This will not work
eithier
Thanks Tag: claint-server example Tag: 180787
macro substitution
I have the followig code in a routine, which i neeed it to
refresh data in different forms, having objFormName= to
the form name.
&objFormName..GridSignOff.RecordSource='rv_view_singOffList
VirtualSql'
&objFormName..GridSignOff.Refresh()
Everithing works well, but when I compile the application,
I get a message stating the the form name contained in the
variable objFormName is not an object.
What i am doing wrong here?
Can anybody help before i perform a "MACRO SUBSTITUTION"
to my monitor?! Tag: claint-server example Tag: 180780
UNC problem
I have an application that is located on a server LIVE in a directory MYAPP.
All of the users will login and map the S: drive to \\LIVE\MYAPP. All of
the application files and subdirectories are under this main directory. The
application DOES NOT use any UNC paths to find files. The application will
always look under the S: drive for files and directories.
I wanted to create a test login for this application. I copied the entire
application along with the data files to another share (TESTAPP) on the LIVE
server. The test login will map the S: drive to \\LIVE\TESTAPP.
When the test login is initializing variables, it looks for a "Variable
save" (.mem) file to load the variables and values. This .mem file DOES not
exist on the test environment, but does exists on the live application. So
stepping through the application on the test login, the application set a
variable equal to the mem file name. gf_memfile =
"S:\MEMFILE\AMEMFILE.MEM". The application then tries to verify the file
exists with the FILE() command. It returns .t. even though the file does
not exist! The value of gf_memfile remains equal to
"S:\MEMFILE\AMEMFILE.MEM". The next statement is a RESTORE FROM command
that executes without an error. The gf_memfile variable gets changed to
\\LIVE\MYAPP\MEMFILE\AMEMFILE.MEM!!!! Why is that? Where does it get the
UNC from?
I don't believe this is a Foxpro problem, but rather an OS problem, but I
can't be sure. Any ideas?
<snip>
.....
gf_adrive = 'S:\'
gf_memfile = gf_adrive+ "MEMFILE\AMEMFILE.MEM"
IF FILE(gf_memfile) && does not exist, but this returns true
RESTORE FROM (gf_memfile) && this statement changes the gf_memfile
&& to a UNC pointing to the live application!
ENDIF
.....
</snip>
HELP!!! Tag: claint-server example Tag: 180776
VFP to VB6
Hi
I'd a software written in Visual Foxpro 6 and now in the process of
converting the source codes into VB 6. I made use of lots of subclassed
controls in my software, like embedding a Checkbox, Command Button, Image or
Combo Box into some columns of a Data Grid. Is there a way to realize these
functions in VB 6 without buying other 3rd-party OCX controls ? Thanks a lot
in advance. Tag: claint-server example Tag: 180771
Data Navigation
Hi
I have been a Visual Foxpro programmer for a few years and now looking
for a way to convert those VFP written system into VB6. I have some degree
of knowledge in ADO as I did write some Web-based database applications in
ASP using ADO as a data access interface. I faced some difficulties in
designing a Data Navigation Interface in VB6 coz I can't directly retrieve
and bind a million of records into data-bound controls. In VFP 6, I simply
used the following syntax to open a table and then directly set the
RECORDSOURCE of control to the STUDENT will do, need not bother too much
about the criteria in the retrieval of records. A simple Data Navigation
Interface with searching features is then easily created in VFP.
USE STUDENT IN 0 INDEX STUDENT SHARED
In VB6, I need to think of lots of data retrieval criteria. If I used the
following ADO syntax to retrieve the STUDENT
data will take me 10 minutes for the whole process and might cause system
hanging as well.
SET rsA = cnA.Execute "SELECT * FROM STUDENT"
In such scenario, the data is then broken down into smaller parts by putting
a WHERE clause as below.
SET rsA = cnA.Execute "SELECT * FROM STUDENT WHERE YEAR_ENROL = 2000"
The Data Navigation Interface will only have the recordset of those students
enrolled in the year of 2000. What if I want to search for a student by name
"LESLIE WILSON" who actually enrolled in 2001? Of course, the rsA.Find
syntax is not applicable in locating this student. In this case, I shall use
rsA.open "SELECT * FROM PATIENT WHERE NAME = 'LESLIE WILSON'"
However, by using this syntax, the Data Navigation Interface will then only
have this student record. I found this is not a nice method. In VFP 6, I
don't need to bother so much by using SEEK. What's the proper way of
handling this issue in VB using ADO ?
Thanks a lot. Tag: claint-server example Tag: 180770
cursor shape in vfp6
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. Thanks
Pushpak.
. Tag: claint-server example Tag: 180753
Error 1104 on zipfile, pls kindly help
Hi,
My application just only unzip some file and post them to my database file.
However, it might after a day, will give error of 1104, Error reading file
when
going to unzip the zip file.
Normally, before unzipping the file, I will tried to test whether the zip
file is
still posting half way by my client by fopen it to ensure that is is okay to
open it exclusive first. After that, I use Dynazip to test it integrity
before
unzipping the file, but error 1104 still happen to my application.
I am using VPF5a with Dynazip v4 running on Win98/95 with my zip file on
my NT server share folder.
Any possible cause of why this problem is happening ? I am at a loss. Tag: claint-server example Tag: 180750
Reports produce different results every time
I have a client with a very large database. Some of the tables has about
half a million or more records in them. When I run a report using any of
tables, I get different results on every workstation. It is also different
on the same workstation if I run it multiple times. If I run it on the
server, it is fine. Write caching has been turned off on all workstations.
The server runs Windows NT 2000 and all the workstations have different
versions of windows on them. Is there any other type of caching that needs
to be turned off or has anyone else experienced this problem ?
TIA
Sujata Tag: claint-server example Tag: 180747
XML to single or multiple cursor(s)
I have a project where I have to link our application to QuickBooks for
updating records in either application or inserting transactions in to QB.
US version of QB SDK had a foundation class and XML options and I used FC,
which had simplified my task but Australian version only supports XML.
I need to be able to create single and/or multiple cursors depending on the
XML dataset so that I can manipulate data easily in my application.
I experimented with the response xml file and find out if I only have 1
level of tags XMLTOCURSOR nicely creates a cursor that corresponds to the
xml structure except the variable types (eg. a datetime field was created as
a character field).
Eg. A response xml file from QB
<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<TaxCodeQueryRs requestID="1" statusCode="0" statusSeverity="Info"
statusMessage="Status OK">
<TaxCodeRet>
<ListID>20000-1046324474</ListID>
<TimeCreated>2003-02-27T16:41:14+10:00</TimeCreated>
<TimeModified>2003-02-27T16:44:08+10:00</TimeModified>
<EditSequence>1046324648</EditSequence>
<Name>CAF</Name>
<IsActive>true</IsActive>
<Desc>Cap. Acq. - GST Free</Desc>
<Tax1Rate>0.00000</Tax1Rate>
<Tax2Rate>0.00000</Tax2Rate>
<IsTax1Exempt>false</IsTax1Exempt>
<IsTax2Exempt>false</IsTax2Exempt>
<IsPiggybackRate>false</IsPiggybackRate>
<IsECVatCode>false</IsECVatCode>
<TaxType>5</TaxType>
</TaxCodeRet>
<TaxCodeRet>
<ListID>D0000-1046324474</ListID>
<TimeCreated>2003-02-27T16:41:14+10:00</TimeCreated>
<TimeModified>2003-02-27T16:44:08+10:00</TimeModified>
<EditSequence>1046324648</EditSequence>
<Name>NCI</Name>
<IsActive>true</IsActive>
<Desc>Non-Cap. Acq. - for making Input Taxed Supplies</Desc>
<Tax1Rate>0.00000</Tax1Rate>
<Tax2Rate>0.00000</Tax2Rate>
<IsTax1Exempt>false</IsTax1Exempt>
<IsTax2Exempt>false</IsTax2Exempt>
<IsPiggybackRate>false</IsPiggybackRate>
<IsECVatCode>false</IsECVatCode>
<TaxType>3</TaxType>
</TaxCodeRet>
</TaxCodeQueryRs>
</QBXMLMsgsRs>
</QBXML
If I use XMLTOCURSOR function without any modification I will get either one
field or as many as the number of requests in the returned XML file (I can
send multiple queries to QB in one XML message and therefore get a multiple
response in one XML returned message) with
everything squashed in with out their tags.
Now if I remove <QBXMLMsgsRs> and <TaxCodeQueryRs .....> lines and also
corresponding end tag lines then use XMLTOCURSOR function it will give me a
cursor with field names and properties as
ListID (char 16),
TimeCreated (char 25), }these two is datetime field in the original
XML response file
TimeModified (char 25), }
EditSequence (num 10),
Name (char 3),
IsActive (logical),
Desc (char 47),
Tax1Rate (num 8),
Tax2Rate (num 7),
IsTax1Exempt (logical),
IsTax2Exempt (logical),
IsPiggybackRate (logical),
IsECVatCode (logical),
TaxType (num 1)
I can then work with this table to get what I want.
This is fine if I only deal with one request/response, but majority of
response(s) have more complex structure.
Is there a better way to deal with response XML files?
I saw in VFP8 new features that there is XMLAdaptor class that can accept
internal or external schemas and create single or multiple cursors but we
have some stability issues running our application in VFP 8 and therefore
not ready yet to go up to VFP8. I need to find a solution within VFP7
capabilities.
Cheers
Mehmet Tag: claint-server example Tag: 180736
VFP 7 How to change command button text color
How do you change the text color of a command button
programatically? I've tried to change the forecolor
property, but that doesn't work.
Thanks,
Cliff Tag: claint-server example Tag: 180733
_screen function
Hi guys,
I have create an object to display it as my background
using the _screen.createobject command line.
I had went through the help file but nothing in there
tell me how to create the screen such that it will
maximise to fill up all the white space.
I can drag the size to fill the screen size but my
concern is that if this were to implment to many
customer, this might not look good since chances are they
does have the same screen setting as mine.
Mine is 1024 X 768 pixel
Thanks a lot
Best Regards
Edwin Chua Tag: claint-server example Tag: 180729
resizable frames within a form
Hi,
I need to create 3 or 4 frames(windows/sections/divisions) within a form
that the user can adjust in an easy way. think about the 2 or three frames
we usually have in Outlook or Outlook Express... the user just drag the
frame borders with the mouse and the other frames ar also automatically
adjusted
right now the only way I have found to solve this is using one Formset with
several forms and puting some code in the resize event of the forms to
adjust the others, however there is a problem:
the only visual container of the forms is _screen, it seems there is no
way to put the forms inside a single form object that contains them so I can
instantiate the same form with it´s internal adjustable frames and allow
the user to look at them as many software allows: Mosaic or Cascade
I know this should be possible becaus e I have seen an application developed
this way (I guess in Microsoft C++), but I am not sure what controls are
they using
I would appreciate any advice or if somebody knows where can I download a
similar sample from the net
Thanks and Best regards Tag: claint-server example Tag: 180722
SQL server connection
Hello everyone.... how will i know if my sql connection
which i made from the start of the program is still active.
i need this to avoid errors that the said connection isn't
active anymore.
tnx a lot. Tag: claint-server example Tag: 180692
Are there any drawbacks if I use a lot of connection to SQL Server (and not sharing them)?
Hi all,
Most of the connections I used in my apps are occupied by one SQL query
(VFP's remote view). However, in a case where I need atomic transaction, I
would share a connection and perform table insertion/update inside SQL's
BEGIN TRANSACTION and SQLCOMMIT pair.
Question:
Are there any drawbacks if I use a lot of connection to SQL Server (and not
sharing them)? Overriding the connection handle in VFP's remote views
require coding in the form's Init event. If the drawbacks are acceptable,
I'd rather bind the RVs in the DE than open it programmatically one by one.
Please note that what I mean a lot is about 10 to 25 connection (remote
view) in each form.
TIA,
Willianto Tag: claint-server example Tag: 180689
General Question about hWnd
Hello -
is it possible to pass the hWnd to an activeX control for standard VFP objects?
I can't seem to do it. In other words...... thisform.cmdButton.hWnd
or thisform.lblBase1.hWnd
Thanks.
Mike Tag: claint-server example Tag: 180684
launch explore from command line
Hello again all
I am converting reports to HTML and I know I can launch
internet explorer from an icon on a screen but is there a
way to launch it from the command line after the report
has been created? Hope this makes since.
Glen Tag: claint-server example Tag: 180672
SQL error: GROUP clause missing or invalid
This SQL statement which works fine in VFP7 generates a
SQL error: GROUP clause missing or invalid when run in
VFP8
SELECT Astu.status, Acls.classlink, amst.sectionid, ;
count(*), amst.meetperiod ;
FROM astu INNER JOIN acls ON Astu.stulink =
Acls.stulink;
INNER JOIN amst ON Acls.classlink =
Amst.classlink;
WHERE astu.status=' ' ;
GROUP BY amst.sectionid ;
INTO TABLE temp
(Note: This is just a subset of the full SQL statement.
Neither the full one, nor this one, work in VFP8)
What do I need to change to make it work in VFP8?
Thanks. Tag: claint-server example Tag: 180659
VFP6 data type mismatch on selecting table
an VFP6 application that has been running for a number of
years, quite happily, which I am now doing further
development on has suddenly started to come up with the
error "data type mismatch" when I try to select a cursor
that I am scanning through - either within the scan or at
the endscan stage. I suspend the program then immediately
click resume and it selects the cursor and carries on
quite happily - right through to the end of the scan.
I can't see any fields that could be suspect, they are all
character and just a simple select with no function
calls. It happily starts the scan.
This is totally doing my head in. I had a sircam.worm
infection a couple of weeks ago which I sorted out with
Norton's help and the problems seem to have been going on
since soon after that.
Anybody come across/sorted out this problem? Tag: claint-server example Tag: 180651
Creating User-Defined functions in Crystal Reports 8.5 or 9 via VFP 7 Automation Server
I have Craig Bernston's book CrysDev and have downloaded several PDF's from
Crystal Decisions and must be missing something. This appears to be a pretty
simple process as described by both sources. However, I have built by VFP
automation server, registered it, verified naming conventions and that
Crystal has my DLL in use when in the designer, but my functions simply are
appearing in the Crystal additional functions list. The behavior is the
same for both Crystal versions 8.5 and 9 using VFP version 7.
Any tips or suggestions would be appreciated.
Thanks,
Rory Sawtelle Tag: claint-server example Tag: 180645
Softwarekey, Protection Plus, FPW2.6
I need to supply an old FPW2.6 application but add software protection. I
have got Protection Plus from Software Key, and am having difficulty getting
it to work using the KEYFOXW.FLL.
I know it's old stuff but is there anybody who can guide me through the
process of providing a 30-day demo which can then be unlocked to full
version?
Many thanks
Stephen Ibbs Tag: claint-server example Tag: 180639
VFP7 Multi-user View problems
We are using some views in our system for combining files
for using in a grid. When 2 users are inputting data on
these forms, each user cannot see the other user's added
records until they exit the screen and come back in.
Is there a way of forcing the view to refresh from the
server data? I don't really want to close it and reopen it
as this may slow things down.
Bernie Tag: claint-server example Tag: 180638
Active SQL Connection
Hi. Is there a way to determine if a connection to an SQL
server is still active? Im using VFP 8.0 and MS SQL
Server 7.0.
Tnx!!! Tag: claint-server example Tag: 180636
Slow down on XP SP1
Help
i just install my application built by vfp7.0&vfp8.0
without any modification on win xp sp1, it runs extremely
slow on connecting mysql database remotely or locally use
odbc, but the program works fine on 98se, me, w2k, w2k
server, xp without sp1, so i try to reinstall the win xp
sp1 again without norton anti-virus software, and upgrade
any service pack for xp, but still happen, i am using
remote-view to connect mysql database, i discover, when
the program is connecting database, the program will hang
up for a long time, and occupy 100% CPU Usage, i have no
idea about this problem.
thks Tag: claint-server example Tag: 180627
Setup Wizard for exe files.
I have been using the setup wizard in VFP6 to make up the installation
CD to install applications. I see there is a better one out and wonder
if I need to upgrade the VFP6 or can I obtain this newer wizard to
make up the setup files?? I sure do like the ease at which VFP6 lets
me make them up but is there something out there that I can use that
is better?
Tony Tag: claint-server example Tag: 180593
Create Table - SQL
This is a multi-part message in MIME format.
------=_NextPart_000_0008_01C372FB.7C8059D0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
VFP8/XP:
I am creating a Binary Memo field in a table/DBF.
When using "Create Table ..." SQL statement, there is no option to =
distinguish a "Memo" field and a "Memo-Binary" field.
Is VFP going to treat the momo field (which I create with the field type =
"M") as "Memo-Binary" type based on the information I am going to store =
in that field or what?!
sp
------=_NextPart_000_0008_01C372FB.7C8059D0
Content-Type: text/html;
charset="iso-8859-1"
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=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>VFP8/XP:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am creating a Binary Memo =
field in a=20
table/DBF.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>When using "Create Table ..." SQL =
statement, there=20
is no option to distinguish a "Memo" field and a "Memo-Binary"=20
field.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Is VFP going to treat the momo field =
(which I=20
create with the field type "M") as "Memo-Binary" type based on the =
information I=20
am going to store in that field or what?!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>sp</FONT></DIV></BODY></HTML>
------=_NextPart_000_0008_01C372FB.7C8059D0-- Tag: claint-server example Tag: 180574
Using a UDF in Menu's skip for
Is there any way to reference the menu level, prompt, or command
values in the skip for section of the menu designer?
I want to create a database containing a record for each menu option,
and the user ID's that have the authority to run each option. I could
then place a used-defined function that queries this database to
determine if the option is available. Tag: claint-server example Tag: 180567
Overlaying a .wmf or other graphic over a .frx report
Does any know how I can overlay a graphic file over a .frx
report? This is what I want to do: I have a number of
81/2 X 11 forms (for example, export documents) that I
want to generate from my Foxpro program. I have done this
in Delphi by overlaying a .wmf on a report file and
printing them both. This method generates a very
professional looking form and is very useful in placing
and aligning the data fields. However, because of the way
VFP reports are generated (Header/Body/Footer/)inserting a
full page graphic and overlaying the data fields seems
impossible. If anyone knows how I can do this or
something similar I would be forever in your debt.
Thanks Pat Tag: claint-server example Tag: 180558
Recording Table Changes
I routinely receive updates to an existing table. I want
to compare the old table to the new and record (in another
table or view) only updated, added or delted records. I
can write a program that will compare each record field by
field, but can't help but think there might be an easier
way.
Any thoughts?
Thanks Tag: claint-server example Tag: 180554
Odd VFP6 behavior in XP
Just noticed this oddity developing in VFP6 SP5 in XP Pro.
Could be a video driver issue, but it only happens in VFP6,
not in VFP8...
Open a form for editing. Double click a control that has
a resonably long chunk of method code in it. Select that
method - the scroll bar in the edit window must be displayed.
Click and drag the scroll bar a bit and DON'T RELEASE THE
MOUSE. Keep the mouse button down, but keep the mouse
still. In my system, after about 6 seconds, all of the
windows in the VFP IDE go blank and stay blank until the
mouse button is released.
Thankfully the same thing does not happen in a VFP app
at runtime. Still weird though!
-- TRW
_______________________________________
My e-mail: t r w 7
@ i x . n e t c o m . c o m
_______________________________________ Tag: claint-server example Tag: 180553
PRTINFO()
How can I make a form print in landscape, thru a .prg
file. I have tried PRTINFO(1) to no avail.
Thank you Tag: claint-server example Tag: 180544
win32api GetTempPath() on win98
Hi,
I have been using the win32 api call GetTempPath() which has been working
correctly on my development machine (Windows XP). How ever when tested on a
Windows 98 machine the function returns an empty string, I know the winapi
function works on win98 because I have used it in the past with various
other languages. Please help!
Thanks
Chris Tag: claint-server example Tag: 180531
Passing array to DLL
Hi,
I have a litte problem with passing and getting back values of an array
passed to a dll (everything is VFP code).
Here is my sample, and what happened.
My DLL (a project compile as dll)
Define Class ArrayToDll as Custom OlePublic
Function GoArray
lparameter pTableau
Dimension pTableau(3)
pTableau(1)="One"
pTableau(2)="Two"
pTableau(3)="Three"
Return pTableau
EndFunc
Procedure ProcessArray
lparameter pTableau
Dimension pTableau(3)
pTableau(1)="One"
pTableau(2)="Two"
pTableau(3)="Three"
EndProc
EndDefine
and the code that uses the DLL ... i want to get back an updated array
(dimension and values)
Procedure ClientArray
Local oObjetDLL,lTableau
oObjetDLL=CreateObject("ArrayToDll.ArrayToDll")
Dimension lTableau(1)
lTableau(1)="Zero"
lTableau=oObjetDLL.GoArray(lTableau)
Dimension lTableau(1)
lTableau(1)="Zero"
oObjetDLL.ProcessArray(@lTableau)
Release oObjetDLL
EndProc
I tried two methods, getting my updated array by value or by reference.
In both case, i only get back an array with one element but with updated
values.
In fact, i get back the number of elements i passed, not an array with an
updated number of elements.
I got a solution with putting my array in an object and passing the object
... i just wanted to know if someone had to deal with such a case and how
you solved it ... a solution with just passing array seemed to me more to
read and understand ...
Bests regards. Tag: claint-server example Tag: 180523
Put a "date" date into a string and print in the report!
Hi All,
I have created a grid window and the data have been stored
in a cursor. Also, two text fields (datatype: Date, Name
of Text Fields: Text1,Text2) have been added in order to
list the selected area only in the grid window. I'm now
having a little troubles of how to print the selected data
in the report.
I want to list a sentence with "Text1" and "Text2" data
("date" datatype) in two text fields to the report like:
filter_print='The date from'+allt(thisform.text1.value)+'
to '+allt(thisform.text2.value) *!* This command is
written in "Print" and "Preview" button.
After I compile and execute the program, an error message
jumps out and said "Operator and Operand do not match!"
(It may not exactly the message like this!)
The reason is because "date" data cannot be inserted into
the string.
So what's the correct statement should be looked like?
Please help.
Sam. Tag: claint-server example Tag: 180519
Microsoft Windows Image Acquisition (WIA) Automation Layer
Does anyone have any experience with Microsoft Windows Image Acquisition
(WIA) Automation Layer - I would like to be able to scan & save images from
my vfp6 app
Thanks
John Tag: claint-server example Tag: 180510
WORD - CustomDocumentProperies
I am looking for de VFP code to set the CustomDocumentProperties in a Word
document.
TIA
Martin Lans Tag: claint-server example Tag: 180497
SQL download
I'd appreciate if someone can help me out on my dilemma:
I would like to know what are the steps/commands to use to
download data queried from SQL table, create output DBF
that I can process in my Foxpro.
Thanks for your help.
Deo Tag: claint-server example Tag: 180490
Catching error c05 when opening corrupted indexes
Catching error c05 when opening corrupted indexes
The problem is that I need to catch the error when I
execute an USE command that opens a table with a corrupted
index file.
Normally Fox just gives me C0005 and exits.
Any sugestion for any Visual FoxPro version from 6 to 8.
Regards,
Bastian Tag: claint-server example Tag: 180488
Double Ampersand in Pull Down
VFP8
I have a drop down control that is being populated by a field from a table.
In one of the records the field being displayed has an ampersand in the
text. When you pull down the list it displays two ampersands and not just
the one that is in the field.
e.g.
The field text is: Barnes & Noble
The pull down list displays: Barnes && Noble.
What is going on and how can I stop this.
Versions prior to VFP8 did not do this.
Thanks
Tim Cairns Tag: claint-server example Tag: 180484
Eltron Programming Language/Foxpro 8.0
I'm interested in printing bar codes on Zebra LP2844 barcode printer. Can I
access the Eltron Programming Language (EPL2) via Foxpro 8.0? Do I still
need to buy a barcode font package or is this included? Thanks in advance.
John. Tag: claint-server example Tag: 180478
#DEFINES in VFP 8.0 - Bug?
Hello,
today I discoverd a stupid behavior in VFP 8.0. Could anyone confirm the
following problem?
> VFP 7.0 SP 1
---------8<--------------
#DEFINE TEST "Hi"
? "TEST" && TEST
? [TEST] && TEST
--------->8--------------
> VFP 8.0
---------8<--------------
#DEFINE TEST "Hi"
? "TEST" && TEST
? [TEST] && HI
--------->8--------------
Thanks
Marco Tag: claint-server example Tag: 180462
Nested Scan w/in Procedure
Is it possible to do the following:
-scan through a table (table A)
-use values in that table (table A) to pass as parameters
to a procedure
-within the procedure, open another table (table B) and
scan through records in table B
I get a scan/endscan nesting error.
Thanks,
-Jeremy Tag: claint-server example Tag: 180438
Never before seen error in VFP6 Report Writer
During the past week I am repeatedly getting a
fatal exception while designing reports (with
the VFP 6 report writer.) I'm running on XP and
the error message provides no useful info -
just shuts VFP down.
I am trying to determine if the problem is unique
to my PC or if it might be related to a recent XP
update...
Has anyone else seen this? Tag: claint-server example Tag: 180437
access to task manager info from VFP?
Hi.
somebody knows how to aget the list of active processes as can be seen on
the Windows 2K task manager from a VFP program?
thanks in advance
Oscar Taboada Tag: claint-server example Tag: 180432
Printing memory and OT: Tracker PDF-Xchange
Hi all,
I've had memory issues nagging me for some time now on printing large
volumes of VFP reports. What I've got is a billing program that spins
through a few thousand customers and prints one or two copies of their
bills--always one in PDF format the other (printed in about 2/3 of the
cases) a postscript file. These bills consist of usually between three and
six different formats (one frx each) with occassional bills having ten or
even 15 different formats. So in the course of an entire run, it will
probably run 15-25,000 REPORT FORM commands.
As it runs, the MEM usage (from the Task Manager's Performance tab)
continues to climb. However, if I do all the other processing, skipping the
printing portions, the MEM usage change is negligible. My guess is the
issue is more in printing when drivers are needed as we used to report to
ASCII from frx's and never had these problems.
I think I've got the most up-to-date drivers installed (Win2K Pro machine,
HP5 printer/Acrobat 6.0 writer) and the app is currently running under VFP7.
Upgrading it to V8 is a possibility, but in some short tests this morning,
I've been seeing similar memory problems. Does anyone know of other places
I might want to look or am I pretty much stuck trying to keep drivers as
current as possible and keep setting stop-points and rebooting?
Somewhat related: has anyone used Tracker Software's PDF-Xchange for
printing w/ VFP. We're considering it as a replacement for Adobe's driver.
The reviews I've found are few, but positive. I'm concerned mainly with
accuracy, performance, then file size (though 1 and 3 so far sound good).
TIA,
John Tag: claint-server example Tag: 180431
Subquery returned more than one record
VFP8
SET ENGINEBEHAVIOR 70 or 80, doesn't matter.
The below query (the below is a portion of the query, the entire query has
some joins, etc.) has worked in previous versions of VFP.
I'm now getting the error "Subquery returned more than one record"
SELECT AcctCode,Dept,Revenue,Income ;
FROM JobCost ;
WHERE Dept=(SELECT Dept FROM ValidDepts WHERE Dept="4") ;
INTO CURSOR TempCost
The subquery does return more than one record, but it worked in the past.
Even if I force the subquery to return one DISTINCT record, I still get the
error.
Help anyone.
Thanks in advance
Tim Cairns Tag: claint-server example Tag: 180422
Date/Time from the server
Is there a way to pull the date and time off a server and
not the local machine?
Date() pulls the date off the workstation.
I would like to synchronize the Date/time with server.
Thank you.
NMenon Tag: claint-server example Tag: 180413
Hi all
where can i find example for clint-server program
i men com programes