Report Amount format Q.
How in a report can I format a negative amount to be in parentheses?
ie: -100.00 to (100.00)
Your help is greatly appreciated.
Respectfully,
Jonathan Morningstar
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Sedna, du nouveau... Tag: 224160
uncommitted change
Dear Sir/ Madam,
I created a form and press a button with the command to operate the Edit
mode. While I made amendment on a field (e.g. apple) of one of the records
from the table, says abc.dbf, then when I close the edit mode, it¡¦s okay;
but when I close the form with the button mentioned above, the error message
was shown:
=CursorSetProp(¡§buffering¡¨,THIS oldBuffering,aTablesUsed[m.i,1])
&&optimistic table buffering
Error 1545
Table buffer for alias ¡§abc.dbf¡¨ contains uncommitted changes.
Method: destroy
Line: 68
How can I solve this with my scenario??
Thank you for your kind attention!!
Patrick Tag: Sedna, du nouveau... Tag: 224159
Art Bergquist will speak at ChicagoFUDG on June 13
Chicago is one of the stops on Art Berquist's 2006 Lake Michigan tour. On
June 13 he will be speaking on "Highly Effective Habits for VFP Developers."
It promises to be a great overview of the best tricks, practices, and tips in
programming techniques from a man who spends every working day in the VFP
trenches.
Art Bergquist is a Senior Consultant at Visionpace, and has extensive
experience working on numerous Visual Maxframe Professional applications both
as the sole developer and on a team. Art has contributed many VMP features
and enhancements, is currently maintaining the framework, and frequently
mentors developers at Visionpace and it's clients.
He has also authored articles and tips in FoxTalk and FoxPro Advisor
magazines (and has tech-edited articles for FoxPro Advisor), and has been a
presenter at the San Diego and Orange County FoxPro Groups, as well as at
Essential Fox, and has taught MaxStart sessions and VMP Boot Camp.
Join us on June 13, 2006 at 53 W. Jackson Blvd., Suite 826 in Chicago's
famous Loop. The door opens at 5:30pm.
http://www.ChicagoFUDG.com
Next month: Reserve July 11, 2006 to hear John Koziol on Sedna at CFUDG.
--
Message posted via http://www.dbmonster.com Tag: Sedna, du nouveau... Tag: 224158
Sedna June 2006 CTP posted
From http://msdn.microsoft.com/vfoxpro/letters/, by Milind Lele
Sedna June 2006 CTP
We have released the second CTP (Community Technology Preview) of Sedna. The
June 2006 CTP includes latest builds of NET4COM and MY library for VFP.
NET4COM is a library of COM wrappers around commonly used functionality from
the .NET Framework 2.0. This allows these API to be called from Visual
FoxPro. The library also includes source code and samples. The MY namespace
is a native Visual FoxPro class library that contains similar wrappers for
SYS() functions, Windows API and Windows Script Host properties and methods.
The idea is to make a select few commonly used API accessible in a form that
is easy to discover and navigate. ......
--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@cindywinegarden.com Tag: Sedna, du nouveau... Tag: 224157
Obscure DOS path
I am working in an old FPDOS application, and I see references like this:
DO C:\#@1)0~!_\myprog.prg
Can anyone tell me the signficance of that bizarre-looking path? Tag: Sedna, du nouveau... Tag: 224151
opening cash registers
How in VFP 6 do I issue a command to open a paralell, serial or USB cash
register?
R Gallo
OGES Systems Tag: Sedna, du nouveau... Tag: 224135
doEvents
Does anyone know of a better method than fastDoEvents() to get the DOEVENTS
command to process correctly? I am running with VFP 8 and even with using
the FORCE option I am still having problems when embedding the webbrowser
control onto forms. Essentially the system will do nothing until I move the
mouse around which I think forces the events to fire. Tag: Sedna, du nouveau... Tag: 224123
VFP 9 Report Designer
Is it only my machine, or has anybody else experienced this. (using
reportlisteners to preview/print ),
The labels keep disappearing in Preview
I have to include the table in the Datasession window, even though it is in
the DE, to be able to pick fields from the Expression builder.
Deleting an object refreshes the whole screen
When doing multiple bands, the tables have to be related, even though the
form calling the report has the initial table with corresponding paramatized
view open. Only tables and no views in my experience... The bands have the
view name in quotes as target aliases Get an error ".... is not related...".
Cannot figure out "commandclauses". Listeners do not respect While or For
clauses of the Report Form, Need to print only one parent record with
multiple child records in 5 paramatized views.
Kludgy as hell
Sending email using successor listeners is erratic, on some machines it
works perfect others the html report is out of whack Lines and labels not
properly sized etc.
All examples and the Pundits make a big deal about conditional
formatting...cutesy red and blues etc... In the real world who gives a S....
I would rather be able to control output without having to write a
convoluted program
Wondering if its worth it. Why not make the report designer like a form, its
kinda the same principle, both with a table in the backend.. Just drop
classes, controls etc.. Now in this crazy world of specialists, a new breed
of Report specialists is all we need. Tag: Sedna, du nouveau... Tag: 224106
Outlook Email Automation
I am trying to write an unattended email module for sending out notices
using a timer based on certain conditions.
I'm using Outlook 2002 SP2 and VFP9.0 SP1 and outlook redemption v4.1 to
bypass the security check. All my emails keep getting routed back to my
inbox as "Not Sent".
I have tried the below code and MANY other iterations, with no success.
There has to be a better way! Is there another solution? Am I missing
something in Redemption?
loOutLook=CreateObject("Outlook.Application")
loRedemption=CreateObject("Redemption.SafeMailItem") && Create an instance
of Redemption.SafeMailItem
loMailItem=loOutlook.CreateItem(0) && Creates a new message
loRedemption.Item=loMailItem && set Item property
loRedemption.Recipients.Add("name@server.com")
loRedemption.Recipients.ResolveAll
loRedemption.Subject="Testing Redemption"
loRedemption.Body="This is the test for the Redemption.Dll"
loRedemption.Send
loRedemption=.NULL.
loOutlook=.NULL.
RELEASE loOutLook,loRedemption
HELP!
Tim Cairns Tag: Sedna, du nouveau... Tag: 224094
something similar to shortname function in filesystemobject
I have got a table of items, and I need to produce a unique but recognisable
8-character descriptor for each one. The problem is that the items might be
so similar that the first 8 characters are the same. Is there a way of
generating a 8-character descriptor like this. I am imagining something
similar to the shortname function in filesystemobject to get a result like
this:
Widgets white (Widget~1)
Widgets black (Widget~2)
Acme (Acme)
General (General)
Grommets small (Gromme~1)
Grommets large (Gromme~2)
etc
Many thanks
Stephen Tag: Sedna, du nouveau... Tag: 224091
vfp Outlook Automation
Hi,
Using VFP 8, I can create an email in Outlook 2003
However, I have multiple email accounts in my Outlook 2003 How can I
programmatically tell outlook which email account is to be used for sending
the mail?
Thanks in Advance
Mahmud Abdulla Tag: Sedna, du nouveau... Tag: 224084
shortcutmenu alignment
Hi,
How can i align a menuitem in a shortcutmenu ?
Cut (Ctrl+X)
Copy (Ctrl+C)
....
so it is possitioned on the left and rightside of the menu.
Kind Regards
christophe Tag: Sedna, du nouveau... Tag: 224081
DO MyMenu.mpr With myparameter ?
Hi,
DO MyMenu.mpr With myparameter,
Where are the parameters send to
when I've create the shortcutmenu with the menudesigner ?
Or where should I place "LParameters myparameter" in ?
Or is the With not used when I call a shortcutmenu.
I have a textbox with a Rclick event which activates a shortcutmenu.
and whould like to send the objectreference for that textbox to it
so I can alter the textbox upon the users menuselection.
Or is there maybe a workaround ?
What I do now is a bunch o _screen.activeform.activecontrol
but when the textbox is in a grid that is not very usefull.
regards
christophe
--
Regards
christophe Tag: Sedna, du nouveau... Tag: 224077
screensavers
Is it possible to create a screensaver using vfp 8 and if so can anyone
point me in the direction of some sample code
Thanks in advance
Dave Tag: Sedna, du nouveau... Tag: 224075
ComboBox and column
I have ComboBox with ColumnWidths = '220,0' ( I want to hide second column)
When list drops there is second column with no data in and with width about
the width of scrollbars. How to remove second column. Tag: Sedna, du nouveau... Tag: 224074
Input field name (VFP9)
I need to let the user suggest a field name for a free table. I use
chrtran(cInputval, cCrapCharacters, "") to remove illegal characters. I feel
that this way of doing it is a bit "home made". Is there any other good way
to do it? Tag: Sedna, du nouveau... Tag: 224072
FoxPro and MySQL field size does not match
Hi everybody,
I am connecting via ODBC and sqlstringconnect to a MySQL server. Let's
assum I have a numeric field named my_id with length 3 defined in the
MySQL table "test_table". After connecting and doing a SQLExec "select
my_id from test_table" the resulting FoxPro table will have a field
length of 11 for the field my_id. That causes problems when displaying
the no in a combo box. What's wrong here?
Thanks for your help
Andi Tag: Sedna, du nouveau... Tag: 224067
Local view and buffered table
Hi all,
Can I get data in local view from buffered table?
In sample SELECT I can use WITH (BUFFERING=.T.), but I don't find way use
something similiar with local views.
Meskis Tag: Sedna, du nouveau... Tag: 224048
Test a SQLSTRINGCONNECT() connection handle
This is a multi-part message in MIME format.
------=_NextPart_000_005F_01C6856E.9336B290
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all,
I create a Shared Connection Handle to MySQL using SQLSTRINGCONNECT()and =
saved in a _SCREEN property, so far so good, in other parts of the =
application I would like to test if this Handle is still a valid one, I =
could not find a function that will allow me to do just that, then here =
is the question: =20
What would be the way to test if my _SCREEN property for the =
connection handle is still a valid one?
Thanks!
--=20
Edhy Rijo
www.progytech.com
Bronx NY
------=_NextPart_000_005F_01C6856E.9336B290
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.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I create a Shared Connection Handle to=20
MySQL using <FONT face=3D"Courier New" color=3D#0000ff=20
size=3D2>SQLSTRINGCONNECT</FONT><FONT face=3D"Courier New"=20
size=3D2>()</FONT></FONT><FONT face=3DArial size=3D2>and saved in a =
_SCREEN property,=20
so far so good, in other parts of the application I would =
like to=20
test if this Handle is still a valid one, I could not find a function =
that will=20
allow me to do just that, then here is the question: </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2> What would be the =
way to test if=20
my _SCREEN property for the connection handle is still a valid =
one?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks!</DIV>
<DIV><BR>-- <BR>Edhy Rijo<BR><A=20
href=3D"http://www.progytech.com">www.progytech.com</A><BR>Bronx =
NY</DIV>
<DIV> </DIV>
<DIV></FONT> </DIV></BODY></HTML>
------=_NextPart_000_005F_01C6856E.9336B290-- Tag: Sedna, du nouveau... Tag: 224046
Foxpro to VFP6
I have a number of source code applications in Foxpro 1. I purchased
VFP6 when it was then offered, but I have not yet updated my old
applications. A few questions:
1 - Does VFP6 have a separate runtime for inclusion with client
applications?
2 - Should I update to VFP9, or would my current 6 be easier for me to
re-code, since my programming skills still are back there with Foxpro
1?
Thanks in advance. Tag: Sedna, du nouveau... Tag: 224039
time function
Hi all,
What is the best way to define a field in a table to contain Time? should
it be a character or datetime?
also, once it is defined in a table, how is best to utilize that field in a
form? like what input mask should it have and how do you stop the user from
entering an invalid time?
Is there a control (or does anyone have one?) that could be dropped on a
form that is already validated as a time field?
Thanks
HME
--
---------------------------------------------------------------------
"Are you still wasting your time with spam?...
There is a solution!"
Protected by GIANT Company's Spam Inspector
The most powerful anti-spam software available.
http://mail.spaminspector.com Tag: Sedna, du nouveau... Tag: 224033
finding procedures in a procedure file
I came across some odd behavior today, and would appreciate feedback
on this. To demonstrate the issue, create two files:
File 1: zoot.prg
Procedure zoot
=zoot1()
set procedure to
=zoot1a()
return
File 2: zoot1.prg
PROCEDURE zoot1
WAIT WIND `ZOOT1' TIME 1
RETURN
PROCEDURE ZOOT1A
WAIT WIND `ZOOT1A' TIME 1
RETURN
Then in the command windows, DO ZOOT. It does the zoot1 wait window as
expected. Surprisingly, it also does the zoot1a wait window. Why? I
added the SET PROCEDURE TO line to clear any open procedure files,
thinking that DOing zoot1 did an implicit SET PROC TO ZOOT1, but it
still works. CLEAR PROGRAM stops it from working. Is this an undocumented
feature? I was not aware that DOing a PRG file would load make all
procedures in the PRG available, even after the top level procedure was
exited, and therefore no longer in the call stack.
We also discovered that suspending VFP would clear it from memory, as if VFP
arbitrarily clears such stuff when it wants to or thinks it needs to. Tag: Sedna, du nouveau... Tag: 224031
Chado spell editor and mailmerge
A post elsewhere had me asking about recordsets for use with Chado spell
Editor, which now works.
However mailmerging with the Chado spell-editor is proving rather
troublesome, and whilst their help file is good, it doesn't cover vfp
<sigh>.
Has anybody done mailmerging with the recent Chado SpellEditor and could
they give some pointers as to how to actually merge and print.
Many thanks
Stephen Tag: Sedna, du nouveau... Tag: 224024
VFP and ADO.NET
I'm wondering if anyone has come up with a way yet to load ADO.NET data into
a read/write BROWSE window.
Thanks ahead for any leads. Tag: Sedna, du nouveau... Tag: 224012
ADO recordset
This is a multi-part message in MIME format.
------=_NextPart_000_000E_01C6840F.7BBD7EB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
This is a completely new area for me. I am looking at the Chado spell =
editor, which now has mailmerge - great! However the reply to a query to =
Chado states:
Unfortunately, you have to use an ADO recordset in order to have =
mailmerge work properly.
What I have got in my application is a temporary cursor called CUSTOMER =
from which I want to do the mailmerge.
Could somebody handhold me through the commands I need to issue to get =
an ADO recordset from this.
Many thanks
Stephen
=20
------=_NextPart_000_000E_01C6840F.7BBD7EB0
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.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>This is a completely new area for me. I =
am looking=20
at the Chado spell editor, which now has mailmerge - great! However the =
reply to=20
a query to Chado states:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>Unfortunately, you have to use an ADO recordset in order to have =
mailmerge=20
work properly.<BR></DIV>
<DIV><FONT face=3DArial size=3D2>What I have got in my application is=20
a temporary cursor called CUSTOMER from which I want to do the=20
mailmerge.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Could somebody handhold me through the =
commands I=20
need to issue to get an ADO recordset from this.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Many thanks</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Stephen</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_000E_01C6840F.7BBD7EB0-- Tag: Sedna, du nouveau... Tag: 224005
Timer/Interval Q.
Is there a Interval amount that cuts a timer off? Does 0 cut it off?
Respectfully,
Jonathan Morningstar
----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =---- Tag: Sedna, du nouveau... Tag: 224001
Strange printing with reportBehavior to 90
In VFP 9 SP1, i've an invoice report containing
- title
- header
- group header
- 1 detail band
- group footer (with new page)
- page footer
- summary (with new page)
When i print it with reportBehavior set to 80, it works fine. (It works for
many years !)
When i print it with reportBehavior set to 90
- page 1 is correct
- page 2 to n-1 have a blank space above (+- 5 cm) and the content seems to
be vertically condensed
- last page is correct
There is no special code in the reportListener. Just created from the base
class (VFP ReportListener, not the FCC)
Any idea or tool to solve this problem.
Thanks in advance,
Guy Tag: Sedna, du nouveau... Tag: 223998
Which one is better option ?
I am using Visual Foxpro 8.0. In my application i have two panes, on left
pane i have product categories and on right pane respective products are
being shown.
Currently i am using FILTER command to show respective items. But it is
getting slow and slow as data is increasing. Right now i have more than
10,000 records in products table and system is not responding quick enough.
There is another way to do same job using INDEX command with FOR condition.
Before going in any optimization work, i would like to have your expert
opinion which option can work better for such kind of requirements. OR any
other new suggestion.
Thanks in advance.
NR Tag: Sedna, du nouveau... Tag: 223992
New VFP multi-threading example posted
I've updated the VFP MT example (at http://codegallery.gotdotnet.com/SednaY)
based on Calvin's example to be sort of like .NET:
Example Use:
* t=CREATEOBJECT('testserver.thread')
* t.start(5,"do c:\MTmyVFP\MyThreadFunc WITH p2")
* && start method params:(1)#threads,(2)VFP code to MT,(3)Silent mode
* ?t.check && returns .T. if completed
* t=null && cleanup
Simple, fast, efficient - it is VFP!! And, yes, it's really
multi-threaded... Tag: Sedna, du nouveau... Tag: 223991
Inserting a page in a report - VFP 9.0
Hello,
Within a VFP 9.0 report, i would like to insert a blank page between page 1
and 2, if the total number of pages of my report is uneven.
Would be perhaps possible with the new reportListener object. But i don't
see where to start.
Thanks in advance for help,
Regards,
Guy Tag: Sedna, du nouveau... Tag: 223990
Items color in listbox
Is there any way to have different colors for items in listbox (I want to
have some items green, some red, some blue) Tag: Sedna, du nouveau... Tag: 223987
Opening Cursor
aychee wrote:
> *Re the above:
> Forgive my stupidity it is the Hand_cursor I get not the wait_cursor
> - the latter would be tolerable *
Further stupidity (senility?) -I'm in the wrong forum. Trying to delete
--
aychee
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: Sedna, du nouveau... Tag: 223983
Can I develop the VFP project in Pocket PC?
I need to develop an application which can be run in Pocket PC and Windows
Mobile 5.0. I have VFP8 on hand. I want to ask whether I can develop or
not? If yes, how to do?
Thanks for your help! Tag: Sedna, du nouveau... Tag: 223976
Connecting to remote VFP database using ASP
We are having a difficult time connecting to a Visual Foxpro database located
on a remote server using ASP.
It is a security issue because the web application can connect if the
database is located locally on the web server. When we point to the remote
database and run the code, the application cannot find the location.
We tried everything in the Microsoft KB article located at:
http://support.microsoft.com/kb/175801/en-us
but nothing seems to help. Our connection is through an ODBC System DSN that
uses a UNC path to the remote database.
Any advise or help would be appreciated. Tag: Sedna, du nouveau... Tag: 223966
Copying a Database (DBC)
Is there a trick to copy a database from one directory to another?
I am trying to set up a test area for a system on my computer. I have
duplicated the file structure for the drive on which the DBC is
located. I have copied the files for the database and the tables in
the database. I have used the SUBST command to map part of my drive to
the same drive letter as the DBC is expecting. But it doesn't work.
The Validate database command shows errors for just about every table
in the database. For most files it says: "Table is not in a database."
If I use modify database and then click on a table, it says "Cannot
resolve backlink."
Is there anything I can do short of recreating the whole database from
scratch?
Kevin Clark
Seton Home Study School Tag: Sedna, du nouveau... Tag: 223959
Converting to pdf
I use XFRX to convert VFP reports to PDF. I want to append my report to a
previously existing pdf file, and I have been told that in order to merge,
the original document must NOT be LINEARIZED. Does anybody know how can I
generate a non linearized pdf document from Word ? Tag: Sedna, du nouveau... Tag: 223947
hierarchical grid
Hi,
Can anyone recommend a hierarchical grid control to use with VFP?
Preferably one that can bind to an ADO recordset (I assume none will use a
VFP view).
Thanks.
Yours faithfully
Paul S. Elliott
(Senior Developer)
4technology Ltd
P.O. Box 1681
Christchurch
New Zealand
ph : +64 3 3771170
fax : +64 3 3771172 Tag: Sedna, du nouveau... Tag: 223936
File is not open
One of my client is using English version windows XP ,when she run one
Invoice form (it will show File is not open)
The application is placed in the server, the PC will create a shortcut and
run that application .
When she run the application in Chinese version windows XP , everyting work
fines.
I am using visual foxpro 6.0 (English verison) to complie . (All chinese
version window XP can run it very well)
Does anyone know what's wrong it is ?
From Agnes Tag: Sedna, du nouveau... Tag: 223931
VFP6: Getting Lousy Output
I have a dot-matrix printer that I use for Q&D output. When I
print from DOS programs, it works great and spits out the output
quickly. When I print from VFP (or any other Windows app), it insists
on making it better quality. This takes several times longer. How do
I set the printer driver to give me low-quality (and fast) output?
Sincerely,
Gene Wirchenko Tag: Sedna, du nouveau... Tag: 223930
Application based authentication
Hi,
I'm sure I've read about this before somewhere, but may have dreamed it.
Is there a way to allow a user to run an app, but give read/write/modify
permissions to the app instead of the user. That way the user can access the
data but only via the app. I know I can effectively do this locking down
with group policy, but I have some very awkward accountants in at the
moment. They're all security expert<s> these days.
Thanks,
Neil Tag: Sedna, du nouveau... Tag: 223922
Foxpro 2.6 Error 1104
Hello Everyone,
I've been searching through all of the posts here about error 1104 and
can't seem to find a solution that has worked for us. First off, we
are not using Terminal Services or Citrix. The apps are being run on
each local machine, accessing data files on a Windows 2003 server. The
network is mostly gigabit with a few of the machines still using 10/100
cards. So far we have tried the following:
- Disabling antivirus on both server and workstation
- Disabling all automated backups
- Changed from Foxpro 2.5 to Foxpro 2.6
- Set CATMAN = OFF
We have an error control program that is currently working around the
problem, but it is more of a band-aid as opposed to actually fixing the
problem. Whenever the 1104 occurs, the error control program logs it
to an error file and then tries again. The second try has worked every
time. Lately, the error occurs mostly on the SEEK command, but has
occured during the USE, APPE, GO, and SKIP commands in the past.
We changed one of the apps so that instead of using a CDX file, it uses
an IDX file. We have not had an error with that program since then.
We ran a simple disk check on the server and did not find any errors,
but we have not had a chance to run a more in depth disk scan due to
the number of users that are dependant on using the data.
We have checked the cables and NICs, recrimped cable ends, etc and we
can't seem to find any problems with any of the hardware, but we
haven't ruled it out completely.
If anyone has any ideas, we are open to all suggestions. Any and all
ideas are welcome.
Thanks,
Ben Jitima
bjitima@gmail.com
(304) 525-3293 Tag: Sedna, du nouveau... Tag: 223914
Linked Server VFP, error OLE DB
Hi,
SQLExpress on Windows XP SP2, authentification mode Windows
I trie to link a Visual FoxPro database with OLEDB provider (yet installed)
That query :
EXEC master.dbo.sp_addlinkedserver
@server = N'MyLinkedServer',
@srvproduct=N'Visual FoxPro 9',
@provider=N'VFPOLEDB',
@datasrc=N'"C:\MyPath\MyDirectory\"',
@provstr=N'VFPOLEDB.1'
works fine (no error)
but that one : select * from MyLinkedServer...MyTable return following error
message:
Cannot create an instance of OLE DB provider VFPOLEDB for linked server
"MyLinkedServer".
What's wrong ? Tag: Sedna, du nouveau... Tag: 223912
Cheap OLE DB tool for dbc/dbf access?
Any suggestions on available tools (free, cheap, common) which can open
VFP8/9 dbc tables and issue DDL statements (alter table stuff...) SQL
Queries, execute stored procs etc....
I'd like to have a few options to give to our customers who don't have VFP,
and I'd rather not provide an interface myself.
Thx.
--
William Fields
Code Contortionist
MCSD - Microsoft Visual FoxPro
US Bankruptcy Court
Phoenix, AZ
".dll hell - .rpm hell - whatever.
The grass is always greener" Tag: Sedna, du nouveau... Tag: 223911
Issues with menus
Hi,
Running VFP 9.0, trying add a menu to my application. I have created the
menu, added three pull down items, File, Reports and Help. In the File menu
I put a Close option to exit the application. Here's the setup:
Prompt: \<File
Result: Submenu
Options:
Key Label: ALT+F
Key Text: ALT+F
Container: Left
Object: None
Pad Name: File
Menu Level: File
Prompt: \<Close
Result: Bar# _mfi_quit
Options:
Key Label: CTRL+F4
Key Text: CTRL+F4
Skip For: .F. (I tried leaving this blank originally, same result either
way.)
Resource: _mfi_close (I tried _mfi_exit too, didn't work either.)
Also, in the general options for the menu I turned on Top-Level Form.
In the Init() of my form I have: DO menus\mainmenu.mpr WITH THIS, .F.
(Tried .T. too)
Form.ShowWindow = 2 - As Top-Level Form.
When I run my application the menu appears like I expected except the Close
option is greyed out. I can't seem to find any property settings to adjust
this, any ideas? Is this the default state of a menu option and do I have
to control that in code somehow at run time?
All I'm trying to do at this point is be able to exit the application. The
other thing I want to do is include an About item in the Help menu, what's
the best way to do this and be able to display the version number of my
application, not just the version of VFP? Beyond that I'll want to add some
items for reports but I suspect those will be easy once I understand these
first issues better.
Thanks in advance,
Linn Tag: Sedna, du nouveau... Tag: 223905
Opening Cursor
My applets irritatingly open with a Wait_Cursor and a tool tip "Click to
activate this control", neither of which is part of the applet. To
activate the applet eg by clicking on a 'Play' button I have to click
twice. The first click just seems to re-position the screen and the
second click initiates the applet correctly.
Am I doing something wrong or is this a feature of Java?
--
aychee
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: Sedna, du nouveau... Tag: 223904
Opening Cursor
aychee wrote:
> *My applets irritatingly open with a Wait_Cursor and a tool tip
> "Click to activate this control", neither of which is part of the
> applet. To activate the applet eg by clicking on a 'Play' button I
> have to click twice. The first click just seems to re-position the
> screen and the second click initiates the applet correctly.
> Am I doing something wrong or is this a feature of Java? *
Re the above:
Forgive my stupidity it is the Hand_cursor I get not the wait_cursor -
the latter would be tolerable
--
aychee
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------ Tag: Sedna, du nouveau... Tag: 223903