SQL SELECT DISTINCT
Hi,
I want to list any duplicate records in my table. How can I do it with
a SQL SELECT DISTINCT command?
Thanks
Derek Tag: ReFox XI for VFP9 Tag: 207582
does exe file compiled on VFP 7.0 work on win95?
ZG9lcyBleGUgZmlsZSBjb21waWxlZCBvbiBWRlAgNy4wIHdvcmsgb24gd2luOTU/IA0KDQpxdWVz
dGlvbiAjMjogaSBuZWVkIHRvIHVzZSBjb21tYW5kIGV4ZWNzY3JpcHQoKSwgYnV0IGFzIGkgdW5k
ZXJzdGFuZCB2ZnAgNi4wIGhhc24ndCB0aGlzIGZ1bmN0aW9uLiBpcyB0aGVyZSBhbnkgb3RoZXIg
ZnVuY3Rpb24gbGlrZSBleGVjc2NyaXB0KCkgaW4gdmZwIDY/DQoNCg0KDQp0aG54DQoNCg== Tag: ReFox XI for VFP9 Tag: 207581
SQL Server blocking using remote view
Hi,
I am using remote view to access sql server database, I have a problem that,
my 2nd instance of app be blocked.
After some investigation, we found that SQL server block one of my instance
since it is blocked by another. I am using auto transaction, optimistic table
buffering, share connection.
I would able to solve it by adding (NOLOCK) in my sql statement. No blocking
shown in enterprise manager. But why it cause blocking?
Thank you Tag: ReFox XI for VFP9 Tag: 207575
Hiding tables and class libraries during deployment
Hi All,
I need to deploy a foxpro application. The tables are foxpro tables and the
project also has .vcx files. How to package the tables and the class
libraries so that, when the application is deployed, the tables class library
files are hidden, even if the customer install visual foxpro developer's kit?
Regards,
kd Tag: ReFox XI for VFP9 Tag: 207574
Help in mypro.prg
An extensive textbox was programmed in fox2.x and I'm upgrading to vfp9.
I get an ERROR row and colum off screen. The program runs fine under vfp
but not as an executable.
The beginning of the prog.prg is
SET READ BORDER ON
STORE .T. TO MORE
I can't find where the program determines the size of the box.
What is MORE??? It doesn't show up in the code reference with a definition.
I need lots of help with this.
Thanks in advance. Tag: ReFox XI for VFP9 Tag: 207572
cursoradapter.recordrefresh
I wish to get the autoid from sqlsever when inserting a new record.
The vfp9 recordrefresh only seems to work if i in addition maintain my own
unique id and specify itin the keyfieldlist
Am i missing something?
thanks
Greg Tag: ReFox XI for VFP9 Tag: 207571
Using SYS(3050)
One of our customers has suggested using SYS(3050) to limit the memory use of
VFP (they suggest 512Mb) when packing large tables (2Gb). They suggest this
is only nessecary on Windows 2003 server standard editon
I am reluctant to impliment this for all our customers as i was under the
impression that VFP was the best memory manager.
Does anybody have any tips regarding this
thanks
greg Tag: ReFox XI for VFP9 Tag: 207568
Word AUtomation
I have several users running a program where I call an existing
Word.doc file using getobject. Only one of them is having a problem
with opening up a doc file. I am using the automation as below"
*This is what is in the database lastid.lscript2
*C:\samples\fee.doc
Selct 0
Use lastid
FADR = alltrim(lastid.lscript2)
oWORD = GetObject(FADR)
WITH oWORD
.APPLICATION.WINDOWSTATE = 1
.APPLICATION.VISIBLE = .T.
ENDWITH
Close Databases
The reason why I am using a variable is that I open different word.doc
files depending on selection of the user.
Is there a better way to open an existing file using the word
automation??
Thanks in advance for all the help you all have given me in the past.
TonySper Tag: ReFox XI for VFP9 Tag: 207557
FoxPro 2.5 and VFP 6.0
All, hope I'm in the right newsgroup. Hope I can explain my problem.
I have an excel file which I've converted via DataJunction to a foxpro 2.5
table.
I'm having trouble with when it comes to reading foreign characters.
MEANING: It doesn't read foreign characters!
I've got wierd characters on a lot of the foreign records.
I think it has to do with the codepage 437 not being able to display the
characters correctly.
If I open the original excel file, it displays fine. In foxpro 2.5 version
it does not. Depending on if I am at home or work version 6.0 may or may
not.
When I open in 2.5 it opens fine but displays poorly. When I try to read it
in with VFP 6.0 it states that the file "is not marked with a codepage". It
asks for me to choose a codepage. I've been choosing 437 and 1252 in
different tries with varying success.
What I need is for the version 2.5 to display them as well as can be done
for DOS.
Am I on the right track? Right or wrong, could someone offer any insight
what might be happening?
Regards
Dale Jones Tag: ReFox XI for VFP9 Tag: 207552
set coverage
Hi friends
does set Coverage to ... command works in runtime ?
i just want trace sequence of execution in runtime..
Thanks
--
cheers Tag: ReFox XI for VFP9 Tag: 207546
2 VFP questions
I just created a little VFP executable (.exe) that simply asks the user
for a string and does some processing. It returns another string that
gets placed in the clipboard, _CLIPTEXT.
Question 1:
The simple PRG that is part and parcel of the project (the entirety, so
far) defines a window and does a GET and READ. That Window's OK, but
it's shown in a VFP main screen. Is there a way to dispense with the
screen and just have my window show up, the one I defined like this:
DEFINE WINDOW browtbl FROM 10,10 TO 23,90 FLOAT
ACTIVATE WINDOW browtbl
@5,5 say 'Show newsgroups with what in the name?' GET lcstring
READ
DEACTIVATE WINDOW browtbl
Question 2 (probably more difficult):
What I'm really after is a way to keyboard this text where the mouse
cursor happens to be when I call this. I haven't even attempted this,
thinking it can't be done in FoxPro. Instead, I write to _CLIPTEXT. It
works, but I lose my former clipboard contents, occasionally a problem.
The mechanism I use here is to place my mouse cursor in some zone such
as one of the editing regions in a Google Groups search engine screen
(it's designed for that, actually). I then call my EXE with a macro
utility I use that's called with a keyboard shortcut. My macro utility
pops up a "popbox" from which I pick a button-icon representing an
action (in this case, my EXE). When my utility disappears (it does
automatically) my mouse cursor should be where it was before the utility
was called. I'd like to have my EXE actually write into where my mouse
was initially rather than my having to paste the clipboard contents? Is
that doable?
Thanks for ideas!! Tag: ReFox XI for VFP9 Tag: 207545
sendkeys wont work
Hi friends
I have a pageframe with 10 tabs on a form.
i have a command btn which has hot key (R).I am calling that hotkey
programmatically
(using sendkeys ) at different places as it is invisible to user.
it working beautifully but it wont work if any grid has focus.(BTW the grids
r readonly)
any ideas on this please
Thanks
--
cheers Tag: ReFox XI for VFP9 Tag: 207544
white screen on Exit
I upgraded from 2.x to vfp 9 and my application is working perfectly (Thanks
to your help) However, when I run the exe and click on Exit from a screen -
it flashes white and then closes. How can I eliminate the white screen? Tag: ReFox XI for VFP9 Tag: 207538
Problem with SQL sub-select and null dates
Hi,
I am having problems with an SQL select where the sub-select yields a null
date value, as the field in the original select does not seem to equate to
the null date. I get no records returned.
The SQL select statement below works fine when there is a date in the
counts_dt field, but does not work when the sub-select yields a null date
value.
SELECT * FROM COUNTS WHERE counts.counts_dt = (SELECT distinct
MAX(isnull(c2.counts_dt,NULL)) FROM counts c2 WHERE c2.property =
counts.property AND c2.unit = counts.unit AND c2.cntitem_id =
counts.cntitem_id AND c2.cnttype_id = counts.cnttype_id)
Any help would be appreciated.
Thanks in advance,
Pauline Tag: ReFox XI for VFP9 Tag: 207532
Progress bar
One of my applications needs to run quite heavy select statements on large
tables, and also quite time-consuming indexing operations. How can I:
- Update a progress bar during such a heavy database operation
- Give the user an option to cancel an operation after it has started.
Any ideas would be highly appreciated.
Aaron Tag: ReFox XI for VFP9 Tag: 207525
Virtual Private Networks and VP6
I've developed an application use VP6. Users are using a VPN with cable
and DSL. They say it runs a little slow. The application is loaded on the
local machine and it looks to the server across the network for the data. Is
there anything I should have done or could have done to make processing the
information quicker.
Note I developed the application use all free tables.
Rusty G Tag: ReFox XI for VFP9 Tag: 207522
Problem with Menu
I am having problem with the menu in my application only in Development
environment. When I create EXE file and run then it works without a hitch.
I have over 130 menu items that comprise of 8 at the menu bar level and
remaining are submenus of these 8 main menu items. The application is a
multi-user application and I need to enable/disable menu items depending on
each user's access levels. The user access levels are stored in a dbf file. I
am achieving this by placing an expression in SKIPFOR field of the
mainmenu.mnx file. Here is the relevant code:
SKIPFOR field -> ifuseraccess(cUserid,prompt)
Function IfUserAccess(cUser,cPrompt)
Local nCurarea,lFound
if cUser=='SUPERMAN' && For SUPERMAN, all options are enabled.
lFound=.t.
else
nCurarea=select(0)
usefile('useraccess')
select Useraccess
set order to 1
lFound=seek(cUser+cPrompt)
select (nCurarea)
endif
Return lFound
The problem is that as long as I populate the SKIPFOR field for about 50
items or so, it works with no problem. As soon as I go upto 60 items or more
and run the application, the main menu bar displays fine but when I click on
any of the items on the menu bar, it doesn't show the dropdown menu. I have
to repeatedly click on a menu item for show its dropdown items. Once the
dropdown is displayed for one menu bar item, I can slide left or right to
other items and the dropdown menu will show but if I move the mouse away from
the menu bar and try to go back again I run into the same problem. It appears
to be a speed issue but I am not sure. The compiled EXE file works absolutely
fine.
I am using VFP 6.0 on a PIII 900 mhz. machine under XP PRO, Enterprise
edition.
I will appreciate suggestions from the experts here as this problem is
really annoying and slowing down my development process.
Thanks. Tag: ReFox XI for VFP9 Tag: 207514
SQL Question
How do I read a field that has [ it's name.
See custaddr.addr[1] below.
Example
sql = "SELECT co.[co-num] as conum, custaddr.addr[1] ,"
sql = sql + "FROM CO INNER JOIN custaddr ON "
sql = sql + "co.[cust-num] = custaddr.[cust-num] AND co.[cust-seq] =
custaddr.[cust-seq] "
sql = sql + "WHERE co.[co-num] = '" + txtOrderNum + "' " Tag: ReFox XI for VFP9 Tag: 207513
How to make STR(14.2) display 14.2 as string?
Hi All,
I am sure there is an answer to this that I don't know of!
I need to concatenate strings and values and display decimals as strings.
For example:
?"Amount Due: $. " + STR(14.2)
displays
Amount Due: $. 14
Is it possible to diplay the string as
Amount Due: $. 14.2
Thanks. Tag: ReFox XI for VFP9 Tag: 207503
can not update Oracle database with a remote view
Hi,
we are using remote views to store new records into an Oracle databases and
we have a very special case where the tableupdate(.T.,.T.,"tabla") command
is rejecting the insertion of records, please note that this trouble arises
just in one of the two workstations we are using for the development, and as
a fact, both computers are succesfully updating oracle databases on three
different Oracle database servers and the trouble happens only on the fourth
Oracle server
both workstationss are using VFP 6.0 installed from the same CD
to eliminate application bugs we have tested direcctly from the command
window the following
Use "remote view"
replace key_fields with 99999
?tableupdate(.T.,.T.,"remote view") ----> this returns .F.
if after this, we execute again the use "remote view" command, we get an
error message that says that we can not insert a reciord with null values..
we have confirmed for sure that there are absolutely no restrictions for
NULL values in the Oracle database... this is a specific workstation trouble
we have verified that we have the same settings for the DSN in the MS
Windows ODBC sources
we are using the same Oracle8 ODBC driver
I would appreciate any suggestion of what to compare between both
workstations in order to diagnose and fix this trouble
thanks in Advance
Oscar Taboada Tag: ReFox XI for VFP9 Tag: 207502
Problem With Vfp8
Hi 2 all.
The vfp8 exe file are not runing when i bulid this project into vfp7 it runs.
i copy all vfp8 dll files into project directory.i have winxp install.
waiting for good reply
--
Qaiser Me Tag: ReFox XI for VFP9 Tag: 207501
Distributing Application: Netsetup wouldn't work, Disk144 does
I have spent over 6 hours today trying to make my distributed program work
using Netsetup in step 3 of the Setup Wizard in VFP 6.0.
With the Netsetup, the application installs fine and some options even work.
However, I have two databases that are distibuted with the application named
wwdata and wwtables. Database wwdata has its dbf files stored in
\\Appdir\data\ and that of wwtables are in \\Appdir\tables. When the
application tried to open a table in wwtables, I keep getting the message
"Error instantiating cursor object. File City not found in
\\....\wwtables.dbc" or something like that. I tried numerous times by
cleaning up the project and making sure that dbc file is not corrupted or
something, but couldn't get rid of the error.
Finally, I reluctantly selected the 1.44 MB option (I want to distribute the
application on a CD in stead of floppies), and BOOM, it work the first time
installation. However, it created six subdirectories DISK1 to DISK6 in the
main directory named DISK144.
Does anyone know the cause of this behaviour and is there any other way I
can create Distribution files under one directory.
Thanks in advance for heliping out...... Tag: ReFox XI for VFP9 Tag: 207488
How do I capture mouse events to a control - MouseHook
Hello,
VFP 9 WIN2K
I need to capture the mouse events for a specific control and when done with
the control return the mouse events back to normal.
Does anyone know how to do this in VFP
Thanks in advance,
-CraigB Tag: ReFox XI for VFP9 Tag: 207482
I am looking for a 3rd Party VFP friendly RTF Reports ocx or dll product
Hi All,
I have been using Microsoft's richtx32.ocx in conjunction with
apiprinter.vcx by Rasmus Moustgaard to view and print rtf documents created
in MS-Word. I do not need the end-user to be able to edit the document.
I am in the market for a integrated replacement control that will HANDSOMELY
print and print preview MS-Word created RTF documents. Also, looking to be
able to distribute the control royalty free. Any suggestions would be
appreciated.
Best Regards,
Tom Clark Tag: ReFox XI for VFP9 Tag: 207479
forrm.autocenter
I have encountered an issue with some of my forms. All of my forms are based
on a class called cform. Cform has its autocenter set to .t. and this works
just fine.
I have a few forms that I don't want to autocenter to I changed that forms
value to .f..
But, their still autocentering.
Its not the foxuser , and ini or some registry setting. I have no code in
cform to force it back to .t. And after the form has run a check of that
property reveals it to still be .f.
Suggestions?
Alan Tag: ReFox XI for VFP9 Tag: 207469
Error opening exe
I'm upgrading vfp 2.x to vfp 9. I fixed all compiling errors - and built a
new.exe. When I run new.exe I get an the error Window 'command' has not been
defined.
I can click ignore, the main menu runs but it then claims my files are
corrupt (which they are not because I checked them). Tag: ReFox XI for VFP9 Tag: 207465
Class location
I have put the classes in my project into files according to logical
grouping. So sales.prg, purchases.prg, stock.prg etc.
I am finding it a bit of a pain however trawling through pages of code to
get to the bits I want.
A colleague of mine who is experienced with C and Delphi says he normally
puts each class into a file of it's own. Do you do this? Is it a good idea?
--
Regards
Darren Woodford - MCP, MCSE
Woodford Computer Systems Ltd
http://www.woodfordcomputers.co.uk
http://www.accountancy-software.co.uk/pegasus-opera-ii/pegasus-opera-ii.php Tag: ReFox XI for VFP9 Tag: 207455
Build Project Error
When I try to build project, I get this error:
Program d:\windowwizard\prgs\winwizprocs.prg has the following errors:
Unknown AARRAY - Undefined
Form d:\windowwizard\forms\frmcustomerentry.scx has the following errors:
Unknown ALEADTYPE - Undefined
Here is the source code in the project I am trying to build:
Public aLeadtype
Dimension aLeadtype[5,2]
fillarray(@aLeadtype,"'A','Architect','B','Builder','P','Private
Owner','R','Renovator','D','Dealer'")
Function Fillarray(aArray, cValues)
Local nLen,i,cValtype
for i = 1 to alen(aArray)
cVal=token(cValues,',',i)
do case
case type(cVal)='L'
aArray[i] = evaluate(cVal)
case type(cVal)='C'
aArray[i] = strtran(cVal,"'",'')
otherwise
aArray[i] = val(cVal)
endcase
next
return aArray
Any ideas are greatly appreciated. BTW, Token is another function that I
wrote and that function works flawlessly and returns expected values.
Thanks. Tag: ReFox XI for VFP9 Tag: 207453
Outlook Mail Automation
Hi
We have developed a VFP6 app for a customer that sends mail through Outlook.
However our customer doesn't want all the recipients to be visible to each
other so I thought it would be ideal to use BCC if it is available.
I am currently using the following code to handle the mail
olMessage = olOutlook.CreateItem(olMailItem)
olRecipient = olmessage.Recipients.Add(addresslist)
olmessage.send()
Could this be modified to send via BCC instead of straight addresses ?
Thanks in advance
Andy Tag: ReFox XI for VFP9 Tag: 207448
slow reporting
With REPORTBEHAVIOR = 80, a report preview pops up instantly.
With REPORTBEHAVIOR = 90, the same preview takes 12 seconds to appear. Is
that normal? Tag: ReFox XI for VFP9 Tag: 207435
Excel error
I am getting a strange Excel error in my application.
<snip>
tmpsheet=getobject('', 'excel.sheet')
XLApp=tmpsheet.Application
XLApp.Visible=.f.
<snip>
I am getting an error on the "XLApp=tmpsheet.Application" line.
OLE error code 0x80010108: The object invoked has disconnected from its
clients
Can anyone tell me how to fix this?
Thanks,
Scott Tag: ReFox XI for VFP9 Tag: 207434
VFP9 in MSDN?
Anyone know which MSDN distribution will include VFP9? I
was expecting it in the January shipment, but no dice.
Yes, I know it is available for download, but I live out
in the boonies and have a snail-like dial-up connection
that gives me 26kbps on a good day. :^(
-- TRW
_______________________________________
t r w 7
at
i x dot n e t c o m dot c o m
_______________________________________ Tag: ReFox XI for VFP9 Tag: 207426
VFP 9 Rebate offer
This may be old news to some:
watch for url wrap
[ http://www.microsoft.com/products/info/popup.aspx?view=22&type=rebate&cont
ent=7b9bb6aa-f6c0-43b4-b315-6cfd9eb3e39a ]
and of course - buy yer VFP Version 9 here:
http://www.foxtoolbox.com/
Enjoy ! mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
VFP Webhosting? You BET! -> http://efgroup.net/vfpwebhosting
mySql / VFP / MS-SQL Tag: ReFox XI for VFP9 Tag: 207421
Transaction problem in VFP9
Dear all,
The code beneath generates an error in VFP9. In VFP8 it runs fine.
The purpose of the original code is to store data from a view into the
database. The sample code doesn't really make sense anymore. We
stripped the code down to its bare minimum. It's just a way to show
the error.
We don't think this code is illegal. So, is there a bug in VFP9?
Regards,
Roel, Bas and Benno.
*=========== BEGIN CODE ============================
CREATE DATABASE database
OPEN DATABASE database
CREATE TABLE test (FIELD_KEY I, FIELD_DATA I)
INSERT INTO TEST (FIELD_KEY, FIELD_DATA) VALUES (0, 0)
CREATE SQL VIEW MYVIEW AS SELECT * FROM test
USE MYVIEW IN 1
CURSORSETPROP("buffering", 5, 1)
CURSORSETPROP("keyfieldlist", "FIELD_KEY", 1)
CURSORSETPROP("UpdatableFieldList", "FIELD_KEY, FIELD_DATA", 1)
REPLACE FIELD_DATA WITH 1 IN 1
SAVE_VIEW()
APPEND BLANK IN 1
REPLACE FIELD_KEY WITH 1 IN 1
SAVE_VIEW()
PROCEDURE SAVE_VIEW()
LOCAL nRecno
nRecno = GETNEXTMODIFIED(0, 1)
BEGIN TRANSACTION
GOTO (nRecno) IN 1
IF (nRecno > 0)
REFRESH(1, 0, 1)
CURVAL("FIELD_DATA", 1)
ENDIF
TABLEUPDATE(0, .F., 1)
END TRANSACTION
ENDPROC Tag: ReFox XI for VFP9 Tag: 207420
valid views built in view designer can't be opened by view designer
When building remote views, I've noticed that I can build queries with the
View Designer on back ends that have non-Fox features, like spaces in the
field names. The View Designer works fine, the query works fine.
But if I try to reopen the view with the View Designer, I get "syntax error"
messages, so if I want to modify the view, I have to do it programmatically.
The View Designer in VFP9 is very good, and a big improvement over VFP8's
(which was a big improvement over VFP7's). But it really should be able to
open views that it itself created, don't you think? Tag: ReFox XI for VFP9 Tag: 207419
Reset Browse Last to match Browse Preference?
Reset Browse Last to match Browse Preference?
I have about 6 aliased and related browse windows of the same .dbf
that I'm using to manually clean up data.
The records are quite long so even with some fields sized smaller than
their actual field length in the browse window, I still have to scroll
right and left as I go about my cleanup, or expand a field (with my
mouse) I have covered up, to check it or enter data.
As I skip back and forth and alter the alignment or size of the
displayed fields I want my changes to the browse windows to be kept
and reflected with a Browse Last, WHICH THEY ARE.
That's why I'm using Browse Last (from a On Key Label F8)
Anyhow, sometimes things get screwed up and I wish I could revert one
or more of the windows back to my more or less starting browse
appearance, like with a Browse Preference to sort of reset things and
then go back to using a Browse Last.
I don't think Browse Preference and Browse Last play well together.
They seem to be totally independent.
Isn't there a way to get Browse Last to absorb Browse Preference?
Is there some other work around i.e. a way to set up a particular look
for all the browse windows that will be a sort of reset for Browse
Last?
--
JJ
John "J.J." Jackson Tag: ReFox XI for VFP9 Tag: 207418
execute pc code from a command button
What is the proper procedure that would be used to have a command button do
something like:
comment - file copy in process
y:\
MD test
c:
CD\temp
COPY *.* y:\test
comment - file copy complete
Dan Tag: ReFox XI for VFP9 Tag: 207417
Store column positon and width.
Hello all,
I would like some advice, what is the best way to store grid column
positions and width. I thought about using .ini files.
Any advice would be appreciated.
Regards
Richard
--
To reply remove 'NoSpam' from email address Tag: ReFox XI for VFP9 Tag: 207408
blat
Can't use Blat if you have Norton Antivirus installed!
Scan type: Auto-Protect Scan
Event: Threat Found!
Threat: Bloodhound.OutEmail
File: C:\WINDOWS\system32\blat.exe
Location: Quarantine
Computer: STEVEFISHER
User: steve.fisher
Action taken: Quarantine succeeded : Access denied
Date found: 10 February 2005 13:43:02
I haven't worked out how to exclude blat from scan. Everything is
greyed out on my machine so will have to check the w2003 server and the
book.
Steve Tag: ReFox XI for VFP9 Tag: 207403
error "File not open" when building
For the past couple of days this error has appeared when I try to build a
project in FPW2.6
I click "build", then select "executable" and when I click OK, instead of
asking for the output file name it just says "File not open"
Why?
I've tried CLOSE ALL, CLEAR ALL but the only thing that seems to fix it is
quit and restart.
--
TIA
Andrew Howell Tag: ReFox XI for VFP9 Tag: 207396
RUN exe and hide the box
This is a multi-part message in MIME format.
------=_NextPart_000_000E_01C50F6F.FD914630
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable
Hi,
How do i "RUN ipconfig.exe > ip.txt" by not showing up the disturbing =
dos look windows box ?
I can't use /N7 because I need to read for the created ip.txt=20
regards
Hoe
------=_NextPart_000_000E_01C50F6F.FD914630
Content-Type: text/html;
charset="windows-874"
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-874">
<META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>How do i "RUN ipconfig.exe > =
ip.txt" by not=20
showing up the disturbing dos look windows box ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I can't use /N7 because I need =
to read for the=20
created ip.txt </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML>
------=_NextPart_000_000E_01C50F6F.FD914630-- Tag: ReFox XI for VFP9 Tag: 207392
How to print continuously
Hello,
I am trying to output my report to a roll of
labels on my printer but it skips at the end
of each page.
How can I make it to print continuously without
the page break?
Thanks.
--
jw Tag: ReFox XI for VFP9 Tag: 207391
Test dropped-collapsed state of dropdownlist
Is there any way to test the state of a dropdownlist to determine if it
is currently dropped or collapsed?
I'm looking to write a procedure to toggle it, but not knowing its
current state makes this a wee bit challenging. Perhaps there is
another way, but right now I have tunnel vision and seem to want to do
it this way.
Jim Tag: ReFox XI for VFP9 Tag: 207385
Printing Labels from record to record.
There has to be a way but I have not stumbled on it yet. I want to
print labels between records. Something like label form mylabel record
1 to record 8. Tried all but between does not work, less than greater
than don't work. What works. Do not know what I would do without all
the help I get on this newsgroup.
TonySper Tag: ReFox XI for VFP9 Tag: 207381
Text not showing
Upgrade Fox 2.6x to 9.0
A screen contained text on upper portion and controls on lower portion. The
screen contols work but the text doesn't appear.
In a .prg reads
cNotes = ;
"^ XXXXX XXXXXXXXXX# XXX: XXXXXXXXX-XXXX " +;
"XXXXXXXXX XXXXXXXXXX ^^" +;
WRAP("This xxxxxxxx requires multi-level " +;
"contractors to place job titles in the xxXXX " +;
"where the selection decision is made for " +;
"those jobs (Higher Level Plan) rather " +;
"than in the XXX where the jobs are " +;
"physically located (Lower Level Plan). ",104) +'^^'+;
WRAP("These job titles remain in the Workforce " +;
"Analysis of the Lower Level Plan but " +;
"are excluded from the Utilization Analysis " +;
"and Goals and Time Tables of the " +;
"Lower Level Plan.",104) +'^^'+;
"These xxx xxxxx are included in " +;
"BOTH the Workforce Analysis and Utilization " +;
"Analysis and Goals ^and Time Tables of the " +;
"Higher Level Plan.^^" +;
WRAP("The affected job titles are marked with an "+;
" * when they appear in both plans. " +;
" " +;
" ",104)
This is info only - how can I get it to show on the screen?
Thanks. Tag: ReFox XI for VFP9 Tag: 207351
return value from sproc with spt
Hi,
How can I retrieve a return value from a MSSQL server sproc using SPT?
I'm not using any output param in my sprocs. All I need is to retrieve the
sprocs' retval from my vfp appl, and NOT just the status of the sproc exec.
In other words, I need an equivalent to following VB.NET statements:
sqldataadapter1.selectcommand.parameters("@return_value").value.
Thks & brgds,
andy Tag: ReFox XI for VFP9 Tag: 207350
ms winsock activex control
This is a multi-part message in MIME format.
------=_NextPart_000_000A_01C50F07.515EC440
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable
Hi,
what file name is this ms winsock activex control in vfp 7.0 or 9.0 ?
can this file royalty free for distribution with our vfp exe ?
can we buy it without purchase of the vfp license ?
regards
hoe
------=_NextPart_000_000A_01C50F07.515EC440
Content-Type: text/html;
charset="windows-874"
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-874">
<META content=3D"MSHTML 6.00.2900.2135" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>what file name is this ms winsock =
activex control=20
in vfp 7.0 or 9.0 ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>can this file royalty free for =
distribution=20
with our vfp exe ?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>can we buy it without purchase of the =
vfp license=20
?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>hoe</FONT></DIV></BODY></HTML>
------=_NextPart_000_000A_01C50F07.515EC440-- Tag: ReFox XI for VFP9 Tag: 207340
need some advice on user impersonation and vfp 8
We have an application that spans several generations of VFP and now have to
make some modifications to it.
It runs client/server to a sql database or an oracle database for starters.
The app launches and the user must log in. This is a user and password
that resides in our app and db. It is not integrated with the OS user in
anyway. There in lies the problem.
Now, we need to make all the properites of the user accounts in the app
behave like OS users where you can require strong passwords, minimum
lengths, expirations, memory, encryption, etc. All the things the OS
generally handles.
What I am thinking I might do is somehow map those user accounts to the
domain user accounts (at least for windows domains) thru the use of thier
account SID or something. Then give them a cmd line switch on launch to use
that feature or not or something like that.
Is this possible? If so, how? Do I hook into some windows API for this?
Not really sure.
If anyone can shed some light I'd be greatful.
TIA Tag: ReFox XI for VFP9 Tag: 207339
Auto Dial and Disconnect in VFP
Friends,
Some months ago I was looking for a way to programatically dial and
disconnect a SPECIFIED dial-up networking connecion. Although no VFP solution
was found, today I came across a topic by the name of RASDIAL in windows
help. There is an internal application in windows by the name of rasdial.exe
which did what I wanted. (My OS is win XP Pro, however this application seems
to be there in Win95 upwards)
However while I was searching for topics related to RASDIAL in windows web
knowledgebase, it appeared to me that there is an RASDIAL API also. My
knowledge of API call is as good as none. I will appreciate it very much if
some members please guide me towards better usage of this feature.
I used the following code to connect and disconnect:
run rasdial "Connection_name" "username" "password"
run rasdial "connection_name" /d
(I found details about the utility by searching by keyword "rasdial" in win
XP help)
Now I am looking forward to have following features:
1. To know if connection has been successful, else redial.
2. To be able to do these things without the usual black window.
Please accept my gratitude for the helpful and useful posts in the group. I
will look forward to have a detailed sample code because I do not have
detailed knowledge of API calls.
Best Regards
S Bans Tag: ReFox XI for VFP9 Tag: 207338
ReFox XI for VFP9 (and all older versions of FoxPro) just launched
new branding level III with compression - 100% safe protection
web.telecom.cz/refox/index-en