FiveTech Software tech support forums

You may use Mr. Carlos' function IncCount() with suitable modifications. Alernatively, I prefer a function using a different approach. function seq_nextval( cName )    oCn:Execute( "UPDATE sequences SET seq_value = LAST_INSERT_ID( seq_value + 1 )" + ;                 " WHERE seq_name...

Hello, can you show how the report should look. Why don't you use EasyReport. This is very easy with EasyReport. Best regards Otto Hi Otto, I use fastreport with dbf but I trying mariadb and someone told me to work with array resulting of query. I don't use EasyReport because all my reports are mad...

Hi,

Anyone have a sample how i can relationate 2 arrays (masterdata/detail) and pass to fastreport?

Thanks in advance

nageswaragunupudi wrote:

Thank you Carlos but no need to block and unblock the field like dbf table in lan enviroment?

SELECT ... FOR UPDATE
locks the record.

Thank you Nages in this case I need to treat the select return before save?

Here, i get the next counter value at save the data. FUNCTION IncCount( cTable, cField )    LOCAL oQryTmp    LOCAL nCount := 0    oQryTmp := oServer:Query( "SELECT " + cField + " FROM " + cTable + " FOR UPDATE" )    IF oQryTmp:RecCount() >= 0       nCount := oQryTmp:Fi...

nageswaragunupudi wrote:You can do exactly the same thing in MariaDB also.

Thank you Nages! Can you provide a sample to work with no problems in lan enviroment? I try using fivewin native mariadb functions/commands. I new in mariadb.

Hi guys, I have a dbf table that contains a field that controls the next number of an invoice for example. I block the registry, get the value, use, increase one, save the new value and unlock. How I do this control with mariadb? Field auto increment does not work because I want to have the option t...

Thank you guys!

Hi Guys,

How I can create a array with a mariadb query result to use in fastreport?

Thanks in advance.

Hi,

I have a array xbrowse, the first field is a logical than i can mark or unmark, how i can put a checkbox in header and how i control the status (mark or unmark).

Thanks in advance.

hmpaquito wrote:dbSeek() function permits lSoftSeek parameter.
obj:Seek() should permits too.

Code: Select all

dbSeek( <expKey>, [<lSoftSeek>], [<lFindLast>] ) → lFound

from https://harbour.github.io/doc/harbour.html#dbseek

Works great, thank you!

Hi,

How I can set a softseek in a object database?

oArqBol:SetOrder("EMISSAO")
oArqBol:GoTop()

here I want to set

oArqBol:Seek(Dtos(Data1))

Thanks in advance.

nageswaragunupudi wrote:

Code: Select all

oCol:bOnChange := { |oCol, uOldValue| yourfunction( oCol, uOldValue ) }

Thank you! Works great!

nageswaragunupudi wrote:Set oCol:nEditType := EDIT_GET. That makes the cell editable.
If you are not using a very old version of FWH, retotalling is automatically done by XBrowse.

When

Thanks for the answer but is not column totals, other totals in gets with many expressions. I want to do after edit the cell.

Hi,

I have a array xbrowse, how i can turn a cell editable and process a function when finish edit and make total this column?

Thanks in advance.