Is exclusive open of table faster
If you open a table exclusively does that make processing faster?
Anybody have any experience or documentation on this?? Tag: dynamicreadonly Tag: 222193
class not registered..
Hi..guys.
I meet a problem in my customer side ..when calling the mscomm32.ocx ..its
out a error 'Class not registered' in workstation Window XP SP2. is it the
window xp setting problem? I used foxpro 6.0.
regards,
Orange Tag: dynamicreadonly Tag: 222188
Report Problem
Hi All
When I Run report with reportlistener Preview (reportpreview.app) From
Button In Window TestForm Created in Top Form MainForm ShowWindow = 1
when report Finish All off properties Of The TestForm and data which I
created in load form from sql database and Connections lost
This Happen when Run From Exe File Only
any Id
I use Vfp9 Sp1
Thanks Tag: dynamicreadonly Tag: 222187
White b/g isn't white?!
Hi,
I'm trying to make the backcolor of my form pure white. But I can't get
it to show that.
The backcolor of the form and the page is 255,255,255 and the page's
color source is 0 (Object's Color Properties).
Yet the form is clearly not white. I'm a little color blind so I can't
say for sure what the color is but it looks to me as slightly grayish
with a bit of pink.
The page tabs are white and it's quite obvious that the page itself is
not.
What am I missing?
This is VFP9
Thanks, Frank Tag: dynamicreadonly Tag: 222182
VFP8 performance on low memory machines
I have an app that we have recently upgraded from VFP6 to VFP8. On machines
with a lot of memory the performance is very good, but on machines with less
memory the performance has degraded significantly.
The apps are being run locally. I have had a look at sys(3050) but I am not
sure whether it is the right approach to take.
Any suggestions? Tag: dynamicreadonly Tag: 222162
Another query design question...
Hi,
Using VFP 9.0 to remotely query a SQL database and I'm stuck once again...
yeah I know, what else is new? :-)
This time I'm trying to make a sort of lookup table(view) from two related
tables:
Table name: billing_code
Fields:
sys_id (pk)
billing_code_set_ver_sys_id
billing_code
description
create_timestamp
modify_timestamp
create_user
modify_user
Table name: billing_code_charge_code
Fields:
sys_id (pk)
billing_code_sys_id
chg_codes_code
create_timestamp
modify_timestamp
create_user
modify_user
These tables are related on the billing_code.sys_id to billing_code_sys_id,
for every billing_code record there's many billing_code_charge_code records.
What I want is a table that returns chg_codes_code, billing_code and
description. Sounds simple doesn't it? Here's the catch...
The billing_code table is on the many side of a one to many relationship
with another table, billing_code_set_version. This means that there are
multiple records in billing_code with the same billing_code and description.
So far I haven't figured out how to get my query with just one record for
every chg_codes_code, billing_code and billing_code.description. The
closest I've gotten is this:
select distinct chg_codes_code, billing_code, description
from billing_code_charge_code
right join billing_code on billing_code.sys_id =
billing_code_charge_code.billing_code_sys_id
where left(chg_codes_code, 1) in ('D', 'F', 'E')
order by chg_codes_code
In many cases this returns duplicate chg_codes_code values. The main
difference I see in the records is that for one the description is in all
upper case and the description for the other record uses normal case.
Any suggestions? I've been trying all sorts of combinations but so far no
luck.
Thanks in advance,
Linn Tag: dynamicreadonly Tag: 222156
Blues on protecting executables
After seeing Refox protection is breakable with the new tools, I'm looking a
new way to protect an application in VFP7 SP1
Using Molebox my exe file don't work. I don't know what I'm doing wrong. Had
someone used this tool.?
I'm aware on Derefox, I think this is the name, although I think is a good
tool, I consider a problem to have to include more resource files (VFP6).
Thanks.
Alejandro Fernandez Tag: dynamicreadonly Tag: 222155
Report Writer VFP 9 BUG
Hi,
I have a table with 200 records, contains 7 fields, one of them is a memo
field.
I designed a very simple report with 5 fields on one line in the details
band & on the 2nd line in the detail band I putted the memo field with width
of the page A4.
In the print when of the memo field, I inserted a variable & if this
variable is TRUE then the memo field will appear in the report else it won't.
When launching the report with the variable set to FALSE, a list of the 200
records appear. When the variable is set to TRUE, the report show a blank
page with a number of pages in the TITLE BAR of the report starting from
28500 pages & counting quickly, I waited about 30 seconds & the number is
counting with more than 3 millions pages & the VFP is hanging so I closed it
from the task manager.
I retry the same action, & I obtained the same result.
Any Help Tag: dynamicreadonly Tag: 222148
How to write click event
Hi all,
In my program, when my program is running, enduser can press a button to
create another "command button".
And now I have a problem of create a "command button" with coding in that
"Click event method" at the same time in the above situation.
--
Thanks ! Tag: dynamicreadonly Tag: 222142
How can I know the class calling the procedure
Dear All
How can I know the class calling the procedure ?
For Example
Define class parent_class as session
Procedure some_method
set proc to procedure_file
do call_me()
Return
Endefine
Procedure file.prg :
Procedure call_me
how do I know the "parent_class" calling me ? <---- Anyone enligthen me
?
Return Tag: dynamicreadonly Tag: 222140
Running a distributed .exe from an installation on a network serve
I have a client that is having trouble running my program from an
installation on a server from a workstation. I know that it is being used
that way on some other sites so I am thinking it is a rights issue. Are
there any limitations, such as printing reports from the server, that a
client accessing it from a short-cut is going to experience?
Cory Bonallo
Retail Services
Developer Tag: dynamicreadonly Tag: 222136
Determining SMTP server
I want to provide the application option to send email from Fox
via SMTP instead of MAPI method. Does anyone know how to retreive
the default SMTP server name from Fox or Windows API?
-----------------------------------------------------------------
Paul Lee ........ Abri Technologies ........ http://www.abri.com/
'Recover' - top rated FoxPro file repair utility.
----------------------------------------------------------------- Tag: dynamicreadonly Tag: 222134
download foxpro 2.6 distrubtion kit here
here you can dl Foxpro 2.6 dist... kit
tanks alot for all visitors
email me for any unfounded link
to mbksoft@gmail.com
http://vetusware.com/output/id73-FPXPRODK.260.rar Tag: dynamicreadonly Tag: 222131
Debugging Fox COM object in IIS
Hi all!
My website uses a FoxPro COM object to perform some database
operations. The Fox DLL is single-threaded. At times, the function
calls within my website to the Fox COM object will stop responding and
the website will hang. The last time this happened, I attached
Microsoft's WinDBG to the website process to debug it. What I observed
was what appeared to be an infinite loop of first chance access
violations. The violation occurrs in "vfp8r.dll" and with symbols, one
can see the function in which the crash occurs is "KBCopy2". Apparently
some error handler is catching this violation because it never becomes
second chance but the function is getting repeatedly called (infinitely
it seems) and therefore locking up my COM object.
Does anyone have any ideas about how I debug this further and find out
exactly what is going on? Thank you!
Matthew Tag: dynamicreadonly Tag: 222126
problem dragging file to explorer
I posted in a xp newsgroup, but did not get an answer.
I have a Visual Foxpro Application that reads a text file and stores the
data in a table.
The text file is created using a PDT (Portable Data Terminal). I use the
software that came with the PDT to drag the text file from a PDT window
(from within
the PDT software) to a folder called c:\mobile. It works great on my test
computers (both are
Windows XP Home Edition....arghhh don't ask why!). Anyway on my client
computer, which is a Windows XP Professional, I cannot drag the file. I can
only drag it to the Recylce Bin. I think I have checked properly any rights
for the c:\mobile folder and they are set to "read, write, etc....all rights
are check". However, windows will not allow me to drag the file. What
setting am I missing? I opened and saved a wordpad document in the
C:\mobile
folder so I do have rights.
Thanks, John. Tag: dynamicreadonly Tag: 222123
Persistent VFP COM Server with GUI
Hi,
I'm trying to start a VFP application through automation. So I created
OLEPUBLIC class. This class displays application's main form in Init code.
Application is compiled as out-of-process EXE.
In VB code I create instance of my COM Server:
set oApp = createobject("Myapp.App")
oApp.DoSomething()
The main form appears and the application is working. But when VB code
finishes and oApp variable is cleared, my VFP application is also closed!
Q: How to preserve vfp automation server in case of releasing referencing
variable in client code?
Look at MS Excel. If I run following code written in VB:
set oEx = createobject("Excel.Application")
oEx.Workbooks.Add
oEx.Visible = true
After releasing oEx variable from memory, Excel is still visible and
working! How do that in VFP?
Thanks in advance,
Janusz Czudek
WORD Software
www.wordsoft.com.pl Tag: dynamicreadonly Tag: 222122
Lost settings in IDE
When I open VFP, all settings are lost. Whatever I do it in VFP now,
everything will be disappeared after I reopen VFP. Any ideas? TIA. Tag: dynamicreadonly Tag: 222113
Null values in a textbox
Hi,
I made a screen with more than 40 textbox, I have only 3 fields which accept
Null values. When the user type by mistake ctrl+zero on a field other the 3
fields, an error occurs & the application is closed. I tried to write code in
the ERROR handling program such as:
do case
case error_num = 1581
Messagebox(dvgdfg)
return 0
but still the application is closed.
any help, Thank you Tag: dynamicreadonly Tag: 222110
SET TALK command (VFP6)
The VFP command window can be used as a calculator. If I issue:
CLEAR
SET TALK ON
USE sometable
SET FILTER TO somefilter
SUM FOR somecondition
the system will show a count of the records it processed, and the sum of the
numeric fields in the table. The results will be shown on the SCREEN, and
the display will persist (and I can print it with PrtSc). It may look like
this:
99999 records summed
valuation
123456789.00
If, however, SET STATUS BAR ON, the sum will be displayed on the screen, but
the count will be displayed in the graphical status bar. Moreover, the count
will be displayed only for about 3 seconds, and then the status bar will be
refreshed, wiping out the count. I find that the only reliable way to get
the display I want is to
SET STATUS BAR OFF
SET TALK ON
thus foregoing the benefit of the status bar.Also, I don't find the clauses
like "SET TALK WINDOW somewindow" to work very well.
Any comments? Tag: dynamicreadonly Tag: 222108
Modal browse windows
I am attempting to open 3 browse windows from a VFP9 form. The intent
is to be able to move the browse windows around so they can be arranged
on the desktop.
My problem is that they all open correctly but I only have access to
the last one. They are acting like they are modal. The only way I can
access other windows is to close the top one.
Are we dealing with a foundation read issue here??
Is there any way to make this work.
the command is
browse noedit window <window name> nowait Tag: dynamicreadonly Tag: 222103
Deleted box does not show??
I'm using VFP 8.0 and have a view in my database. When I use and browse the
view, it does not show the deleted status of the underlying table. Why? I
can set deleted on and the deleted records DO NOT show in the view.
However, I want them to show, but have the black square in the grid. What
is a workaround? Thanks, John. Tag: dynamicreadonly Tag: 222099
Regional settings and dot on numeric keyboard
I have a text field with inputmask set to "9999999.99" which is used to
store info about money. Everything is OK when user have keyboard set to
English, but when keyboard is set to PL (polish programmers) button '.'
on numeric keyboard become comma. If user with PL keyboard press '.'
key on numeric keyboard like he wants to write cents it does not move
to cents digit....
How to override this behavior ?
I was trying change it in Keypress event, but it doesn't work:
LPARAMETERS nKeyCode, nShiftAltCtrl
IF nkeycode=44 && IF polish keyboard change ',' to '.'
nKeyCode=46
RETURN 46
ELSE
ENDIF
Thanks,
Adam Tag: dynamicreadonly Tag: 222097
SQL Help please!!
i am trying the following with errors.
Select Agency, Dept,;
Sum EmpDate <= checkhdr.procdate, 1, 0 As currentmonTH,;
Sum EmpDate => checkhdr.procdate, 1, 0 As nextMonth;
From newmem;
what is the best way to get this data in SQL?
thank you Tag: dynamicreadonly Tag: 222093
How do I run this from a click even ?
I run this from the RUN dialog box: C:\AVD\PERU\pptview.exe /L
"playlist.txt"
How would I get this to run from a command_buttons click event?
Your Friend From Afar ~
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: dynamicreadonly Tag: 222082
VFP 8.0 Remote View Bug with MySQL 5.0 production
Hi Gang,
I appreciate any you can give me on this one. I run VFP 8.0 SP1 and use
remote views via the MySQL ODBC driver 3.511-11-2win to work with large
MySQL Tables. I recently upgraded from MySQL 5.0a Beta to the MySQL 5.09
Production release version and I noticed two related but big problems:
1. Any remote view of a MySQL table which contains numeric or decimal
fields will be automatically characterized as character fields when you
attempt to build a remote view in VFP 8. It will get integers and datetime
types right. (You can even see it in the DBSETPROP command if you view the
SQL in the view builder). If you attempt to change the SQL manually in the
view builder and run the query, Fox will tell you that you have a data type
mismatch. Makes it a bit difficult with numbers.
2. If you attempt to just pull the data with the Fox SQLEXEC(handle,'select
* from my_table,'sql_result'), the resulting Fox cursor will also convert
numeric and decimals to the character datatype, even if you have used a
CREATE CURSOR command to define the fields to match the MySQL table exactly,
numbers and decimals come out as character fields.
I re-installed the older version of MySQL 5.0a Beta and the problem went
away. The problem seems to involve any table MySQL defines as a version
"10." Legacy version "9" MySQL tables (don't modify them in MySQL or they
become 10's) will continue to work normally.
Has anyone else experienced this issue? Have you found a work-around or a
version upgrade or fix that I am missing? Thanks a bunch!
David L. Jacobson Tag: dynamicreadonly Tag: 222079
Date Time Picker auto dropdown
Hi,
I want my form to open with the calendar part of the MS Date and Time
Picker control visible.
I tried adding KEYBOARD '{ALT+DNARROW}' to several events (GotFocus,
Refresh, UIEnable, etc.) but without any luck.
Also, I'd prefer that the text box portion not be visible at all.
Is there any way to do this?
Is there another control I could use instead?
Thanks, Frank Tag: dynamicreadonly Tag: 222076
Variable editing
Is there a way in FoxPro to open a string variable in an editing
window, like you can do with memo fields? I want to be able to assign
a string to a variable then edit it using something like modify memo or
modify command. I guess I could put it in a memo field, but it seems
like you ought to be able to open a full-screen editing session with a
string variable without having to copy it to a memo field. Any
suggestions?
Kevin Clark
Seton Home Study School Tag: dynamicreadonly Tag: 222075
Child grid woes
Hi,
I have a parent grid and a child grid on a pageframe page. The child grid is
set up with Linkmaster, RelationalExpr, ChildOrder, etc properties which
work fine. The problem I have is that if I move to say the third record in
the child grid, issuing a page refresh will reset the pointer to the first
record. Is there any way to stop this happening, or a good way to send the
pointer back to the correct record on a refresh (the child records have a
unique id I could use). I'm using VFP9.
Any help much appreciated.
Neil Tag: dynamicreadonly Tag: 222074
Change scope?
CHANGE is almost identical to BROWSE in what it can do. I just noticed
however that CHANGE has a <scope> which is rather odd for a browse like
command. Even more odd is how it works.. If I issue
CHANGE NEXT 3
on a table with some records then I can actually change up to 3 records
either "up" or "down" from my current position. As soon as I cross the 3rd
record boundary the window closes. This is the case if I move "up, up" or
"down, down" or even "down, up" etc. If I use the Record->Goto menu option
then in fact I can go to any record I like any number of times and edit data
provided I don't cross the record boundaries and the window will stay open.
What is the meaning of <scope> in the context of CHANGE?
Gene, is this good enough for your list of nasty questions?
--
regards
Andrew Howell Tag: dynamicreadonly Tag: 222072
System hang restart PC- data losed
Hi..everybody..
I meet a problem is the enduser purposely restart the PC when system hang..
And the data key in all day was totally losed in .dbf after the end user
restart pc..Foxpro 6.0 was used + foxpro tables database.. is it got any
solution for me?
regards,
Orange Tag: dynamicreadonly Tag: 222057
Blank if zero(another choice) ?
in vfp report, my client don't want to print zero and print - - instead ?
How can I do that ?
thanks Tag: dynamicreadonly Tag: 222056
frx to xls
This is a multi-part message in MIME format.
------=_NextPart_000_000E_01C64CC6.1C1D5DC0
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable
Hi,
which is the best tool for REPORT FORM frx TO xls ? I mean WYSIWYG =
including line/box/fonts,etc.
xfrx ? frx2any ? I have tried Amyuni Converter, but not really convert =
exactly, and column of data missing too.
plz recommend.
Regards
Hoe
------=_NextPart_000_000E_01C64CC6.1C1D5DC0
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.2802" 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>which is the best tool for REPORT =
FORM=20
frx TO xls ? I mean WYSIWYG including =
line/box/fonts,etc.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>xfrx ? frx2any ? </FONT><FONT =
face=3DArial size=3D2>I=20
have tried Amyuni Converter, but not really convert exactly, and column =
of data=20
missing too.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>plz recommend.</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>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_000E_01C64CC6.1C1D5DC0-- Tag: dynamicreadonly Tag: 222053
Currency Symbol
How can I make the reports in my application show the "£" symbol instead of
the "$" symbol. I've included SET CURRENCY TO "£" in the main calling
program which doesn't help. The TOOLS>OPTIONS>REGIONAL is also set to £
Please HELP!! Tag: dynamicreadonly Tag: 222052
index problem
I have a program which runs in a multiuser environment. The program has
been running for many years and every once in a while I find a CDX file
becomes corrupted. It can be any one of the index files of which there are
many. I usually delete the index file and recreate it to fix the problem.
This doesn't happen very often, but it does happen once or twice in a 5 or 6
month period of time. The program is written in VFP 6. Has anyone else
experienced this sort of problem? Is there anything I can do to protect
this from happening? Has anyone determined why this happens? The files are
all flat tables as opposed to tables within a database container.
--Elliott Tag: dynamicreadonly Tag: 222048
Installing VFP 8 Application under 64bit Windows
I have run into an interesting problem. We distribute our product with
basically two installs using the installshield express included with VFP
(did I forget to mention we are currently using VFP8?) and have a
customer who just bought their first 64 bit workstation with XP 64 on
it. They went to install the second install (it's a workstation install
from the installed files on their server) and it's telling them that the
operating system is not sufficient for our software. Now I understand
that VFP 8 is supposed to work find under XP 64 in 32 bit mode, but
since we don't have any 64 bit machines (I wish we did as our MS Action
Pack provides the OS) I have no way to experiment with it to figure out
why it's not working or how to make it work.
Does anybody have any answers on this issue? I know we told the install
not to allow NT or 95, but I am not sure if that is the problem or not,
since XP 64 is still XP is it not? If this is not the case, is there
something we can have the customer change in the setup.ini or such
without needing to generate a new install for them? Any help would be
good. YOu can email me if needed at cywelch at metsysinc dot com if
possible since that would get the answer to me quicker since I don't get
time to read in here too often.
--
Cy Welch
Senior Programmer
MetSYS Inc
http://www.metsysinc.com Tag: dynamicreadonly Tag: 222047
Rich Text Control
Hi,
I am trying to use the Rich Text Format in Visual Foxpro 9 for the first time.
I bring the text field from the Solution Samples & insert it in a new form
with command buttons: Bold, Underline, ...
The rtf field in linked to memo field in a table.
I am trying to print but I don't know how to use the SELPRINT method from
the RTF.
I want to print the memo field in a FRX Report.
Can you help me please ??
Thank you in advance Tag: dynamicreadonly Tag: 222038
Ink
Sorry guys. The spam stuff was not my intent. I do oppoligies and won't
happen again. I have never been on newsgroups before and not sure how to
work them. I hope you guys can forgive a bad choice. Murphey Tag: dynamicreadonly Tag: 222033
Ink
Man I have found this site that has the cheapest ink for any printer.
You can compare prices and then review the companies on service and
quality. <http://www.imagraphix.com> Let me know what you think Tag: dynamicreadonly Tag: 222032
vb to vfp
I am about to attempt to translate 150000 lines of vb 6 code, plus 100
or so forms to vfp 9. I did find a small scale code conversion
utility, but I sure would like to find something a little more
complete. Suggestions?
Noah Sombrero Tag: dynamicreadonly Tag: 222031
CursorAdapter
OK, I'm confused. I added a CursorAdapter to my DE, but unlike the
tables I have in my DE, the cursorAdapter doesn't live in the same DE
path. Making changes to the CA doesn't seem to make any difference.
In fact, when I move this to the production environment, I have to
re-create the CA. What the heck am I missing?? What changes do I
need to make to the CA to move from a development environment to
production (and the paths are different)? Tag: dynamicreadonly Tag: 222021
SQL select UNION help
Hi all (what am I doing wrong?),
I have 2 tables.
First table:T1
1 field - name
records 4
A
B
C
D
****
Second table:T2
2 fields - name,sum
records 2
A,5
C,3
I want to select <name> and <sum> fields from both tables with a zero value
for the <sum> for names that exist in T1 but doesn't exist in T2.
Here is the code:
SELECT t1.name,t2.sum ;
FROM t1,t2 ;
WHERE t1.name = t2.name ;
UNION ;
select t1.name, 0 as sum ;
FROM t1 ;
where t1.name # t2.name ;
INTO CURSOR t3
Return is:
A - 5
B - 0
C - 0
C - 3
D - 0
Thank you much Tag: dynamicreadonly Tag: 222005
Modeless confusion
Hi,
I'm getting a little confused ;>).
I have a main prg which contains a bunch of procedures. The prg opens a
form with a DO FORM command.
If I set the form's WindowType to Modal the form works OK but, as the
docs say, I have no access to the menus. I need the menus; so I can't use
Modal.
If I set it to Modeless, the menu works but none of the procedures in my
main prg are available.
For example in an <button>.click I have this code "DO <myproc>" where
<myproc> is in the main prg.
The error message is "File '<myproc>.prg' does not exist"
Why is this happening? Shouldn't all procedures be available to the
form? Why would it work if the form is modal but not modeless?
This is VFP9
Thanks for your help, Frank Tag: dynamicreadonly Tag: 221997
Can VFP app run on XP Embedded platform?
Like the subject says:
Can a compiled VFP app run on a XP Embedded platform? I have a Point Of Sale
app that is written in VFP 7 and was wondering if it can be built into a XP
Embedded build.
Thanks,
Andy.
andy_velATyahooDOTcom Tag: dynamicreadonly Tag: 221996
Data Structure Suggestions Wanted
Hello and thanks in advance for the help.
I was wondering what field types some of you would use for the following
problem.
I created a form which allows a user to select invoices (any number but
usually only 3-5, sometimes 8-10) and names of users (any number although
there are only about 25 users). The form will then send an email to the
selected users asking them to investigate the selected invoices. So far, so
good.
Now I've been asked to create a historical database of the emails so that
the people sending them can follow up. What data type would you recommend
for the invoices and the users?
Memo with one on each line and using MEMLINES to parse?
Comma delimited string? (my list of invoices will never exceed 100
characters)
Child tables that points back to the parent table with one record per
invoice and per user?
I guess my generic question is what is the best way to store an array as a
field?
Thanks again,
Jeff Tag: dynamicreadonly Tag: 221993
Basic SQL SELECT question
Hi,
-
The following query yields a result. My question is, why does the FROM
clause not have to specify table1, from which the result is culled?
-
SELECT table1.somefield ;
FROM table2 INNER JOIN table3 ;
ON table2.field1 = table3.field1
-
Thanks,
David Tag: dynamicreadonly Tag: 221990
Windows XP Fax Status
I now able to send fax using XP through code,
and query the status of outgoing fax jobs.
but i cannot retrive the "extended status" of outgoing fax jobs
as show on the fax console.
please help.. Tag: dynamicreadonly Tag: 221981
XMLAdapter(VFP9 SP1) Elements With Attributes And Text
Hello All,
Is it possible, using the XMLAdapter, to produce XML where an element
has both an attribute and associated text?
For example
<VFPData>
<CursorName>
<Field1 field2value = "some value from field 2">Value from field
1</Field1>
</CursorName>
</VFPData>
As far as I can see you can make a field appear as an attribute of the
containing element which represents the cursor, but you can't make a
field's value appear as an attribute of another element which
represents a field.
Here's hoping that I've missed something obvious.
David Tag: dynamicreadonly Tag: 221979
Grid Question
I have a grid with about 15 columns, on Column 14 I have code that allows
the user to sort the grid in an ascending or descending order if they click
or right-click on the header. The problem is that when they click the
header, the grid goes back to show column 1 through 7 and doesn't stay on
the column I clicked. I would have to scroll to the right to see the sorted
column. How can I do this and allow the grid to show the column without
having to scroll to it?
Thank you,
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: dynamicreadonly Tag: 221977
I have a grid. Is there a way to simulate the property
"DynamicReadOnly" ?