frx2word
I use for my reports frx2word.
All reports works. But by some windows 2000 Computer with office 2000 it
dosnt work.It comes no Error Messages. But the doc file is empty.
Thanx
--
Cengiz Zengin
CZ Computer Tag: Find Tag: 215034
installshield
The InstallShield of VFP 9 really `scared` me.. So much complicated than
VFP6's setup wizard...
--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 8:48pm up 37 min 5 users 1.57 1.66 Tag: Find Tag: 215029
FPW2.6 check if report available programmatically
I'm writing a program that uses a report. This program is usually compiled
into .exes, and when building, the project manager finds the report and
includes it in the .exe.
However, this program is sometimes called from a standalone prg I run in the
IDE. The report almost certainly won't be visible at run time and I don't
want to make an identical copy elsewhere (although that would work.) What I
would like to do is something like
IF isexe()
REPORT FORM report.frx TO PRINTER PROMPT
ELSE
REPORT FORM <full path to report>\report.frx ...
ENDIF
The best I've thought of is an ugly error trap:
m.lno_frx=.F.
ON ERROR m.lno_frx=.T.
REPORT FORM report.frx TO PRINTER PROMPT
ON ERROR
IF m.lno_frx
REPORT FORM <full path>....
ENDIF
Any other ideas?
--
TIA
Andrew Howell Tag: Find Tag: 215019
How to update characte(binary) field on dbf table using cursoradap
i create a dbf table that have some binary char fields and i want to use
cusroradaptier via ADO to update.
it cannot update when execute tableupdate() command.
aerror() get the error as following
error : 1435
Microsoft Cursor Engine : Multiple-step operation generated errors. Check
each status value.
it is same error either set mapbinary property on cursoradapter object to
.t. or .f.
sample code :
********************
IF !file("c:\test\test.dbf")
CREATE TABLE c:\test\test.dbf (testval c(10) nocptrans)
APPEND BLANK
USE
endif
set multilocks on
oca=createobject("cursoradapter")
oca.alias="catest"
oca.buffermodeoverride=5
oca.cursorschema="TESTVAL M"
oca.datasourcetype="ADO"
oca.keyfieldlist="TESTVAL"
oca.mapbinary=.T.
oca.selectcmd="Select * From test"
oca.tables="test"
oca.updatablefieldlist="TESTVAL"
oca.updatenamelist="TESTVAL test.TESTVAL"
loConnDataSource = createobject('ADODB.Connection')
loConnDataSource.ConnectionString = [Provider=VFPOLEDB.1;Data
Source=c:\test;Password="";Collating Sequence=MACHINE;]
loConnDataSource.Open()
oca.DataSource = createobject('ADODB.RecordSet')
oca.DataSource.CursorLocation = 3 && adUseClient
oca.DataSource.LockType = 3 && adLockOptimistic
oca.DataSource.ActiveConnection = loConnDataSource
oca.cursorfill()
SELECT catest
replace testval WITH "test"
IF TABLEUPDATE(1)
else
=AERROR(amessage)
=MESSAGEbox(amessage(2))
endif
********************
i'm using vfp9.
--
Ray Tag: Find Tag: 215018
What does this mean ?
I have come across a code snippet which I am unable to understand - the
color statement - Can anybody help me understand this thing ? What does
these so many RGB means in the deffinition ?
MODIFY WINDOW lw_invoice NOGROW ;
COLOR RGB(0,0,0,192,192,192), ;
RGB(0,0,0,255,255,255),,,,,,,, ;
RGB(0,0,0,192,192,192) ;
FONT "Courier New", 9 Tag: Find Tag: 215011
Replace question and table precision
* make sure there are no DBCs open
create cursor zoot (zz n(3,1))
append blank
replace zz with 9.9
? zz && prints 9.9
replace zz with 999
? zz && prints 999
The last replace command should not work, but it does. Why? I've learned
from experience that VFP is pretty sloppy about numeric fields if the table
is not associated with a DBC, but I figured they would have fixed this by
now? Is this left in for legacy purposes? Tag: Find Tag: 215004
[OT] User-Defined string Functions Transact-SQL <-> VFP
Ladies and Gentlemen,
I am pleased to offer, free of charge, the following string functions
Transact-SQL:
AT(): Returns the beginning numeric position of the nth occurrence of a
character expression within another character expression, counting from the
leftmost character.
RAT(): Returns the numeric position of the last (rightmost) occurrence of a
character string within another character string.
OCCURS(): Returns the number of times a character expression occurs within
another character expression (including overlaps).
OCCURS2(): Returns the number of times a character expression occurs within
another character expression (excluding overlaps).
PADL(): Returns a string from an expression, padded with spaces or
characters to a specified length on the left side.
PADR(): Returns a string from an expression, padded with spaces or
characters to a specified length on the right side.
PADC(): Returns a string from an expression, padded with spaces or
characters to a specified length on the both sides.
CHRTRAN(): Replaces each character in a character expression that matches a
character in a second character expression with the corresponding character
in a third character expression.
STRTRAN(): Searches a character expression for occurrences of a second
character expression, and then replaces each occurrence with a third
character expression. Unlike a built-in function Replace, STRTRAN has three
additional parameters.
STRFILTER(): Removes all characters from a string except those specified.
GETWORDCOUNT(): Counts the words in a string.
GETWORDNUM(): Returns a specified word from a string.
PROPER(): Returns from a character expression a string capitalized as
appropriate for proper names.
RCHARINDEX(): Similar to the Transact-SQL function Charindex, with a Right
search.
ARABTOROMAN(): Returns the character Roman numeral equivalent of a specified
numeric expression (from 1 to 3999).
ROMANTOARAB(): Returns the number equivalent of a specified character Roman
numeral expression (from I to MMMCMXCIX).
AT, PADL, PADR, CHRTRAN, PROPER: Similar to the Oracle functions PL/SQL
INSTR, LPAD, RPAD, TRANSLATE, INITCAP.
More than 4000 people have already downloaded my functions. I hope you will
find them useful as well.
For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
or http://nikiforov.developpez.com/ (the beautiful French language)
Please, download the file
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
With the best regards. Tag: Find Tag: 215002
VFP 6: clear events with Nonmodal Forms
You might recall my question not too long ago about
copy-cut-paste with toolbars. I am now looking at using nonmodal
forms. I have a couple of problems.
1) Where do I put the clear events command? If I do not have it, my
program does not terminate when all forms are closed. Since any form
might be the last, what is the best placement?
If I am using a menu, then presumably, I put it in the exit
selection, but if I am not using a menu, what do I do?
I suppose that I can have
if _screen.formcount=0 && or 1, I am not sure
clear events
endif
in a suitable event's (.unload()?) code, but it looks kludgy.
2) What is the best way to store the object references (so the forms
stay in scope)? A global array? Do you have hardcoded references to
array elements, search for a free element, or do something else?
Sincerely,
Gene Wirchenko Tag: Find Tag: 215001
VFP8 Intellisense issue
I'm writing an ActiveX control (non-attributed ATL project in VS7). I've
noticed a problem when testing this ActiveX control in Visual FoxPro 8 and
9.
If I type "ThisForm.oleCtrl.", the trailing "." which triggers the
intellisense code completion, causes vfp to shut down with a Buffer Overrun
error message shown below.
Anyone encountered this problem?
Thanks,
Greg
...
Microsoft Visual C++ Runtime Library
Buffer overrun detected!
Program: ...ogram Files\Microsoft Visual FoxPro 8\vfp8.exe
A buffer overrun has been detected which has corrupted the programs'
internal state. The program cannot safely continue execution and must
now be terminated.
... Tag: Find Tag: 214997
Connecting To DBF Using vfpoledb
I have the need to connect to a remote DBF table across the network.
Currently, I able to do this using a mapped drive which maps to the remote
system where the DBF is stored, as such.
Provider=vfpoledb;Data Source= \\remoteserver\dbffiles\;
Mode=ReadWrite;Collating Sequence=MACHINE;
However, mapped drives can be finicky. Now, the purpose of this post is to
ask; "Is there a better way to do this, without the need for a mapped drive?" Tag: Find Tag: 214982
Printing on a dot matrix with vfp9
When I set report behavior 90, The fonts no longer print out correctly on a
dot matrix printer. When I set report behavior 80 everything is fine.
What Can I do to insure the fonts print out correctly? I tried saving the
printer environment and it did not help. Sending output to generic text
printer driver does not work well either. Tag: Find Tag: 214979
Migration from XBase++ to Visual FoxPro 9
Hi,
I am working on a project in Visual FoxPro 9 which will eventually replace
the existing software written in XBase++.
During this migration process, I will use the existing XBase++ tables with
cdx indexes.
Does anyone have any recommendations or any data recommendations during this
migration.
I seem to have random index problems. The problem will not be there and then
it shows up. I then delete the index file and reindex with the XBase++
software and the VFP9 software will still show the error. I then open the
free table and the index in VFP9 and then issue reindex (This is done
without trying to browse the table). All is cured. The table is still
accessable from XBase++ software and VFP9 software. Anybody know what is
going on here and what I need to start doing in order to make this work?
Thank you,
Mike Tag: Find Tag: 214973
Change colors of the Window Globaly ?
I want all the windows in my application - which is already running and
using different back ground colors - to have a specific color say blue -
irrespective of the colors the windows are defined with - ? Is it possible
either ?
I am looking for a solution like a hook which keeps on looking whenever a
user defined window becomes visible OR no matter is defined its back ground
color changes to that specific color. Tag: Find Tag: 214963
CREATE OBJECT
I develop application in vfp9 using the command CREATE OBJECT for link ole
application and work fine with EXCEL, WORD and PP, but i cant do the same to
link with WORDPAD or NOTEPAD, i will appreciate if could help to to fix these
problem.
Thanks. Tag: Find Tag: 214962
writing map software
Not sure if this is the right place or not, but does anyone know how
mapping software is written? i'd like to write a baby program to map
out my building and where the different meeting rooms are located (time
and distance to each room from a disgnated spot, etc).
if anyone has any suggestions please send me an email. Tag: Find Tag: 214960
Keypress event F2 works in VFP6 but not VFP7 onwards
I am converting an application from VFP6 to VFP9 and have discovered an
issue that I hope someone can help with.
I am trying to capture the F2 key being pressed within a textbox on a form
in the keypress event (nKeyCode=-1). This would not work in VFP9 so after
trying many things I built a basic form with one text control and a capture
of the key press events to screen. It appears that in VFP6 the textbox
keypress event happily tells me that F2 has been pressed, however in VFP7
onwards it appears that the F2 is not captured and nothing happens. The ON
KEY LABEL is not active and F3, F4 etc are all working e.g. nKeyCode=-2,
nKeyCode=-3 etc. This happens only with F2 (nKeyCode=-1).
Does anyone know why? Is there something I am missing?
This seems too simple an issue to be a bug?
Thanks
John R. Tag: Find Tag: 214955
DOS Filenames
I am integrating an ActiveX control into my app. One of the properties is
'FileName'. Works fine till the property is set to a string containing the
'~1' characters one gets from SYS(2023).
Is there a utility/command that will convert the DOS path to a the real
pathname?
tnx,
Howard Tag: Find Tag: 214953
Foxpro dll and Installshield
I built a multithreaded com server (dll) in FoxPro 9 and put it into my
installshield to install. When it tries to build the installer I get this
message.
The build was unable to extract COM information from the file <my dll file>
in component <my dll file>. Please ensure that the file is self-registering
and verify that the self-registration process does not fail.
I can register it fine manually with regsvr32 but I do not want to manually
register it. Is there any way around this or do I have to manually register
this?
--
TIA
Altman
VFP9 Tag: Find Tag: 214948
Predict Page Count
When printing out a report, is there a way of counting the pages
before you print them so that you can print something like
Page 1 of 20. page 2 of 20 etc: on each page in the header?
TonySper Tag: Find Tag: 214945
VFP6: open excel file and dump to .dbf
Need to open a spreadsheet (Excel 2k) and dump contents to .dbf file using
VFP6. Pretty generic really, sorry if this request isn't a challenge! Any
sample type code would be appreciated.
- Ben Tag: Find Tag: 214942
Rounding question and trig functions
set decimals to 4
? SIN(1)*COS(1)
0.45464871
? .5*sin(2)
0.45465
VFP rounds the result, but why does the first get rounded to 8 digits, and
the second get rounded to 5? SIN(1)*COS(1) is the same number as .5*sin(2),
but VFP somehow treats the above calculations differently. If I put them in
the watch window, they display the same as what is printed to _screen, with
the same inconsistent rounding. Tag: Find Tag: 214938
sys(1500)
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C5A28A.658070B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am just experimenting with this command. On a form with an editbox and =
a commandbutton I have this code in the commandbutton click()
_CLIPTEXT =3D "Hello world"=20
ThisForm.Edit1.SetFocus()
SYS(1500, '_MED_PASTE', '_MEDIT')
thisform.Refresh()
The first time I click the button the edit cursor appears in the edit =
box but nothing else. Thereafter every time I click the commandbutton, =
the phrase appears as expected in the edit box, concatenating with the =
previous paste..
Can somebody explain why it doesn't appear the first time?
Many thanks
Stephen
------=_NextPart_000_0006_01C5A28A.658070B0
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.2900.2722" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I am just experimenting with this =
command. On a=20
form with an editbox and a commandbutton I have this code in the =
commandbutton=20
click()</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>_CLIPTEXT =3D "Hello world"=20
<BR>ThisForm.Edit1.SetFocus()<BR>SYS(1500, '_MED_PASTE',=20
'_MEDIT')<BR>thisform.Refresh()</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>The first time I click the button the =
edit cursor=20
appears in the edit box but nothing else. Thereafter every time I click =
the=20
commandbutton, the phrase appears as expected in the edit box, =
concatenating=20
with the previous paste..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Can somebody explain why it doesn't =
appear the=20
first time?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0006_01C5A28A.658070B0-- Tag: Find Tag: 214931
Append data into excel file
Dear All,
Do anyone know how to append data into excel file from dbf file.
Thanks for any reply or solution
Choi Tag: Find Tag: 214926
MYSQL Database
Has anyone converted a MySql database to a VFP table? I have a guy who
has his database on MySql and would like me to enter it into a VFP
Database table. I have not looked at it yet so do not know what to
expect. Any ideas??
TonySper Tag: Find Tag: 214922
won't stay docked
every time I open vfp8 I need to uncheck the dockable on all windows. How do
I make it permanent?
thanks
sherry Tag: Find Tag: 214918
Using custom PAGE objects in a custome PAGEFRAME
Hi
I have been reading 1001 Things which seems to mainly reference VFP 6.
I am trying to create a base _PAGE class for use in my base _PAGEFRAME class
with some custom methods and properties.
I can't work out how to trick my _PAGEFRAME to use my _PAGE class rather
than the standard VFP Page object.
In 1001 we are told that you cannot visually create a Page object - clearly
this is no longer the case with VFP 9 so can anyone tell me how i can
implement my visual _PAGE object?
--
Kind regards
Phil Hollingworth
phil@wrltd.co.uk
System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: Find Tag: 214912
Derfining a color Scheme ?
How can I define a Color scheme at runtime based on the color scheme of
certain control ?
Want to have separate values for Red, Green and Black instead of using a
single color value ? Tag: Find Tag: 214908
Custom window Color ?
I want to set the color of a window which is to be determined at run time ..
will be picked from the property of a color ? Don't know how to set it up
like this ? Tag: Find Tag: 214905
Define a Window with Custom Color ?
I want to define a window which should borrow a color from another controls
Back Color Property to be determined at run time ? Not aware how to set it
up ?
Urgent pls help ? Tag: Find Tag: 214904
Statusbar Color Scheme ?
Can anybody tell me what color scheme is used by the VFP 8.0 StatusBar ?
I want to use my own status bar but with the same color scheme as being used
by the VFP StatusBar. My Statusbar control will appear in only selected
segments of the application. Tag: Find Tag: 214903
Protecting your code
Hi,
How to protect your code when distributing class libraries (vcx) and
Databases. How to stop some customer to make "improvements" to your stored
procedures? I do not want to include the Databases and or class libraries in
the project(s) as some of the libraries are shared by multiple APP/EXE and
the Databases need to change depending on customer needs (like for example
adding a new index to a table or to repair indexes and reestablish
relations). Is there a way to make the source code (equivalent to a prg)
disappear? Tag: Find Tag: 214891
Menu Path solve
Taking the "IN LOCFILE(.....) portion out of the menu generator allows
menues truely to be integrated in APP/EXE files. With the standard menu
generator you will have to include the menu.mpx in the original location
which also does not allow to make a true setup where the enduser selects the
destination directory.
Scenario.
app directory: F:\myproject
source fiels: F:\myproject\source
The menu on the developing machine with the other SCX and prg is in the
source directory.
Running the "standard" Menu generator will generate some code like
ON SELECTION PAD _1hv06ai6t OF (m.cMenuName) ;
DO _1hv06ai6u ;
IN LOCFILE("\Myproject\sourc\MyMENU" ,"MPX;MPR|FXP;PRG" ,"WHERE is MyMENU?")
Now if on the destination machine there is no directory Myproject\source
then the above menu code will popup that file selection box asking for the
MyMENU even though the menu had been included in the project and compiled
into the app file and had been already executed with the "DO Mymenu.mpr
....." Command earlier in the code.
Changing the code to
ON SELECTION PAD _1hv06ai6t OF (m.cMenuName) ;
DO _1hv06ai6u
- ommitting the LOCFILE part will work and resolve the above problem. Tag: Find Tag: 214890
True case structure of file path?
Hi. Believe it or not, I'm using Visual FoxPro to generate JavaScript
code. This code references images found on a web site. Problem. The
server must be case sensitive. In other words, if I generate [./ygl
casket offerings/metal caskets/premier
metals/pharaohfrontppt_thumb.jpg], I get file not found. I need to
generate [/YGL Casket Offerings/Metal Caskets/Premier
Metals/PharaohFrontPPT_thumb.jpg].
Is there a function or utility that will retrieve the true case
structure of a given file and it's path? The only other option is to
convert all files and folders to lowercase before publishing them in
Frontpage.
Any advice would be really appreciated...Dennis Tag: Find Tag: 214885
How to kill a process?
This is a multi-part message in MIME format.
------=_NextPart_000_0036_01C5A18A.6426CB70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I want to be able to kill a process that is running (W2K or XP). I know =
I saw a Win API call for this, but can't find it now.
------=_NextPart_000_0036_01C5A18A.6426CB70
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.2900.2668" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I want to be able to kill a process =
that is running=20
(W2K or XP). I know I saw a Win API call for this, but can't find it=20
now.</FONT></DIV></BODY></HTML>
------=_NextPart_000_0036_01C5A18A.6426CB70-- Tag: Find Tag: 214880
Serial Port.
Hi,
I am supposed to interface with the serial port (RS232) from a VFP9.0 app.
Need to send. receive set baud rate etc.
Now I have not done that since DOS 5.0 (guess I am old). So any libraries,
OCXs, controls to do that
TIA Tag: Find Tag: 214865
Foxpro 8.0 can't find network printer
I'm running Foxpro 8.0 and a wired ethernet network.
setting my printer like this:
set printer to \\pos1\receipt1
everything works fine until I turn on my DSL modem which is attatched to the
USB port.
Then foxpro can't find the network printer. After about 3 mintues it
finally finds the printer. If I cut the modem off, foxpro immediately finds
the modem.
Any ideas will be appreciated!
John Tag: Find Tag: 214863
Quiting Programs
Im using an external command in visual foxpro, the problem is that the
external program does not quit or exit when i quit my program in visual foxpro
this is the command is used : 'RUN /N7 psc.exe'
any idea....
thanks
gernan Tag: Find Tag: 214860
Need help! Need older version of FoxPro and/or help.
I was a database developer using FoxPro back in the early to mid 90s. (I
cannot remember which version we used.) I have not touched FoxPro since 95
and do not have the program or manuals from what ever version that may have
been. I got Visual FoxPro version 8.0 a couple of years ago and I'm just now
trying to get into it. I have to say I don't like it a bit! I was very
comfortable with the older environment where all the code was written out in
command files, except for reports and forms. The help file in version 8.0
does not include enough of the old commands and syntax for me to develop my
program command files. I also do not like the form and report generators.
I am not writing just to complain, rather I would like some help to see if
any of you would know what version was used 10 years ago and if anyone has an
old copy they would part with. I really need the help file! I know I should
learn the newer version, but I'm just an old dog. Does anyone have any ideas?
I would kill for all of my old source code, but that belonged to the company
which was sold in 95.
Thank you,
Doug Maples
-------------------------------------------------------------------------------- Tag: Find Tag: 214855
Resolving Path
I got a form class with the following custom properties
menu - which contains the menu name for the form
defpopup - which contains the default popup to get opened on the form
This is the code in the init snipped
DO (THIS.MENU) WITH THIS, THIS.TAG
IF TYPE("THIS.DefPopup") = "C" AND !EMPTY(THIS.DefPopup) AND
POPUP(THIS.DefPopup)
ACTIVATE POPUP (THIS.DefPopup) NOWAIT
ENDIF
etc. etc
Works great - only problem is that when I distribute the app only I also got
to distribute the mpx or I get an error - Now the menu is included in the
project and the command DO (THIS.menu).... works fine - so in this case it
can find the menu inside the app/exe files only if the mpx is missing the
command ACTIVATE POPUP ... will open up a window looking for the mpx.
Any way to avoid that?
Also same seems to be true for frx files. REPRORT FORM (lc_reportname) will
look on the disk and not inside the app where the report is located.
TIA Tag: Find Tag: 214847
push char into Windows keyboard buffer
I don't know Visual C++ so I was planning to do it with Foxpro.
How could I [rogrammatically push key into the Windows buffer (so that
another app that's in focus would get it)?
Is it as simple as calling the right Win32API? Which one?
--
.~. Might, Courage, Vision. http://www.linux-sxs.org
/ v \
/( _ )\ Linux 2.4.31
^ ^ 11:24pm up 6 days 10:52 load average: 1.12 1.25 2.13 Tag: Find Tag: 214843
Exchange GUI/Service Interface Architecture
Does anyone know if the Exchange GUI/Service interface is based on SNMP or
some other standard? We have a Visual FoxPro application that we want to
turn into a service and are looking at different ways to implement the GUI
interface to the service. We want similar results to how Exchange works: it
runs as a service, or a as several services, but you can launch a GUI to get
information about it and administer it. Is SNMP an appropriate choice for
this sort of interface? Any pointers along these lines would be greatly
appreciated. Thanks! -- tom c Tag: Find Tag: 214842
VFP6: SQL deadlock (1526)
Still having a problem with inadvertent SQL deadlocks when I use my remote
view. Can't nail down when/why. Is there any way to set the view read-only
or prevent the deadlock with another SQL process? Or, what would be the
best way to handle when I encounter this? Right now the program just stops.
Thanks in advance for any advice.
- Ben Tag: Find Tag: 214816
How to determine if an index tag exists
Is there any way to determine if a specified index tag exists for any given
alias?
I have looked at KEYMATCH() but this needs you to know the index number.
--
Kind regards
Phil Hollingworth
phil@wrltd.co.uk
System spec: Win2k3 / VFP 9 (All fully service packed / updated etc) Tag: Find Tag: 214810
specifying format in SQL
Hello and thanks in advance for the help.
How do you specify the format of a field in and SQL query?
Example:
I have a field called OPEN_BAL which is N (9,2). All values are > 0.
I have another field called TRAN_TYPE which is C(1) and can have the value
'D' or 'C'
For reporting purposes I need the 'C' types to subtract so I have a query:
SELECT IIF(TRAN_TYPE = 'C', OPEN_BAL * -1, OPEN_BAL) AS OPEN_BAL....
This works fine except that the resulting field size in the query output is
9,2. If OPEN_BAL happens to be > 100,000.00 (example 123,456.78) the value
will be -123,456.7.
I need to tell the query to have the resulting field be N (10,2) so that it
can accomodate the possible 6 digit number without losing a digit. Can
someone tell me what I have to do to make this happen?
Thanks,
Jeff Tag: Find Tag: 214809
I most often use the "All objects" on Find. Is there any way to make that
the default instead of the current procedure?
Cowboy,
None that I've read about or found, but that's not to say there isn't one!
Rick
"Cowboy" <Cowboy@discussions.microsoft.com> wrote in message
news:634CFBFD-C03F-4C9F-B754-E8A7ABECBC8C@microsoft.com...
>I most often use the "All objects" on Find. Is there any way to make that
> the default instead of the current procedure?
>
> TIA