FiveTech Software tech support forums

... nil  Same way even for storing large BLOB or TEXT data in MySql, MsSql or other databases, it can be done in one simple step. MYSQL Example (using FWHMYSQL and can be tested with FWH 17.01): Principle is the same for other libraries too. #include "fivewin.ch"function Main()   // ...

Hi,
oRs is a rowset object, that you can create doing something like this:

oRs := oBD:Query("SELECT * FROM customers")

I'm using editbaserecord, oRec AND oRs with FWHMYSQL. oBD IS a conecction WIth a MySql Server.

Thank you

From 18.04 we stopped considering :1, :2, ....:n as variables for substitution in ApplyParams() to avaoid confusion when the string contains values like "10:10:20".
&1, &2, ...&3 can still be used as in Dolphin.

This should resolve Mr. Vilian's issue.

This is happening in a very rare case where one of the fields in primary key is a "time" field and its value contains ":1" and the rowset is opened with parameters. A primary-key having such a field is very uncommon but in this case, primary-key is a composite key with one of the...

Please wait a little

This problem is disturbing my customers, because the record is saved, but the xbrowse is not updated.
Please, help me !!!

+1

Mr Rao. I have a xBrowse which I need to update with a different FwhMysql rowset. When I created it I do oDbDat:=oSvr:Rowset(xSelect) oBrow:setMysql(oDbDat,.T.,.T.) Later on I need to change the select (same fields, but different data), then I do. oDbNew:=oSvr:Rowset(NewSelect) ...

We are testing. We'll get back to you.

Did you make any progress ?

Here is It: #include "fivewin.ch"FUNCTION Main()   local oCn, oRs, cWhere,oBrw,oDlg,cSql   local cLog  := cFileSetExt( ExeName(), "log" )   oCn      := FW_DemoDB()   oCn:lLogErr := .t.   cWhere   := oCn:ApplyParams("WHERE esc.cemp = ? &quo...

Yes, you can.

There is no problem. How could I upload a table to this server ?

Can you prepare a small test program using any one of the tables on the FW demo server? If you run fwh\samples\maria01.prg, you see how to connect to the demo server and also see all the tables on the server. If you can make such a sample, that will be useful for all users. We may start with a sampl...