Can somebody translate this into foxpro :
   wksOne.Protection.AllowEditRanges.Add _
       Title:="Classified", _
       Range:=Range("A1:A4"), _

I can get the line below to work from a VFox pgm.
However I cannot get it to work from a DLL.
lnValue=sqlexec(lnSqlConnect,"{CALL
Amergora.email_reset('&lcEmailFrom','&lcEmailAdd','&lcEmSubject','&lcBody')}")

vfp9 sp2 on xp
i have a menu bar using the treeveiw control on a dockable form, and for the
most part, it works well.
two issues though...

I have an old dos based report that I have to convert, however, I keep
getting this error Error 44 method: allothers Offending code set ...
I'm assuming that this error is in the converter itself & not in the report
I'm trying to convert. Is there a fix or workaround avail ...

I have tried to find this in the forums, but only got "hints" around
the edges.  We need to create custom filename(s) that would
(hopefully) include time-stamping in the name.  Ideally, we would like
to create Windows folders with custom filename(s) to contain groups of

group,
I'm using a listbox with a rowsource type "alias" and a rowsource
"customer.name" (customer is indexed on name). I know I can select the list,
type a few letters, and go to a value close to what I want. This is not

I am planning on upgrading our VFP 7 SP1 app to either VFP 8 or 9. My
question is which is more stable?  With all the complaints about 9 I wonder
if I should stick with 8, I do not need the report enhancements that are in
9, and I wonder if some our reports will not work in 9.

Cathy's white paper on the 'Listener' is great. However, each time I run the
HTML 'example', it displays a 'message':-
"HTML Listener created your report..... blah blah blah .... press Yes to
store to clipboard"

I cannot open Word because of a loop of error messages - all I have been able
to establish is the following:
Application fault Winword.exe
Module version 11.0.8227.0

I am trying to use DynamicBackColor to change the background colour of a
cell in a grid's column.  To determine the colour to use I need to
determine what column I am getting called on.
How can I determine the column?

I would like to use beautify on a text in an edit box, and would also like
to apply Foxpro's normal editing functions (e.g. indentation) in an edit
box. I guess I can use XSource for this - can someone point me in the right
direction how to use it?

I currently have a Visual FoxPro Form which is a grid with column headers. Is
there a way that I can add sorting capabilities to these column headers so
that the data is sorted in ascending or descending order by that column
header???

I have a cursor that contains some columns that have no values in them
and some columns that contain a zero value.  I need to be able to
distinguish between the two.
I have tried ISNULL() and also EMPTY() and in each case they return the

I have a form that I would like to enable disable controls
by incrementing a number instead of individually.
example in the refresh instead of following
*********************

I am using VFP9 SP1 on Wiondows Vista with Aero and noticed the Title bar of
screen disappers when the BorderStyle is set to Fixed Single(1) or Fix
Dialog(2)
I have done the following,