System Image List
Is it possible to associate the System Image list with a Treview Control in
VFP?
I've been playing around with Shell_GetImageLists, but no luck so far. Tag: Treeview and System ImageList Tag: 211163
Events at Run time
Dear sirs
I've created in my Form some objects (Buttons) at run time,
the question is: how can I handle their events (Like: Click Event) at run time
best regards
thanks
Mohammed Abdel-Razzak Tag: Treeview and System ImageList Tag: 211161
Problem with ADO.Net
Using VB.net with .Net Framework 1.1 and using Fox Pro OLEDB to connect to a
fox pro database.
When I try to load a dataset from a FoxPro database on the network running
this line of code for path (\\servername\share\data\abc.dbc)
dbAdapter.Fill(dbDs)
I get:
"The provider could not determine the Decimal value. For example, the row
was just created, the default for the Decimal column was not available, and
the consumer had not yet set a new Decimal value."
This code works perfectly on the local copy of the FoxPro Database (example
c:\data\abc.dbc)
any idea why?
The people in dotnet.framework.adonet suggested I post here. Tag: Treeview and System ImageList Tag: 211159
More VFP7 to VFP9 woes
I use the below code to create a background image on a Foxpro app.
This image is always visible in my test environment, but when I run it
on Terminal Services (W2K) in Production, several of my forms clear
this image. What Commands/Functions could possibly clear this image??
This never happened with the app when it was compiled with VFP7.
Thanks for your help
*! Example Code -------
_SCREEN.addobject('logo','image')
WITH _SCREEN.logo
.picture = 'BackGroundImage.jpg'
.width = 220
.height = 160
.backstyle = 1
ENDWITH
= updscreen()
_SCREEN.logo.Visible = .T.
*------------------
PROCEDURE updscreen
*------------------
WITH _SCREEN.logo
.left = (_SCREEN.width-220)/2
.top = (_SCREEN.height-160)/2
ENDWITH
ENDPROC Tag: Treeview and System ImageList Tag: 211155
VFP Based PM (preventative MTC) program for oilfield industry
Does anyone have any first hand experience or recommendation for a program
that would be used in the oilfield or gas industry for tracking and managing
maintenance on field equipment?
Dan Tag: Treeview and System ImageList Tag: 211152
Strange issue importing text file
I am a SQL Server DBA that has a client using FoxPro v8. When the client
imports CSV text with character fields delimited with double-quotes, they
have random records shift from time to time for no apparent reason. The
source records are clean meaning they do not contain commas or double-quotes.
Ironically, the same CSV text file imports into SQL Server, ACCESS and other
databases without any issues. Has anyone else run into this type of
strangeness? How did you resolve it?
Thanks! Tag: Treeview and System ImageList Tag: 211150
SQL SELECT is not executing
VFP 8 SP1 on XP Pro SP1
This is the most bizarre thing I've seen in a long time. I had some
code in a form that constructed a SQL SELECT statement as a string,
then runs the command via macro substituion (&). This was working fine.
I decided to move this code into a class. Now, when the macro
substitution line is executed, nothing happens. Here is the string
that is supposed to be executed:
SELECT Employee_name AS fld1, UPPER(Employee_name), Ssn AS fld2, UPPER(Ssn),
Employee_id AS fld3, UPPER(Employee_id), Dob AS fld4, UPPER(Dob) INTO CURSOR
rptCurs FROM empGrpCurs ORDER BY 2, 4, 6, 8
The source cursor (empGrpCurs) exists and contains data. After
this instruction is executed (or not executed in this case), the
destination cursor (rptCurs) does not exist and _TALLY has not been
updated from the prior value. No error is raised. It's like this
instruction never happened. I then placed the actual SQL SELECT
statement (rather than the macro version) in this same method a
few lines lower and the result was exactly the same - no error,
no cursor created, _TALLY unchanged.
I'm convinced I'm just missing something very obvious, but lack
of sleep must be blinding me.
Any ideas?
-- TRW
_______________________________________
t r w 7
at
i x dot n e t c o m dot c o m
_______________________________________ Tag: Treeview and System ImageList Tag: 211128
VFP 9, Class definition is cyclical error
Have a container-class which contains two custom-class pageframes, one is
placed on the others page.
inputctrl1 <or one of its members>. Parent : Error loading file - record
number 1976. FWPAGEFRAME_B1 <or one of its members>. Parent : Cannot add
FWPAGEFRAME_B1. Class definition is cyclical
This error occurs when running the application, not during class editing.
With only one instance of the pageframe class in the container-class the
application runs fine. It also works if the second pageframe is not placed
on the other pageframe's page.
As far as I can tell this does not match:
"You have attempted to specify a class in an ADD OBJECT statement whose
class definition is the same as the class being defined. "
Any idea's ?
TIA
Michael S. J. Tag: Treeview and System ImageList Tag: 211100
Printing a BMP bitmap
Hello all and thanks in advance for the help.
How do you print a bitmap where the bitmap that you will be printing is to
be decided at runtime? Can you use the VFP report writer? Is there another
way? Thanks.
Jeff Tag: Treeview and System ImageList Tag: 211093
Convert 3.0 resource file format to 6.0
I have a VFP8 exe file which runs every night on two separeted Win2003 servers.
One of them is OK. The other sometimes /not every time/ stops and there is
the following question on the screen:
Convert 3.0 resource file format to 6.0? /YES or NO/
Could anyone explain me why do I have this message?
Many thanks
--
Sandor Tag: Treeview and System ImageList Tag: 211090
Frontpage Automation - Help
I need to automate FrontPage to update a website i.e. to publish it.
How does on do this from within VFP? Some Code Samples would be help
Thanks in Advance
Regards
Mahmud Abdulla Tag: Treeview and System ImageList Tag: 211087
dbf to excell
Can I export a large dbf to excell to use multiple worksheets in excell.
The file is to large for only 1 worksheet.
thanks
sherry Tag: Treeview and System ImageList Tag: 211085
Consuming a dataset in a web service
I have successfully consumed an XML from a web service from VFP8. Now
I need to consume a dataset in a web service.
Can someone point me in the right direction? I've been searching
Microsoft site but nothing pops up.
Thanks, Tag: Treeview and System ImageList Tag: 211079
accessing VFP data for ASP.net pages
We had (gone now) a developer who wanted to have access to our VFP tables
(several hundred mb worth) for "live" queries on a low-traffic web site.
His solution, doing all his development in ASP.net, was to create duplicate
tables on an SQL server and import the VFP data on a schedule which allowed
as up-to-date data for the queries as was possible (perhaps every 15
minutes, but no less than once an hour).
I objected to this scheme as being inefficient in that it moved many
thousands of times the amount of needed data across our various links (a
shared 10 mb pipe to the web server was the bottleneck), when he could have
accessed the data directly from ASP.net using OLEDB.
His only point was that this allowed him to use SQL stored procedures.
Can anyone give opinions on the pros and cons of these 2 approaches?
Thanks. Tag: Treeview and System ImageList Tag: 211077
How to dial a phone number from VFP?
Hi All,
Does anybody have a sample code for using a telephiony API from VFP?
Where can I find the examples on how to implement auto-dialing from VFP
application?
Thanks,
Andy Tag: Treeview and System ImageList Tag: 211073
using controls in grid causes problem
i am using combo1 that contain faculty,student,staff as combo1 items....
according to i choose the item in combo1 the grid is displayed..... i have
insert checkbox1 and combo2 in the grid also...... the combo1 and the grid
is in the same form.......initials the grid is set as visible false....
now when i run the form it shows the controls (checkbox1 and combo2) in the
grid for frist selection but when i switch the selection in combo1
it does not shows the controls in the grid..........
i have tried
thisform.grid.refresh
thisform.grid.column1.refresh
thisfrom.grid.column2.refresh
thisform.grid.column1.checkbox1.refresh
thisform.grid.column2.combo2.refresh
can anybody help me......
--
Message posted via http://www.dbmonster.com Tag: Treeview and System ImageList Tag: 211069
more on DIBAPI32 and Window Printing
Hello and thanks for the response.
I copied both the DLL and the LIB file into my development folder. It is now
starting to work but...
When I execute the code provided earlier the following happens:
I am prompted for a printer.
I then get a window which says "Printing..." and the window title "to" and
the printer name "Sending bitmap to printer..."
And there it sits with nothing actually getting sent to the printer
The printer works fine. I printed a test page and a document but the bitmap
never prints.
The code I used is:
!/N REGSVR32 /S DibApi32.Dll
#DEFINE PW_WINDOW 1
#DEFINE PW_CLIENT 2
#DEFINE PW_BESTFIT 1
#DEFINE PW_STRETCHTOPAGE 2
#DEFINE PW_SCALE 3
DECLARE INTEGER PrintWindow IN DibApi32 AS PrintWin ;
INTEGER HWnd, ;
INTEGER fPrintArea, ;
INTEGER fPrintOpt, ;
INTEGER wxScale, ;
INTEGER wyScale, ;
STRING @ szJobName
PrintWin(thisform.hwnd,1,1,0,0,ALLTRIM(thisform.caption))
Does anyone know what the problem is?
Thanks,
Jeff Tag: Treeview and System ImageList Tag: 211068
gendbc, views and rounding problems...
My question is really two part:
First why when running gendbc against SQL data are the views created with
data type of B(2) when the data structure in SQL is Numeric 12.2? In VFP
data this would have been N(12,2) - correct? What is the type of "B"?
Then, the second equally as confusing part of this problem is that we have a
field which in the debugger, the tables and the views shows a value of 37.63
and we subtract a payment of 37.63 yet the result is not 0.00 as you would
expect it is -0.01 unless we include the round function on the first part of
the equation [round(finalcost,2)]. We do not see the rounding problem so
where is it or is this just an anomaly that has always been part of the
views that we have been unaware of.
Thank you! Tag: Treeview and System ImageList Tag: 211066
Error reading file...
This is a question that I'm sure has an answer of "no".
If you have a table open, and the network connection is severed, you get
"Error reading file....". OK and Help are your only options. Pressing OK
brings back the message, and it's a never ending cycle. Even if the network
connection is restored, you will probably not be able to escape. Alt-Ctl-Del
is your only way out.
Is there any other way to get out of this loop short of hard terminating the
app? To duplicate this, I plugged in my USB drive, copied some tables to it,
opened the table, and pulled the stick out of the USB slot. Wham, "Error
reading file...". Bye bye VFP and any unsaved work.
Fortunately, this doesn't happen much in production, and when it does it's
usually a network glitch (or in our case Windows server 2003 flakiness that
we have not yet resolved). I am tempted to classify this as a bug because
it's been around for so long. I would think that Micorosoft would change
this to allow you escape from this condition without having to hard
terminate the app. Tag: Treeview and System ImageList Tag: 211054
SET CLASSLIB
when using SET CLASSLIB, if a library has already been added, will using this
call create another instance of that class?
Is it necessary to use the RELEASE CLASS statement? I know it is good
practice to use it but is it necessary?
Thank you Tag: Treeview and System ImageList Tag: 211049
foxpro security question
I have 1 FoxPro client that I service once a year for a few weeks. I'm not
remotely a FoxPro expert. The app is still in VFP6 and that's fine for now.
I may end up converting the whole thing to Access since it's pretty small
and low usage. It'd be easier for me to maintain that way. Anyway, I'm
trying to find out about the security available in Fox. Their company has
come up with a new policy that's going to require that the database be
secured to some degree. Right now it's not in a container. It was originally
a Fox 2.6 for DOS app that we just grungily moved over to VFP a few year
ago. So the tables are all free. Other than doing things like securing
folders on the network and such, is there any way within VFP6 (or even later
versions maybe) of securing the tables so they cannot be tampered with?
Obviously right now anyone can get into them even if they just have odbc on
their system and they have access to the folder the files are in. Anyone
with MS Access can get at them. We'd like to tighten it up a bit if
possible.
Thanks in advance,
Keith Tag: Treeview and System ImageList Tag: 211048
trouble with converting a string.
i know this is a real basic question, please bear with me, i am still learning.
i am placing a Name from a file onto a Word Doc. in some cases its a normal
name.
Jane Doe, other times it could be Jane Doe-Deer. thats the one i am having
trouble with.
i am using proper(from) to make it look nice. but the Hypen is giving me
fits. it will print like this Jane Doe-deer not very nice.
any ideas? Please.
thank you in advance. Tag: Treeview and System ImageList Tag: 211043
Outlook is killing my Excel workbook
Hello, i am using Excel and Outlook Automation to respectivley create a
Workbook and email it. all that is going well.
once the workbook is attached to the mail and sent, the user then will open
the workbook up, add to or make changes and send it back to the sender. prior
to sending it gets the workbook is printed out. and it fine. however after
recieving the edited workbook back, it adds a column to the book with the
same data in the previous column.
EX Date Cost Total cost
2/1/05 5.00
2/2/05 5.44
10.44 this in the Send
email attachment
i get back
date cost totalcost
2/1/05 5.00 5.
2/2/05 5.44 5.44
10.44
it adds a row of the same as Cost but removes the .oo's so 10.01 is fine but
10.10
looks like 10.1 and i dont even know why it adds that row in the first
place. its wrong. Tag: Treeview and System ImageList Tag: 211036
DIBAPI32.DLL
Hello all and thanks for the help.
There was an earlier thread that talked about how to write a "Print Screen"
for a form and referred to DIBAPI32.DLL which is available here:
DIBAPI32.dll comes with Palfade.exe which is on the September 1999 Technet
Library Archive
It's also available at
http://download.microsoft.com/download/platformsdk/sample42/1/W97/EN-US/PALFADE.EXE
The problem I'm having is that this DLL seems to be quite old and doesn't
work with (my) Win XP. Does anyone know of a modern replacement?
Thanks,
Jeff Tag: Treeview and System ImageList Tag: 211034
VFP8 getnextid using cursoradapter views
We are having some multi-user issues having changed our system over to use
cursoradapters (native and SQL). The file which controls the next id for
each table is accessed via a cursoradapter. Unfortunately requery on this
file fails if someone else has updated that file and hasn't yet committed
their change i.e. they are in the middle of a BEGIN/END TRANSACTION. Other
than avoiding getting the next id inside a transaction and requerying inside
an endless loop until successful, I can't think of a way round this. I toyed
with autoincrement fields but we have a lot of parent/child tables where we
need to know the parent id for the child records, so I've abandoned that
idea. We also access the data via ODBC in Crystal so again I think there is
a problem with autoincrement fields.
Has anyone got any other suggestions?
Thanks,
Bernie Tag: Treeview and System ImageList Tag: 211031
[SingFox] VFP UserGroup Meeting
Time : 6 - 9 PM
Date: 4 May 2005
Place: MS Office @ Marina Bay .
For More info and directions - please see
http://groups.yahoo.com/group/SingFox .
If You wish to attend please SMS your name to me at 9004 1089 - I have to
put your name on the Roster List
for MS Security Desk.
warmest regards / xie xie [Bill] Tag: Treeview and System ImageList Tag: 211026
How to prevent DBC trigger from firing
I have to write a utility that will update production tables. The tables
have triggers to update a datetime changed field when the record is updated.
The nature of the change I'm making is such that this trigger absolutely
cannnot fire. Is there any quick and easy way to prevent record validation
rules from firing? This is a production system and I can't change the DBC
just for this update. The update is an automatic process, no human
intervention. Tag: Treeview and System ImageList Tag: 211020
May letter on Visual FoxPro web site
This month's letter contains a summary of some recent Visual FoxPro news as
the Visual FoxPro team is busy working on future plans for Visual FoxPro to
be announced next month.
http://msdn.microsoft.com/vfoxpro/letters/
Ken Levy
VS Data Product Manager
Microsoft
http://blogs.msdn.com/klevy
http://msdn.microsoft.com/vfoxpro
--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden Tag: Treeview and System ImageList Tag: 211019
create a help file
i will appreciate if can help me, i develop visualfox 7.0 application, but i
need to create a help file i dont know how.
Tanks Tag: Treeview and System ImageList Tag: 211018
Method code swapping in VFP8 SP1
VFP8 SP1 on XP Pro SP1
I've seen this reported in other versions of VFP, but not in
VFP8. After editing a form and running it, I got some odd errors.
I went back into the form and found that several methods had
their code swapped. The code from the Load and Init methods
had been swapped, the code from the Show and Unload methods
had been swapped. How's that for scary?
This form has about 40 custom methods added to it and only the
native methods that had code in them got swapped. The custom
methods were all fine.
In VFP's defense, at the time this happened, (but after the form
had been saved, compiled, and run) VFP crashed due to another
issue. I suspect these events are related since I've never
seen this code swap problem before this.
-- TRW
_______________________________________
t r w 7
at
i x dot n e t c o m dot c o m
_______________________________________ Tag: Treeview and System ImageList Tag: 211014
RDP, Memory and VFP
Hello,
At a customers place, I have to develop foxpro (8.0) in a Remote Desktop
session on a heavy machine, lots of memory, 2 cpu's etc..
When I' m running large queries I frequently get an error: "Not enough
memory for map file", or when I look at the rushmore optimization it says;
"Not enough memory to rushmore optimize table x". I tried SYS(1104) or/and
sys(3050,1,large) / SYS(3050,1,small). But nothing seems to help.
Sometimes it helps to log off the rdp session and start a new session.
Because off security reasons it's not easy to try the query on a local
machine (without RDP)...
Is there anyone who knows how to solve this?
TIA
Gerben Kessen Tag: Treeview and System ImageList Tag: 211012
Multiple Detail bands in Report Writer?
Not sure if that's what I need to do or not, but here's the gist...
We do testing services here, using vehicles. The data is compiled at
certain mileage intervals. The report goes like this...
Header
Detail lines showing data at each mileage interval
More lines showing data another way at each mileage interval.
Same as above, data another way.
Same as above, data still another way.
Same again, data still another way.
Each of these "bands" show the mileage intervals and dates that the data was
compiled. But each of these show the data in a different manner.
Initially, raw data, next band a sort of summary type data, the next band a
projection data, but still based at the individual mileage increments when
the data was compiled, next band is a series of comments compiled at each
measurement interval and finally a set of physical properties taken at each
mileage interval.
Right now this is done as a "manual" report in FPD2.6. I have no idea how
to get this into the report writer.
Can someone please help? Point me in the right direction?
Thanks!
Shawn Tag: Treeview and System ImageList Tag: 211002
shellexecute
I need to display .pdf' files from within a Foxpro program. I thought that a
shellexecute command was the way to go, but I can't seem to get it to work.
Any help and/or sample code will be great.
--
Lost in Tampa Tag: Treeview and System ImageList Tag: 211000
User-Defined string Functions Transact-SQL - built-in functions Fo
Ladies and Gentlemen,
I would like to offer you the following string functions Transact-SQL,
the name and functionality of which correspond to the same built-in
functions of Visual FoxPro
GETWORDCOUNT() Counts the words in a string
GETWORDNUM() Returns a specified word from a string
AT() Returns the beginning numeric position of the first 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
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
PROPER() Returns from a character expression a string capitalized as
appropriate for proper names
RCHARINDEX() Is similar to a built-in function Transact-SQL charindex but
the search of which is on the right
ARABTOROMAN() Returns the character Roman number equivalent of a specified
numeric expression
ROMANTOARAB() Returns the number equivalent of a specified character Roman
number expression ...
For more information about string UDFs Transact-SQL please visit the
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,54,33,27115
Please, download the file
http://www.universalthread.com/wconnect/wc.dll?LevelExtreme~2,2,27115
With the best regards Tag: Treeview and System ImageList Tag: 210997
VFP8 & Linux
I am new in this subject...
Is it possible to run a VFP8/application,exe/ on a workstation where the
server's operating systeem is Linux?
Could anyone help me?
Many thanks.
--
Sandor Tag: Treeview and System ImageList Tag: 210987
VFP8 & Linux
I am new in this subject...
Is it possible to run a VFP8 /application, exe/ on a Win98 workstation,
where the server's operating system is Linux?
Could anyone help me?
Many thanks.
--
Sandor Tag: Treeview and System ImageList Tag: 210986
Tableupdate fails - VFP8/SP1
Hi all!
* Write from a local paramerized view to its basetable´s memofield
IF CURVAL(lcFieldName,lcAlias) == OLDVAL(lcFieldName,lcAlias)
llUpdated = tableupdate(1,.F.,lcAlias)
* respons to user
IF llUpdated = .T.
wait 'Saved' nowait window
ELSE
TABLEREVERT(.F.,lcAlias)
wait 'Not saved' nowait window
ENDIF
ENDIF
Is the VFP-multiuser-stuff stable? User A saves to a memofield as above and
receives the Saved-message. After that user B opens the same view and saves
unother value to the same field and she receives the Not saved message. What
can be wrong? The view is is opend shared of course. I have tried to reindex
the table and recover the database as well.
Best regards
Christina Tag: Treeview and System ImageList Tag: 210984
PrintScreen direct output to printer ?
Hi
I am using VFP6 SP4
I want to make a command button to dump the screen or active window
and direct output to printer (not copy to clipboard).
when the user clicks this command button, it is the same as press key PrtSc
How can I do that ?
pls give me a hand
thanks all Tag: Treeview and System ImageList Tag: 210982
Copying a Graphic to the Clipboard
Anyone have a routine that will take a graphic (e.g. a .JPG file on disk) and
copy it to the Windows clipboard so the user can then just paste it in a
graphics program like Paint Shop or Photo Shop?
Thanks.
Charlie Parker Tag: Treeview and System ImageList Tag: 210977
RUN will not work - requires working dir?
I have an application on my machine that is basically an icon on the desktop
with the following for the target P:\psw.exe.
If I take properties on the icon, under "start in" it has p:\.
If I double click the icon on the desktop, it works as expected.
On one of my VFP forms, I have a command button with the following code and
the program will not run (it generates an error specific to the program)
RUN /N "P:\psw.exe"
Any ideas how I can trouble shoot this, or modify the run command so it has
a "start in" that emulates what it is expecting?
Thanks,
Dan Tag: Treeview and System ImageList Tag: 210968
C0000005 upon vfp exe exit after responding to .net events
I am getting a dreaded C000005 at address 79221bd8 after running a simple vfp
exe that opens a simple .net form and responds to an simple event. The event
is being handled fine by VFP, but upon exit the windows error is displayed.
What is strange is that when this simple app runs in the VFP IDE it works
just fine. No errors. Running it standalone produces the error.
Does anyone here have some experience/sample code in responding to a vb.net
dll's events in a VFP executable? I would sure appreciate some help here.
Again the code is working just fine; .net dll is being created and .net form
is running in new thread, I am implementing an eventhandler in VFP correctly
since the event fired by the .net form is being responded to by VFP. It just
blows when exiting back to Win XP.
Thanks.
SJT Tag: Treeview and System ImageList Tag: 210960
Report. Page X Out of Y by Groups.VFP9.0
Hi,
I want to be able to print "Page 1 out of 4" for every group on the
report so that every group will start from page 1. Another word, I
need page totals for every group.
Note: VFP9.0
Thanks, Eugene. Tag: Treeview and System ImageList Tag: 210959
Hiding the top level form
Hello and thanks in advance for the help.
If you have an app with a top level form where the other forms are "In top
level form" and Desktop = .t.,
How do you hide the top level form when the user goes into a subform?
Does the parent object of the lower level form point to the top level form?
Thanks,
Jeff Tag: Treeview and System ImageList Tag: 210956
SQL: Group By error
Hi,
I'm new to FoxPro and am converting from version 5 to version 8. I'm getting
this error:
SQL: Group By clause is missing or invalid.
The offending code is:
SELECT statepmt.state_code, strecon.total ;
FROM statepmt, strecon ;
WHERE statepmt.yyyy_mm = w_yyyy_mm AND ;
statepmt.state_code = strecon.name ;
GROUP BY statepmt.state_code ;
INTO CURSOR statots
It works fine in version 5.
I'd appreciate any comments.
Thanks,
Jim. Tag: Treeview and System ImageList Tag: 210948
DOUBLE-BYTE PROBLEM
HI ALL
I TRY TO USE WEB SERVICE FOLLOW THE SAMPLE CODE IN VFP 9 HELP.
BUT I WERE CONFUSED WTIH HOW TO TRANSFER CHINESE BIG5 FIELD AND CONTENTS
PROPERLY.
I FOLLOWED THE CODE BELOW
Walkthrough: Creating XML Web Services with Visual FoxPro
and made northwind!customer's filed into chinese include content
but failed
Can somebody help me ? Tag: Treeview and System ImageList Tag: 210939
vb.net usercontrol used in a foxpro 9 app
Hi,
In VS6.0 it was simple to create an active-x control in VB and then use it
as a ole object in Visual Foxpro.
I'm trying to figure out how i can pass values from visual foxpro to a vb
control and then return completed values.
Can anyone shed some light on this, and/or provide examples.
Thanks
GG Tag: Treeview and System ImageList Tag: 210936
data migration
Hi friends
am exporting vfp data to sql server and am using DTS to export.
my question is is there any option to export all tables at once rather than
doing one at a time?
Thanks
--
cheers Tag: Treeview and System ImageList Tag: 210931
indexing problem
How do you index a table which has a field which may be positive, negative
or zero? The problem is a secondary field is also required which is a
character field. Let's say field1 is the numeric field and field2 is the
character field. Using the following command to create the index, does not
produce the desired results:
INDEX ON STR(field1,FSIZE("field1")+field2 TAG myindex
For example, I would see the following numbers in a browse form when looking
at the field1 column :
0
1
2
3
4
-1
-2
-3
-4
But, the desired response is:
-4
-3
-2
-1
0
1
2
3
4
I'm sure other people must have come across this problem -- any ideas?
Thanks,
-- E. Myron
I have a table containing two field called myvals which can contain numbers
from -99 to +100. When I index the table using the following command,
everything is fine:
INDEX ON myvals TAG numindex
If I index using the following command, the result is incorrect:
INDEX ON STR(myvals) TAG strindex
The problem is that I have to use a string because I am combining two
fields in order to get a secondary
--
To reply, change "invalid" to "net" Tag: Treeview and System ImageList Tag: 210928
SQL Problem
I have a problem (VFP6) in getting a summed amount which I need for a
report.
In simplified form, because there are other related tables, the code
reads:-
Select tenants.lastname,tenants.tenantref,more fields,
tenacc.item,tenacc.debit,tenacc.credit,sum(tenacc.debit) as
sumdebit,sum(tenacc.credit) as sumcredit;
From tenants inner join tenacc;
On tenants.tenantref=tenacc.tenantref;
order by tenants.tenantref;
Where (tenacc.item='Due' OR tenacc.item='Received';
INTO cursor rentsa
The problem is that the summed fields include all debits and credits for
tenantref, ignoring the Where line which is intended to restrict them.
I would like to define the summed fields as sum(tenacc.debit) for
(tenacc.item='Due' OR tenacc.item='Received') but SQL does not accept a
FOR clause.
I have also tried using the summing ability of a report format, but
cannot seem to get it to work
Help would be much appreciated.
--
Tim Hobson Tag: Treeview and System ImageList Tag: 210917
Timer events... when?
...in Fri pm duh mode. Timer events fire between lines of code or between
procs? Also there are some issues with users setting focus on other non-VFP
processes while timers are enabled, I seem to remember. Some refresher
remarks about that'd be good, too.
TIA.
-Lew Tag: Treeview and System ImageList Tag: 210904
Is it posible to associate the system image list with a treeview control?
I've been playing with Shell_GetImageLists but no luck so far.