FiveTech Software tech support forums

... is what would be more or less And then in my web application, just like this ... myparameter: = PValue (1) Please call like this: index.prg?name1=value1&name2=value2 your index.prg function Main()   local hPairs :=  AP_Args()     ? ValToChar( ...

The problem doesn't belong to FASTEDIT to get it working (EDIT_GET) I added the following line :aCols[I]:bOnPostEdit := { | o, v | SAVE_VALUE1( oProj1, v, nColNo ), oProj1:Save() } the value is saved to the DBF after celledit -> return I didn't need this with FWH_19.06 but maybe the dialog / brow...

From xHarbour's doc: {=>} Literal hash. Syntax    {[<key1>] => [<value1>][,<keyN> => <valueN>]} Arguments <key1> .. <keyN> <key> is one or more key values to initialize the Hash with. Key ...

... HardCR(<cString>)->cConvertedString HardCR(<cString>)->cConvertedString Hash([<xKey1>,<xValue1>,[<xKeyN>,<xValueN>]])->hHash HB_ACmdLine()-><aArray> HB_ADel(<aArray>,<nElement>,[<lShrink>])->aTarget ...

... ... : standard sql &param1, &param2, .. : compatible with other libs In the case of named paratmers the array needs to be a multi-dim { { value1, value2, ..} ... } Option - 4: oRs := oCn:Call( cStoredProc, params, ... ) A RowSet can also be created by calling a Stored Procedure returning ...

I don't want to calculate the sum om the fields. For each name there is one time a field with parameter1, and I want to show the field in Value1 The functionality is not limited to SUM alone. SUM, AVG, MAX, MIN,STD etc MAX of a single value is the same value. Isn't it? Source of this function ...

Rao,

What is the query that used for the pivot view?
I don't want to calculate the sum om the fields. For each name there is one time a field with parameter1, and I want to show the field in Value1 for that name.

... are working Its translate to WHERE clause and DISTINCT CLAUSE in selects. :lol: We are now taking care of : SCOPES to SELECT WHERE field BETWEEN value1 AND value2 Index clause NEXT translate to TOP n but for ex Oracle its ROWNUM we are checking how to solve these diferences between different ...

... nCPos, "Col-position" ) // doesn't work on HORIZONTAL-move IF nCPos = 1 .or. nCpos = 2 oGet1:cText( (2)->KEY1 ) oAsc:SetText( (2)->VALUE1 ) ENDIF IF nCPos = 3 .or. nCpos = 4 oGet1:cText( (2)->KEY2 ) oAsc:SetText( (2)->VALUE2 ) ENDIF IF nCPos = 5 .or. nCpos = 6 oGet1:cText( ...

... carga aplicando el metodh Save(). Existe alguna fórmula para presentar la progress bar en un Query como INSERT INTO TABLE (field1, field2) VALUES (value1, value2)? Agradeceré mucho las respuestas.

... reading of the XML data. Please create a log file, at the same time that you save the data to the DBF, in example: LogFile( "log.txt", { value1, ..., valueN } ) alias->field1 := value1 etc... so we can see if the same error appears in log.txt

... no mas de 1000 registros a la vez (dependiendo de la tabla) visto desde mysql seria algo asi insert into table (field1, field2, field3) values (value1, value2, value3), (value1, value2, value3), (value1, value2, value3) si te fijas en un solo insert se incluyen 3 registros el metodo insert crea ...

... statements with multiple VALUES lists to insert several rows at a time. sql = "INSERT INTO your_table (field1, field2) VALUES ('string1', value1),('string2', value2),('string3', value3);" You can also use a free tool like dbf2sql: http://www.tkinformidia.net/uploads/1/2/0/0/12005968/dbf2sql-3.0.zip

... like You can see in the screenshot. LOW and AVERAGE is not added. There are allways 2 Values You get. The price-calculation would be : price := ( value1 * price1 ) + ( value2 * price2 ) You dont need to take care of the combination because if value2 = 0, * price2 is also 0. IF cSeason = "HIGHT" ...

... The whole record buffer is written to file after record cursor is "touched". This helps to avoid multiple disk access on: FIELD1 := value1 FIELD2 := value2 ... FIELDn := valuen Use DBCOMMIT() (or move record pointer DBSKIP(), DBGOTO(), etc.) to force write of record buffer. EMG