FiveTech Software tech support forums

I used (4-5 years ago)

FW_SetUnicode( .t. )
oPQ:= TPQServer():New( cHost, BaseName, TableName, password, , "public")

... := {|k| If( k == 13, (msginfo("action") ), nil )  } how do i get "select" line with "Tablename" ( o:Value ) :?:

... pasa una contraseña vacía por referencia, el tipo de tabla, por ejemplo, BASE TABLE/VISTA/TEMPORARY es devuelta en el parámetro. - Methods RowSet(tablename), Insert, etc ..., no distinguen entre mayúsculas y minúsculas y ahora también admiten tablas temporales. - Method CreateTableSQL( cTable ...

... views. - If empty password is passed by reference, the table type, i.e., BASE TABLE/VIEW/TEMPORARY is returned in the parameter. - Methods RowSet(tablename), Insert, etc are case insensitive and now support temporary tables also. - Method CreateTableSQL( cTable ) --> SQL to create the table. ...

... we want to open a remote database table and retrieve a SQL query: http://www.fivetechsoft.com/webservice.php?database=test&tablename=users&username=fivetech&password=1234&sql=select%20* We get this: {"status":"ready","about":"FiveTech ...

... we want to open a remote database table and retrieve a SQL query: http://www.fivetechsoft.com/webservice.php?database=test&tablename=users&username=fivetech&password=1234&sql=select%20* We get this: {"status":"ready","about":"FiveTech ...

... $_GET;    echo json_encode( $response );?> We can try it this way: http://www.fivetechsoft.com/webservice.php?tablename=users And we get this: {"status":"ready","about":"FiveTech Software S.L. webservice","method":"GET","params":{"tablename":"users"}}

Saving an image to a blob field of mysql table using fwmaridb library: Inserting a new record: oCn:Insert( <tablename> , <blobfieldname>, { MEMOREAD( <imagefile> ) } ) Update (change) blob field in a record already existing in the table oCn:Insert( <tablename>, ...

... folder and look for folder "data". In this folder, we see each database as a subfolder. Within each subfolder, we see every table as <tablename>.ibd. Open this *.ibd in a hex editor and view all the data in the table in plain asci. https://imagizer.imageshack.com/v2/xq90/924/wfcAXq.png ...

... INDEX LIST TO que coincide con el nombre de la tabla. Conjuntos de registros de apertura más rápidos: SET RECORDSET OPEN WHERE CLAUSE A {{"TABLENAME", "SQL WHERE EXPRESSION"}} ADOWHERECLAUSE ADORDD función que nos permite cambiar el conjunto de registros cláusula WHERE al ...

... present in SET ADODBF MULTIBAG INDEX LIST TO that match the table name. Faster opening recordsets: SET RECORDSET OPEN WHERE CLAUSE TO { { "TABLENAME", "SQL WHERE EXPRESSION" } } ADOWHERECLAUSE ADORDD function allowing us to change the recordset WHERE clause on the fly keeping ...

Hi "select * from tablename where userid = '"+cUserId+"'" if tablename.rowcount > 0 fnCheckPassword() else MsgInfo('User Not Found') endif Hope this is what you meant. Colin Can you explain this a little more.. ...

Hi

"select * from tablename where userid = '"+cUserId+"'"
if tablename.rowcount > 0
fnCheckPassword()
else
MsgInfo('User Not Found')
endif

Hope this is what you meant.

Colin

... cSql ) was returning empty array when cSql does not return any rows. Now it returns NIL. - oCn:RowSet( cSql, ... ): Only SELECT and SHOW sqls or tablename are valid paramters to be used. Other cases runtime-error was occuring. Now NIL is returned in such cases and error is set as Invalid SQL. ...

... oRcs := oConexion:Query("") trabaja perfecto Release version: a) There is no Open() method. Suggested: oRs := oCn:RowSet( cSql/TableName ) or oRs := oCn:Query( cSql/TableName ) // alias method For compatible syntax with FW_OpenRecordSet(), we can also use oRs := mysql_RowSet( ...