FiveTech Software tech support forums

Hi all
Thank Vilian
is also possible : oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `My_function()`)")

TO REMOVE
oCN:Execute("ALTER TABLE your_table DROP INDEX your_index")

TO CREATE
oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `field2`)")

... click event gets called, that is also the object for which the "modified" variable belongs to. I'm thinking one possible way would be to alter the report engine object which is something I was hoping to avoid. The other way I think it would be possible would be to write a harbour function ...

hi,

hmpaquito wrote:? command is translated to msgbox alert in fivewin.ch
A workaround is change ? command for Qout() function

AHA ...
thx for Workaroud

Hello Jimmy,
there is also fwlog function.

Best regards,
Otto

Hi Jimmy,

for debugging or log I use the following:
outside the Main function a static cLog := ""
Then all debug info I append to cLog += 'interesting info' + CRLF.
At the end I call msginfo( cLog ).

May be this could work for you too.
Regards,
Detlef

Hi,

? command is translated to msgbox alert in fivewin.ch

A workaround is change ? command for Qout() function

Regards

hi, for Debug i use   SET ALTER TO "_LOGIT2.TXT"   onDummy("Hello World")   SET ALTER TO  and Function FUNCTION onDummy()LOCAL iMax   := PCOUNT()LOCAL iLOCAL cText  := ""LOCAL xValue* ...

... fill gaps in auto-inc values due to deletions 2) reseed the auto-increment value to a higher value. Even for this, it is more appropriate to use ALTER TABLE command than inserting a higher value. El GetAutoIncrement(cTable) lo reemplace por una funcion propia simple: FUNCTION GetAutoIncrement(cTable,cField)RETURN ...

... in mysql is only for insert, update and delete statements? Yes. Only for DML statements, i.e., INSERT, UPDATE and DELETE statements Umm. Alter table.., etc. Is not supported in transaction? Yes. Not supported. One more important point to remember is that if at all we use any DDL statement ...

DATA lRaiseErrorDML INIT .f.
DATA lRaiseErrorALL INIT .f.

Ok rao.

But, transaction in mysql is only for insert, update and delete statements?

Umm. Alter table.., etc. Is not supported in transaction?

... : Read the first time with the function and retrieve the fieldnames. Vieuw them from a xbrowse and determent wich fields should be read as text (alter the array flag of header ?) The read a second time with the changed array and retrieve what i need. I know that changing the Exel file from digits ...

I tried emailing the .dll to Enrico but nowadays you can't send a .dll even you alter the extension.

You can send using www.wetransfer.com.
Even exe.

Hello;

I think you can download from here: https://transym.com/download/

I tried emailing the .dll to Enrico but nowadays you can't send a .dll even you alter the extension.

Let me know if download works for you.

Thank you,

Reinaldo.

... COLUMN_NAME='actaconformidad_mod' AND TABLE_NAME='formularios' " cQry := oServer:Query( cMsg ) If cQry:lastrec()=0 cMsg := "ALTER TABLE formularios " cMsg += "ADD COLUMN actaconformidad_mod VARCHAR(80) NULL AFTER actaconformidad" oServer:Execute( cMsg ) EndIf ...