FiveTech Software tech support forums

... CLIENT->(dbseek(COD_CLI+str(COD_NUM,2))) with MARIA DB oRS:seek(COD_CLI, COD_NUM) correct ? tia We are thinking of sorting and seek on compound expressions. We will announce this enhancement soon

... developed by Microsoft, primarily for use in their Windows operating system and applications like Microsoft Office. It allows users to create compound documents by embedding or linking objects (such as images, spreadsheets, or other documents) from one application into another. As OLE is a ...

Hi all,
I would like to know how to remove an index on a MySql MariaDatase table.
To create an index, the 'UNIQUE' clause is used. How to delete an index?

how to build compound index INDEX ON CLI_COD + STR(CLI_FAT,12,2) + DTOS(date())
TIA
Maurizio Menabue

James Rao made the same suggestion .. however, I do not want to de-encrypt and copy an entire table to an array or temp table .. because now I compound how many places I have to write updates .. If I add\edit or Delete a record .. I have to update a row or rows in the array and then write the ...

... a new index tag is created "INDEX ON RECNO() TAG RECYCLE FOR DELETED()". If the dbf is opened exclusively, this tag is added to the compound index and if opened in shared mode, this tag is created temporarily in memory. - TDatabase class adopts the same behavior while appending new ...

... DBF creation of these 3 index tags may take betwen 2 to 3 seconds. In any case this is one time job and these 3 tags would be included in the compound index. Note: Do not use expressions like DTOS(), FIELD->, etc. Now, set up the DBF like this: field ITEMDATElocal ...USE YOURDBF NEW SHARED ...

Patricio Just curious .. I hope you are using the compound Cdx and not a single or multiple Idx(s) ? If you are using Idx .. only the OPEN index will be updated .. otherwise using Cdx .. when you complete an Append or Edit a record .. are you issuing ...

... files with SET ADO PATH ON you need now to SET ADO ROOT PATH TO "NEW DRIVE PATH" INSTEAD OF "OLD DRIVE PATH" otherwise the compound table name "mypath_tablename" will not work anymore because adordd now tries to open "new_drive_path_tablename" that does ...

... One line gets you an open, indexed copy of your DBF! I do suggest that you always build your key index as the first index in every compound index. That way you can just do: ::setOrder(1) For any database and it will always be in key order. ------------- >Do you mean , once I ...

... 7. When encrypting/decrypting multiple records at once via Blowfish in a looping process like DO WHILE, you must first delete any controlling compound index, like a compound CDX index, or else the encrypting/decrypting will GPF after processing a few records or maybe even just one record. ...

... too long in function HB_FUNC_INTERNETFINDNEXTFILE Wrong number of arguments in call of macro hb_retl in function HB_FUNC_INTERNETFINDNEXTFILE Compound statement missing } in function HB_FUNC_INTERNETFINDNEXTFILE

... without a condition Alex Alex; True, you may execute SQL without a DD connection and still take advantage of indexes, but that's only true with compound indexes (cdx, adi). NTXs will not be used by the SQL engine since there is no way for the sql parser to be aware of those indexes. However, ...

... not allowed here in function ClearKeyboard Declaration syntax error in function ClearKeyboard Declaration missing in function ClearKeyboard Compound statement missing } in function ClearKeyboard uso xmate y xharbour gracias paco

John I put together a Sample program to open and index a FoxPro Database and compound index. I saw a couple of things I felt were wrong with your code .. 1) The .dbf and .cdx have to be the same name "Customer.dbf", "Customer.Cdx" but you can ...

Hello fraxzi, OrdKeyCount() I think gives back the items within an key. I need the number of key which are compound in on index file. For example: Test.dbf Test.cdx has following tags: tag u_datum tag u_datrg tag u_datart I would need as anwer 3 in this example. ordKeyCount() ...