xsharp.eu

Matt,

with n/a I meant "not applicable". These are commands that are part of the VFP IDE afaik, or is EDIT, BROWSE etc also used in production code ?. In that case I'll change them to not supported
[/quote}

Definately seconding Matt in that it can be used in programs. Alans argument, since grids were introduced, Browse should not be used in programs insofar false, as browse command was enhanced with "Name" clause, allowing programmatic handling via OOP properties. Use cases are getting scarce, the closer you get to shrink-wrapped apps, but in some use cases where either a Excel spreadsheet could be created or table based solution used, slinging together a few Browses are better than normal forms.
Other use case - similar to using "wait window " against all GUI guidelines is for apps build for limited smart user group on also limited budget

regards

thomas

Alan Bourke wrote:...But really, has anyone used BROWSE in deployed software since proper grids appeared in the first version of VFP? If they have they shouldn't IMO.

crea cursor t_t (c1 c(20),c2 c(20),n1 I)
insert into t_t values ("Browse", "not really magic", 3)
insert into t_t values ("only dynamic ", "binding of", 2)
insert into t_t values ("some properties ", "to surrounding containers", 2)
browse name oBr_T_T partition 100 Redit
oBr_T_T.Left= 200
? oBr_T_T.Class

Robert van der Hulst wrote:This list reflects the status of build 2.08 that will be released this week.

alter table		&& used often in import tasks
compile			&& multi-line generated code can be executed via execscript AND compile, compile gives benefits
create from		&& table from struc extended
create cursor | TABLE	&& used quite often in my code
create DATABASE		&& in case I need to zip+send DB-enhanced dbf
create TRIGGER ON	&& most of the time probably better done in DD at design time ;-)
create CONNECTION	&& clearly debatable

Robert van der Hulst wrote:Alan,
Now all of our source is open, I am sure Matt will write this UDC and the function to implement this

? oBr_T_T.SaveAsClass("Testvcx", "BrowseDemo", "for xSharp")

Matt Slay wrote:Indeed, BROWSE, is an easy one to live without, or adjust for.
However, DO FORM is a different case, and that one surely cannot be disregarded as easily as BROWSE.
Here is the full DO FORM syntax from Help:

Code: Select all

DO FORM FormClassName | ? [NAME FormVarName [LINKED]] [WITH cParameterList]
   [TO ReturnVarName] [NOREAD] [NOSHOW]

private | public FormVarName, ReturnVarName 
FormVarName   = createobject("FormClassName"[,WITH cParameterList])
[FormVarName.SHOW = .f.]
[FormVarName.WindowType = 2]   && Uncertain, would have to read docs on where and when to issue READ... 
&& ReturnVarName will be assigned returnvalue of FormVarName.unload()

Kevin Clark wrote:But those are cases where I really should use a grid; so I'd personally have no problem with BROWSE being deprecated.

Johan Nel wrote:

Code: Select all

#command BROWSE => DbBrowser()
FUNCTION DbBrowser() AS VOID
  LOCAL oForm AS Form
  LOCAL oGrid AS DataGridView
  LOCAL oDT AS DataTable
  LOCAL row AS DataRow
  oDT := DataTable{DbAlias()}
  // Now load with data
  DbGotop()
  DO WHILE ! EOF()
    // Create a new row
    row := oDT:NewRow()
    // Put data into the columns in the row
    FOR i := 1 UPTO FCount()
      row[ FIELDNAME(i) ] := AsString(FieldGet(i))
    NEXT
    // Add the row to the table
    oDT:Rows:Add(row)
    // Move to next record
    DbSkip()
  ENDDO

Voila, the first version of the BROWSE command is implemented in X#.
Hope this is of interest to (some) VFPers and (most) X#ers,

Thomas Ganss wrote: VERY nice for a on-a-moment solution! But as the "smart usage of client disk/resources via local tables/cursors" kept me in vfp for ages when ADO, ADO.NET, Python/Javascript in-memory-cursors returned from their DBAdapters were available in languages sporting nicer other OOP features. I expect (in the end) a solution where skipping in upmost parent of 7 to 12 tables all linked either via "set key" or "set relation" does not cascade into loading/showing 11 such memory tables when on disk everything is already done