Communications
Hello all,
The application I am working in copies files into a PC from a remote
server via pcAnywhere. The problem I have is that a dialog asking the user
for permission is presented. The dialog refers to the pcAnywhere's .CHF file
that the app uses to establish the connection. This occurs in Windows XP
boxes.
I noted that if the Software Restriction Directives branch of the
machine's Local Security is empty the dialog is not launched. How can I
Eliminate the contents of this branch (I mean all the content)?
Any help is a great help.
TIA
Carlos Jones Tag: Dragging classes on to form... Tag: 180873
Subclassing Foxpro Class Libraries
Hi everybody,
I am looking for Tool (PRG, APP, EXE) which enables me to subclass a Class
Library such that it retains all the Properties and Class hierarchy of the
Parent Class.
I will be very thankfull to anybody who could help me find such tool.
--
Tanveer H. Malik
LAHORE. (Pakistan)
Cell: +92 333 4227099 Tag: Dragging classes on to form... Tag: 180841
font changed
How can I fix the font of the VFP compiled exe file ? It is because the
font changes according to the system font of the OS that the exe file runs,
the labels become mess up.
Matthew Tag: Dragging classes on to form... Tag: 180837
How to find out how many instances running.
Hi all
I use an addon for Outlook that is creating multiple instances of Outlook to
run invisibly. I can see them all using Task Manager.
Is there a way in FoxPro or API to count how many instances of any
application are active? This might be useful in other circumstances where a
bug in my automation code leaves multiple copies of Word running.
Malcolm Tag: Dragging classes on to form... Tag: 180834
how to link with COM port
hello, i would like to know the coding to link the
program with COM port.. i'll will appreciate it.. Tag: Dragging classes on to form... Tag: 180828
VFP Remote Access Issues
Hello - I have a few questions about remote access with VFP.
First - does anyone have any idea as to the future speeds of the internet? We
have of course basic dial up, DSL, T1, etc. In general most have either dial
up or DSL or cable with top speeds of 500kbs or so. This is too slow if one
wants to map a drive through the intenet.
What is wrong with VFP? What in the world is it sending to the workstations on
a LAN? Seems like a lot of junk data or something. Certainly a lot more than
raw data is being passed.
I'm wondering if instead of a file server application I wrote a front end/back
end application using VFP as both the front end and back end and using a socket
control with TCP/IP if it would be a lot faster over a dial up. Or, if that
even makes any sense given that some of the hotels already have a high speed
connection. Or perhaps another soluition such as VFP on the web? I'm not sure
but does anyone have ideas for remote access improvements with VFP? Or will
technology bail us out with faster connections? If so - how long before we see
some real speed improvements at a reasonable cost? My understanding is right
now they are just way too expensive. Seems like even a T1 is not fast enough
when mapping a drive using VFP and with a lot of users something like Terminal
or Citrix server (which only does screen transfers) is too expensive.
Just exploring ideas,
Thanks.
Mike Tag: Dragging classes on to form... Tag: 180819
CURSORGETPROP / tablerevert
Hello, Im attaching a part of my code that seems to function
abnormally. I initiated cursorsetprop on my POSDetail table
(optimistic table buffering). I have to add the first record BUT
before i issue a TABLEREVERT or TABLEUPDATE, I have get some records
from another table. Those records need to get checked if there's an
actual onstock. If one of those records did not have enough stock, it
will actually TABLEREVERT all the records added, so it will return to
original form as if nothing was added. For some reason, it didnt
wanna revert all the records. Records that were already added stayed
in the table as if i had initiated a tableupdate which i did not.
If i issue a CURSORGETPROP(), will that function hold true for as long
as i didnt issue a tablerevert or tableupdate? or if i move from one
table to another and do some select statements in between the
CURSORGETPROP and TABLEUPDATE/TABLEREVERT, will it lose its state?
please help me out.
thanks.
select posdetail
=CURSORSETPROP("Buffering",5,"posdetail")
APPEND BLANK
replace detailno with lnNewId
replace transactno with lcTransactno
replace productid with lcProductID
replace quantity with thisform.txtqty.value
replace discount WITH thisform.txtdiscount.value
replace itemsales with thisform.txtsales.value
REPLACE itemcost WITH lcCost
replace nettotal with lcNetCost
replace grosstotal with lcGrossCost
bChkStock = .T.
IF thisform.bokits.Value THEN
SELECT bo_kitsku,bo_sku,bo_qty,bo_display FROM bokits ;
WHERE bo_kitsku = thisform.txtskucode.Value ;
INTO CURSOR botemp
SELECT botemp
GO TOP
nId = lnNewid
SCAN WHILE NOT EOF()
IF SEEK(botemp.bo_sku,"product","skucode")
IF product.onstock < 1 or THEN
=MESSAGEBOX(ALLTRIM(product.productname)+" does not have enough
stock!",0+16)
lbChkstock = .F.
EXIT
ELSE
lcProductid = product.productid
nId = nId + 1
INSERT INTO posdetail(detailno,transactno, productid, quantity,;
mod_user,mod_date,locationid) ;
VALUES (nId,lcTransactno, lcProductID,
botemp.bo_qty*thisform.txtqty.value, ;
goprogram.cusername, DATE(), VAL(goprogram.cregion_code))
ENDIF
ENDIF
SELECT botemp
ENDSCAN
USE IN botemp
ENDIF
SELECT posdetail
IF bChkStock THEN
=TABLEUPDATE(.T.,.T.)
ELSE
=TABLEREVERT(.T.,"posdetail")
ENDIF Tag: Dragging classes on to form... Tag: 180812
Open file dialog
I want to add an "Open file dialog" to my VFP 7 form. Where do I find it?
Thanks,
Scott Tag: Dragging classes on to form... Tag: 180811
define popup
I am trying to get a popup to show up under a command button when it is
clicked but I am having problems on getting it located without trial and
error and a static number. Any suggestions?????
--
Altman
VFP7 SP1
"No matter how foolproof you make a system, 'fools' can be remarkably
ingenious." Tag: Dragging classes on to form... Tag: 180807
claint-server example
Hi all
where can i find example for clint-server program
i men com programes
tankes Tag: Dragging classes on to form... Tag: 180790
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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... 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: Dragging classes on to form... Tag: 180510
WORD - CustomDocumentProperies
I am looking for de VFP code to set the CustomDocumentProperties in a Word
document.
TIA
Martin Lans Tag: Dragging classes on to form... 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: Dragging classes on to form... Tag: 180490
There is probably a very simple answer, but how do I drag an object in the
class browser onto a form? Or how do I place the object such as a command
button onto a form?