FiveTech Software tech support forums

Assuming you are using FiveWin's TODBC class use its :execute() method passing the SQL command as its first parameter - all other parameters are optional.

This method returns .T. if the comand succeded or .F. if it failed. If the SQL command failed an error message is displyaed if :lShowError is ...

DispVals() is not receiving the oBrw parameter

In the sample program

replace

oBrw:bLine := { |o| DispVals(aArrayData,o) }

with

oBrw:bLine := { |o| DispVals(aArrayData,oBrw) }

Also, ensure that oBrw has been created and is passed t the function in which this line appears.

Vincent

Hi Colin

OK. Let me know how things go. I've done a lot of work with arrays in TWBrowse - it can be tricky.

Vincent

Can you send me the Application and Stack Calls sections from your error.log file.

At a guess, it sounds like this may be a parameter passing issue.

In the meantime, a few pointers which might help:

- DispVals() assumes a 2-dimensional array as follows: aArrayData[nRow][nCol]

- :aColSizes must ...

Have a look at the sample code below.

I am assuming you browsing a 2-dimensional array. In the sample each array element represents a line in the browse while each subarray represents a column, eg. aArrayData[nRow][nCol]

First thing to do is create a dummy browse using

@ 0,0 LISTBOX oBrw FIELDS ...

Is it the number of rows or the number of columns that change?

You need make a copy of the original FiveWin source in file SOURCE\CLASSES\TGET.PRG and amend methods KeyDown and GotFocus

Replace the line that reads
CreateCaret( ::hWnd, 0, 2, ::nGetChrHeight() )
with
CreateCaret( ::hWnd, 0, 6, ::nGetChrHeight() - 1 )
and vice versa.

Now compile and link the ...

Windows maintains a number of environment variables which might prove useful. Use the GetEnv() funtion to access these.

eg

GenEnv("ALLUSERSPROFILE")
GetEnv("APPDATA")
GetEnv("CommonProgramFiles")
GetEnv("HOMEDRIVE")+GetEnv("HOMEPATH")
GetEnv("USERPROFILE")