FiveTech Software tech support forums

... 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( hPairs )  ...

... 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 a result ...

... 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 SQLs SEEK and ...

... test simple calculation." pow := 2 ? "value =", VALUE ? "pow =", pow ? "value * pow =", VALUE * pow WAIT ? VALUE2 // generate RTE /*** testpp.prg ***/ REQUEST __PP_STDRULES REQUEST __WAIT PROC Main() local cLine, pPP, oErr pPP := __PP_INIT() BEGIN SEQUENCE ...

... = 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( (2)->KEY3 ) oAsc:SetText( (2)->VALUE3 ) ENDIF RETURN NIL Moving inside the table with ...

... 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.

... 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 la consulta ...

... 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

... 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" // LOW is ...

... 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

... Field Value1 = CONTAINERNUMBER Field Name2 = portlet_trackSimple_1{pageFlow.trackSimpleForm.numbers} Field Value2 = MAEU8279199 http://www.maerskline.com/appmanager/maerskline/public?portlet_quickentries_2wlw-select_key:{actionForm.trackType}=CONTAINERNUMBER&portlet_quickentries_2{actionForm.trackNo}=MAEU8279199&_nfpb=true&_nfls=false&_pageLabel=page_tracking3_trackSimple

Checking several preprocessor defined values:

#if defined( VALUE1 ) || defined( VALUE2 ) || ...

... Longitud+1 bytes BLOB, TEXT Longitud +2 bytes MEDIUMBLOB, MEDIUMTEXT Longitud +3 bytes LONGBLOB, LONGTEXT Longitud +4 bytes ENUM('value1','value2',...) 1 ó dos bytes dependiendo del número de valores SET('value1','value2',...) 1, 2, 3, 4 ó 8 bytes, dependiendo del número de valores Diferencia ...

... Longitud+1 bytes BLOB, TEXT Longitud +2 bytes MEDIUMBLOB, MEDIUMTEXT Longitud +3 bytes LONGBLOB, LONGTEXT Longitud +4 bytes ENUM('value1','value2',...) 1 ó dos bytes dependiendo del número de valores SET('value1','value2',...) 1, 2, 3, 4 ó 8 bytes, dependiendo del número de valores Diferencia ...

... i hve faced big problems in my software with it. The only reliable way i have found to test and make sure numbers are equal is : IF ABS(VALUE1 -VALUE2) < 0.009 Looks stupid but it has worked for me. HTH :D There is always a solution ! Richard Richard, Thanks again... It still does not work... ...